Tag Archives: security

Enable Transparent Data Encryption

Posted on August 28, 2012 by way0utwest

This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do, and it’s rather mechanical, so I just show the image that has the steps from MSDN and leave it at … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment

Make a Backup First

Posted on August 22, 2012 by way0utwest

I was reading in detail about the Apple / Amazon hack that targeted a Gizmodo writer.  A hacker used a few techniques to get from his Amazon account to his Apple account, his GMail, Twitter, and more. His iPhone, iPad, and Macbook … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Make a Backup First

Where’s My Certificate Backup?

Posted on August 16, 2012 by way0utwest

If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner, and if I need to move the instance somewhere else, all my code works. No pathing issues. A certificate backup … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Where’s My Certificate Backup?

Separate Accounts

Posted on August 10, 2012 by way0utwest

Many years ago I worked in a small company that only had about 5 or 6 servers. We had one system administrator whose job it was to manage all the servers. One day our sysadmin was on vacation when there … Continue reading →

Posted in Editorial | Tagged , | 1 Comment