Monthly Archives: April 2016

MDF File Password Confusion

Posted on April 7, 2016 by way0utwest

I had never seen this, but I ran across a blog that mentioned an MDF File password here. The post really looks at ways to reset the administrator password for the “sa” account in SQL Server. However it has some … Continue reading →

Posted in Blog | Tagged , , | Comments Off on MDF File Password Confusion

Quick Encryption with Always Encrypted

Posted on April 6, 2016 by way0utwest

What do you need to do in order to access data in a SQL Server that’s encrypted with Always Encrypted? It’s not much, and it’s really simple. The certificate used for encryption A parameter in the connection string That’s it. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Quick Encryption with Always Encrypted

Track Your Consultants

Posted on April 5, 2016 by way0utwest

If you pay attention to security issues in software, you’ve probably heard about man-in-the-middle attacks. These can occur more frequently than you expect, though inside of a company, it’s more unlikely that you’ll experience one if you have some fairly basic … Continue reading →

Posted in Editorial | Tagged | Comments Off on Track Your Consultants

Locking sa

Posted on April 4, 2016 by way0utwest

When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the default account for many DBAs and as a result, it couldn’t be locked out. This changed in SQL Server 2005, … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Locking sa