Tag Archives: sql server

Renewed

I received my fourth (or fifth?) renewal notice as a Microsoft MVP this morning. I am proud to be recognized as contributing to the SQL Server community. Thanks to everyone that reads my work or comes to see me speak … Continue reading

Posted in Blog | Tagged , | 3 Comments

The Data Resolutions

Making a new year’s resolution is an annual tradition for many people on January 1. Breaking those resolutions seems to be another annual tradition that often takes place during the month of January as we struggle to live up to … Continue reading

Posted in Editorial | Tagged , , , | 2 Comments

How Many Calls? Part 2

I wrote recently about a report that a friend of mine needed from his Access database. In the first post, I used a CTE and an outer join to cull together some data, however since I wasn’t sure Access would … Continue reading

Posted in Blog | Tagged , , | Comments Off on How Many Calls? Part 2

Backing up the Service Master Key

Making a backup of your Service Master Key (SMK) should be one of the first things that you do if you are enabling encryption. This key encrypts and secures your other keys, and it will be needed when you have … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Backing up the Service Master Key