New Online Course: Understanding Data Compression In SQL Server

My new online course is now up and available: Understanding Data Compression in SQL Server. This course is almost 1.5 hours long and covers the technical details of how Data Compression in SQL Server works and when and how to implement it. The course includes demo scripts and examples. From now until December 31, 2013, […]

Monitoring For Endless Index Defragmenting

You are an awesome DBA. You have complete control over your dominion. You have all your backups automated and the testing of those backups is automated. You have alerts properly configured on all your servers. You have your index maintenance plans running regularly. You ride a unicorn to the office and George Hamilton asks you […]

Enabling Data Compression – October 2013 Update

Note: For more details about this script and the variables and outputs, see my post here. I’ve made two changes to my script that checks for new database objects to compress. First, it will now enclose table and index names in square brackets to prevent errors with object names that are also keywords or include […]