Tag Archives: SQL Server

Last updated by at .

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

SQL Server Files and Filegroups: A conversation

Discussing SQL Server Files and Filegroups                 What are they?                 Why are they important?                 What do I … Continue reading

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

SQL Server: Understanding Log Files

Welcome to The Next Byte.  The Gentle Care and Feeding of Log files: What are log files and why do we care? How are log files configured? What else do we need to know about log files? In the beginning, … Continue reading

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

Troubleshooting SharePoint Sluggishness
(Server Side Issues)

Hello everyone! Summer is all around us… The sun is shining bright. The sky’s clear. The birds are chirping. Let’s talk about some fun things such as: “SharePointing” SQL Server! You’re thinking: Wow! That sounds like fun, but what is … Continue reading

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

New Features in Microsoft SQL Server 2012

(Welcome to The Next Byte, a series on Microsoft SharePoint and SQL Server written by Don Conrad, a.k.a. “Don SQL”, the Fpweb.net SharePoint database wizard and expert in all things SQL-related. In this post Don examines new features in SQL … Continue reading

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