Tag Archives: sql server

Changing the sa Password with SSMS–#SQLNewBlogger

Posted on April 11, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wanted to make a quick note on changing the sa password, as this is a sensitive account, and … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Changing the sa Password with SSMS–#SQLNewBlogger

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