RYO Maintenance Plan – Integrity Checks

Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it...

Slides & Samples from my SQLSaturday #115 presentation about ColumnStore Indexes

As I have announced in my ColumnStore presentation last Saturday in Lisbon, you can
find here the slides
& samples for download....

SQL Server 2012: xVelocity

After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature...

TDE and Compression

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

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...

1 year old sandwich

It's been an interesting day. It was the 1 year anniversary of SQLSandwiches today. It was also my last day working...

Gardens and Scarecrows

A few weeks ago I started clearing space for a small garden. Tedious work due to the area of the...