Tag Archives: sql server

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

Patch Problems

I ran across this article a week or so ago, but hadn’t had a chance to put anything out. There were three patches put out in July for various products that caused issues with other software, one of which was SQL Server.  can … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Patch Problems

Would You Choose SQL Server?

I recently wrote a piece on the limitations of the Standard Edition (SE) of SQL Server and got an interesting comment from Brent Ozar. He asked me a question as a businessperson that I found intriguing and it’s one I thought might be … Continue reading

Posted in Editorial | Tagged , | 1 Comment