Category Archives: Security

Dastardly database (and password) hiding

I’ve been recently going through the first part of one of Redgate’s excellent free ebooks “The Red Gate Guide to SQL Server Team-based Development” and was rather amused when I came across the section talking about creating what they term … Continue reading

Posted in Security, SQL, SQLServerPedia Syndication | Tagged

Use protection to stay available

One of the biggest worries for us grumpy DBAs are the risks which are posed to us due to our reliance on other teams, specialists and technologies in order to maintain a working and efficient SQL Server infrastructure. This was … Continue reading

Posted in Security, SQLServerPedia Syndication, Windows | Tagged , , | 2 Comments

Stub out your bad practices when deploying object promotions

When a script is deployed in your production environment, how is it deployed? Are the scripts written to account for the object already existing and if so what actions are taken? But what if the object doesn’t exist, what then? … Continue reading

Posted in Security, SQL, SQLServerPedia Syndication | Tagged , , ,