Category Archives: SQL Server

Like a wild-haired puppeteer pulling hundreds of strings at once to produce a uniform, if not terrifying, puppet show, SQL Server pulls your database strings to ensure you’re retrieving the data you need when you need it. Learn how to optimize Microsoft’s tool for complex applications like SharePoint.

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

SharePointing SQL Server: The Next Byte

  If you’re all caught up on my first post regarding Installing & Configuring SQL Server for SharePoint Farms, then let’s happily move forward with my next installment of “SharePointing SQL Server: The Next Byte…” Hello everyone! The sun is shining … Continue reading

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

Installing & Configuring SQL Server for SharePoint Farms

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