Tag Archives: sql server

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

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

Examining SQL Server 2016

Posted on March 29, 2016 by way0utwest

SQL Sever 2016 is getting close to release. The updates are coming fast and furious, causing issues in some cases as many people look to test the new features in different environments. Personally, I’m struggling a bit to determine which … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Examining SQL Server 2016