Tag Archives: security

Do I have a Database Master Key in a database? #SQLNewBlogger

Posted on January 13, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How can I tell if I have a Database Master Key in a database? It’s actually easy. I query … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Do I have a Database Master Key in a database? #SQLNewBlogger

Securing Your Instances

Posted on January 13, 2017 by way0utwest

I wrote a post about finding the port number of a SQL instance using PowerShell. Almost immediately I was taken to task by someone that noted port scanners can easily find SQL ports, so it’s silly to move off 1433. … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Securing Your Instances

Backup Data Security

Posted on January 12, 2017 by way0utwest

It seems there is no end to the insecure ways in which people manage data. I haven’t seen this one before, but I’m sure it’s happened. In fact, I bet it’s happening right now in more than one company. A … Continue reading →

Posted in Editorial | Tagged | Comments Off on Backup Data Security

Post TDE–Getting Unencrypted Backups

Posted on December 28, 2016 by way0utwest

I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup. This doesn’t seem like that should be an issue, but it can be. A little testing shows how. Let’s assume … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments