Tag Archives: administration

Recovering from Bad Deployments

Posted on January 6, 2015 by way0utwest

Someone asked me recently if I stored backups of my database in version control. This person wanted to recover from a bad deployment and use a backup to do so. They felt that keeping a copy of the backup in … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Recovering from Bad Deployments

Beware of Login Issues for Privileged Accounts

Posted on January 5, 2015 by way0utwest

In a recent post, I described an attack against a privileged account using a simple SQL Injection technique of updating data in a table. One of the things showed was an administrator using their user and password credentials, but being … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Beware of Login Issues for Privileged Accounts

Powershell – Copy the Latest Backup

Posted on December 29, 2014 by way0utwest

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess I’d written something about this in 2009, though that would have been for testing as Red Gate had already banned … Continue reading →

Posted in Blog | Tagged , , , , | 5 Comments

Drop and Recreate

Posted on December 15, 2014 by way0utwest

Those of you that manage replicated environments have learned to have one thing handy: a script that recreates your replicated publishers, distributors, and subscribers. I was reminded of my past needs for those scripts recently when I saw this post on … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Drop and Recreate