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...

PASS Update #63 (How Do We Rate)

A short update today, following up on an email to the Board from incoming VP of Finance Douglas McDowell who...

Reading SQL Error log

SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not...

SQL Server – CTP is now available for SQL Server 2008 Service Pack 3

CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog...