Monthly Archives: January 2017

Disabling #sqlprompt Formatting

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

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

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

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