Tag Archives: administration

Multiple Backup Files

Posted on January 9, 2015 by way0utwest

I’ve been writing a little PowerShell lately that will back up databases, move files, and restore them. I’m often testing things, and having scripts to quickly and easily move files is very handy. After one of my posts recently, a … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments

Test Your Situation

Posted on January 7, 2015 by way0utwest

I gave a talk on Transparent Data Encryption (TDE) recently and a number of people in the audience were using the feature. However when I asked how many of them had restored a TDE database, not all hands remained up. … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Test Your Situation

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