TDE and Compression

I knew that enabling TDE would cause the information stored within to, effectively, be randomized, which means it would seriously...

24-Hours of PASS - Be on-time!

Right on the heels of the recent SQL Server 2012 virtual online launch event (as in virtually not there :-), a...

Another Interesting Sort

Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:

Creative Database Naming January 2, 2020...

Another Interesting Sort

In October of 2011, I shared an example of a peculiar set of sort requirements.  Today, I am going to...

Troubleshooting Event ID 9 - The device, xxxxx, did not respond within the timeout period.

The System logs returned :
 The device, xxxxxxxxxxxxxx, did not respond within the timeout period.
 Some common causes
1)      SCSI controller  firmware
2)      Incorrect...

Activity Monitor in SQL Server 2012: an Improved Embedded Optimisation Gizmo for the Thrifty DBA

Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen...

Avoid Database Restore Issues (Errors 3219 or 3514) by a Simple Script Edit - the DB Restore Work-around

Starting with the 1000 foot view: During the process of applying changes to a production database - let's call it Change...

Rules of Thumb in Physical Database Design
I am starting my first post in my blog of tuning the physical database...

Re-blog – March 9 – March 15

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SQL Server 2012: New Certification Info

As a follow-up to my posts SQL Server “Denali”: New Certifications and SQL Server 2012: New Certifications, there are now final details coming...