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.

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

Sneak Preview: New Features in Microsoft SQL Server 2012

(Don Conrad, a.k.a. “Don SQL”, is Fpweb.net’s resident database wizard and expert in all things Microsoft SQL related. In this post he examines the next version of SQL Server. Missed an installment of The Next Byte? Check out Don’s complete … Continue reading

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