Monthly Archives: January 2017

Disabling #sqlprompt Formatting

Posted on January 31, 2017 by

I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want code reformatted. One great example is when I write INSERT statements. Here’s what I might write: INSERT dbo.Payments_A   ( … Continue reading →

Posted in Blog | Tagged , , ,

A Wide Variation in Skill

Posted on January 31, 2017 by

I was helping someone recently clear up some confusion about the encryption structure of their TDE databases. This individual wasn’t sure about how the various keys were used, which ones needed to be backed up, and which keys needed to … Continue reading →

Posted in Editorial | Tagged | 2 Comments

#ReadyRoll at #SQLintheCity

Posted on January 30, 2017 by

When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source Control and DLM Automation work really well to bundle up changes in a VCS and easily deploy them. However, as … Continue reading →

Posted in Blog | Tagged , ,

The New DBA is a Developer

Posted on January 30, 2017 by

I was reading a short piece from Mike Fal recently and it struck a chord with me. I started working with computers as a developer, really a hack programmer as a kid. Friends and I would build small games or … Continue reading →

Posted in Editorial | Tagged | 2 Comments