Instant File Initialisation

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

PowerShell Script for Creating Indexes

I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...

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

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

Speaking at SQL Saturday Tampa and Richmond

Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...

SQLSaturday #32 – Tampa

Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd).  This will be my 5th SQLSaturday...

SQL Server 2008 - Top Reasons to Upgrade.....

OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...

Andy on Twitter

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

Using sp_ExecuteSql to Run Dynamic SQL

Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...

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