should I use clustering on a VM?

ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
If you want prescriptive...

Significant Achievements

As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...

The Last DBCC CHECKDB Date and Restores

I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For...

Tip: OVER and PARTITION BY

I like to repost this blog about once a  year, because you really really need to know about windowing functions....

WIT Wednesday

On the fourth Wednesday of each month, the Women in Technology Virtual Chapter of PASS has its monthly conference call...

Are Your Protecting Your DB Backups?

Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...

Billing rates – other side of the fence

The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...

Explore file physical structure - Delete

1. Create sample db

use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB...

One Interview question. Many Answers

Conducting technical interview is an art.
Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL...

SQL Server 2008 Diagnostic Information Queries (Nov 2012)

Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...