Don't touch that Maintenance Plan Job

Good ol Maintenance plans. With 2005 and beyond we received the glorious SSIS backed Maintenance plans. I love SSIS so...

SQLcruise review

The most amazing journey that I have done in the past years was definitely SQLcruise
(see http://www.sqlcruise.com) – a SQL Server
event organized...

Database Owner - Error Message

Sometimes, a simple task that as a DBA you do day in and day out,
can throw wierd errors.

You...

Tampa SharePoint Saturday 2011

I presented a 75 minute session at Tampa SharePoint Saturday on PowerShell Basics.
The presentation and demo scripts can be found...

I am back

I am back again!!!. It has been ages since I posted.An important event in my life kept me away from...

Some Good SQL-Related YouTube Videos

A brief discussion and links to a series of YouTube videos from Stéphane Faroult.
I’ll continue the discussion of the table...

SQL Dream Cars

A mini debate on Twitter the other day got me thinking about cars. People that know me know I like...

Planes Trains and Automobiles

I was going to write a short post showing some useful queries that can help you manage your vCentre environment,...

Statistics IO parser in Ruby & Python

Here I am working on tuning a rather large stored procedure; old school.  I have statistics IO and showplan turned on.  I work through the obvious missing indexes and improper...

Statistics IO parser in Ruby & Python

Here I am working on tuning a rather large stored procedure; old school.  I
have statistics IO and showplan turned on.  I work through the obvious
missing indexes and improper joins and now...