Microsoft – Follow best practices!

Best practice is to use parametrized queries to enable plan reuse.  Will someone please tell Microsoft this. 
Presently dm_exec_cached_plans on...

SSIS Checkpoints with Tasks Running in Parallel

 
Several months ago I blogged about why Checkpoints are a great feature in SSIS to use.  It seems with every...

Andy on Twitter

Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...

Azure platform CTP accounts are about to expire?

I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...

Creating the SSC Maintenance Plan: Part 3

Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...

Getting here from there

Another month, another blog chain, this time started by Paul Randal. I got tagged by both Grant and Steve, on...

How Do You Handle the Stress of Being a DBA?

This is a reprint of my editorial at SQLServerCentral.com. There is a lively discussion at the SSC forum on this...

Instant File Initialisation

I have been reading up on instant file initialization and I have read a couple of good blog posts by...

Part 3: Creating the SSC Maintenance Plan

Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...

PASS Virtual Meeting - Zero to Cube in 60 Minutes

PASS Virtual Meeting

Speaker: Adam Jorgensen

Topic: Zero to cube in 60 Minutes

Date and Time: 1/22/2010 12:00 PM EST

Meeting URL: Join Meeting

Description:...