Tag Archives: SQL

Dedicated Cloud Servers for Your Business

Dedicated cloud servers make it your cloud, not a public one. Fpweb.net presents a private cloud server that works for you. Built to withstand even the largest enterprise needs, our managed cloud servers offer a robust connection and the performance … Continue reading

Posted in Cloud Hosting | Tagged , , , , , , , , , , | Leave a comment

Using the Performance Analysis of Logs (PAL) Tool

The Performance Analysis of Logs (PAL) Tool is an extremely useful tool that provides a baseline of performance metrics of many Microsoft products. PAL can be useful as a starting point when troubleshooting possible causes of degraded performance. Used with … Continue reading

Posted in SQL Server | Tagged , , , , , , , , | 1 Comment

SQL Express to SQL Server Standard: In-Place Upgrade

Did you know you can perform an in-place upgrade from SQL Express to SQL Server? As you can imagine, we’ve seen a lot here at Fpweb.net. Over SharePoint’s 15-plus years, we’ve found solutions that fit for countless SharePoint farms, many … Continue reading

Posted in SQL Server | Tagged , , , , , , , , | 18 Comments

How to Perform an Unplanned Database Migration

In my last blog entry, I discussed using SQL aliases to configure a SharePoint farm for easy scalability. By using a SQL alias to point towards the SQL Server where the SharePoint config database resides, you create an easy and … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , , | 2 Comments

Understanding AlwaysOn & Mirroring with SQL Server 2012

Today, we dig back into SQL Server 2012 to look at AlwaysOn, Clustering, Log Shipping , Mirroring , Replication & Snap Shots, focusing on the what, the why and the who cares! I’ve been asked about these different items repeatedly … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , | 7 Comments

Troubleshooting SharePoint Sluggishness
(Server Side Issues)

…THE NEXT BYTE The Next Byte is our series of posts about the relationship between SQL Server 2008 and Microsoft SharePoint, written by database administrator Don Conrad. Missed the last post? Please read “Microsoft SQL Server: The Database Behind SharePoint”. … Continue reading

Posted in SQL Server | Tagged , , , , , , , , | Leave a comment

Microsoft SQL Server: The Database Behind SharePoint

… THE NEXT BYTE A high-level overview of what databases are, and how SQL Server fits the mold. What is a database? Why do we need one? How does SQL Server fit the mold?

Posted in SQL Server | Tagged , , , , , , , , , , , , | 1 Comment