Monthly Archives: August 2013

Always Abstract

The way we build databases and design security is rarely done ideally. It doesn’t matter what your Utopian design is for schemas and objects; most of us make compromise as we deal with the pressures and diverse requirements thrust upon us in … Continue reading

Posted in Editorial | Tagged | 1 Comment

Guidance

How do you manage SQL Server? Do you have a list of rules that tell you to do yy whenever xx happens? Or if yy doesn’t solve the problem, you next try zz? Some of you have guidelines like that, … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Guidance

Restoring a TDE Database on a New Instance

You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get this database working on a new instance? This short post will show you how this works. Files Needed There are … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Restoring a TDE Database on a New Instance

Opinions and Votes

When you work with a vendor, you may report bugs, issues, or strange behaviors in software. These area facts, and are valuable pieces of information that vendors do care about. When you exclaim that a particular bug or missing feature … Continue reading

Posted in Editorial | Tagged | Comments Off on Opinions and Votes