Tag Archives: 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

Wow. Just Wow

Posted on November 21, 2016 by way0utwest

Wow. Just Wow. Yes, I meant to use a capital letter there. The Red Cross’ Blood Service in Australia had database backups on a website that anyone could access. That means that anyone could download the backup, which contained PII … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Wow. Just Wow

Creating a Logon Trigger–#SQLNewBlogger

Posted on October 20, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Suppose you want to audit logins for your SQL Server instance. There are multiple ways to do this, but … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Who’s Touching My Database

Posted on October 11, 2016 by way0utwest

Abstract: As databases become more critical to the operation of our organizations, we are being asked to audit and report on access to both data and the configuration of our systems. SQL Server has a number of features that can … Continue reading →

Posted in Presentations | Tagged , , | Comments Off on Who’s Touching My Database