Using PowerShell For More Readable Log Files

Most of the scheduled jobs on my SQL Servers write some sort of output to a log file. Most of the time, it’s just the output of a SQL statement. However, for some of my longer, more complicated routines, the procedures I write include PRINT statements to output various statuses or progress messages while the […]

SYS.DM_EXEC_REQUESTS Changes Between Versions Of SQL Server

I was recently doing some work with a backup verification routine that is meant to run on various versions of SQL Server and came across some variations in the way the RESTORE VERIFYONLY command is reported by sys.dm_exec_requests between SQL Server 2005, 2008 R2, and 2012. I haven’t seen this mentioned anywhere, so I thought […]

Disabling An Index Removes Index Data

DBAs gained the ability to disable indexes in SQL Server 2005. This is a handy little option when you are tuning indexes or consolidating indexes. When you disable an index, you tell SQL Server to basically pretend the index doesn’t exist. Data changes made to the underlying tables are not reflected in the disabled index. […]

New Online Course: SQL Server Maintenance Plans

I’m pleased to announce my new online course is now up and available: SQL Server Maintenance Plans. This course is almost 2 hours long and covers every aspect of SQL Server’s maintenance plans. You’ll learn what each and every task does and you’ll see examples of how to create plans using both the Maintenance Plan […]