I show how to use a DDL trigger to capture index changes.

I explain how I use PowerShell to collect performance monitor counters at scale.

Experience a DBA's trial and error method of getting some PowerShell automation working.

Tip : Avoid External Dependencies in SQL Server Triggers

Hugo Kornelis has suggested that SQL Server's proprietary UPDATE FROM and DELETE FROM should be deprecated (in favor of MERGE). I disagree.

Some details around why you can't restore or attach a database to an older version of SQL Server.

Tip : Identify SQL Servers with inefficient power plans using Policy Based Management

For T-SQL Tuesday, I talk about my resolutions for 2011, including getting better at rehearsing presentations.

If you're not living in a cave, you are probably aware of the blog posts and twitter discussions that resulted from an innocent post by...