Storage Checklist FAQ

In a new data centre build, storage system or new equipment, the DBA should have an input into the architecture...

Microsoft SQL Server Parallel Data Warehouse (PDW) Explained

Microsoft SQL Server Parallel Data Warehouse (PDW), formally called by its code name “Project Madison”, is an edition of Microsoft’s SQL Server...

On the Road Again – SQL Saturday #90

I’m leaving this morning for Oklahoma City for SQL Saturday #90. This is my first time traveling to Oklahoma City...

Re-blog – August 19-August 25

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

Session Files for Replication Magic Presentation to WSSUG

Session Files for Replication Magic Presentation to WSSUG
Replication Magic

I presented my session on Replication Magic: Initializing from Backup to the...

Side by Side installation of SQL Server 2008 and SQL Server 2008 R2

Recently I had to install SQL SERVER 2008 R2 BIDS on top of a machine which already had SQL SERVER...

SQLMCM Training – Day 18

Today we covered the topics Full Text Search, Change Data Capture, Change Tracking,
and Service Broker. I have taken no notes...

Building A New Storage Test Server

We’re Gonna Need A Bigger Boat
Not to sound too obvious, I test IO systems. That means from time to time...

Create a Log Backup Schedule – #1 Skill You Need

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...

Index Disabled and Index Rebuild

I received the following message from a Developer. The message was on a Test SQL Server
 “NC_myIndex " on table "VeryLargeTable" (specified...