Tag Archives: sql server

Creating a Symmetric Key–#SQLNewBlogger

Posted on June 2, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a series on working with the various encryption technologies in SQL Server. One of the encryption technologies … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Creating a Symmetric Key–#SQLNewBlogger

A Basic Encryption Primer for SQL Server

Posted on May 26, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Encryption is a function call in SQL Server, where we pass in the text to encrypt and a key. … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Removing SA from Azure SQL Database

Posted on March 23, 2021 by way0utwest

One of the recommendations from Microsoft SQL Server is to use Windows authentication. This has been in the docs for years, and I’ve heard many MS consultants and employees note this. Many customers and clients have tried to use Windows … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Removing SA from Azure SQL Database

Security Updates for SQL Server Jan 2021–CVE-2021-1636

Posted on January 13, 2021 by way0utwest

There was a security bulletin (CVE-2021-1636) for SQL Server, an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running. SQL Server has released a number of patches. You can see them on the Release … Continue reading →

Posted in Blog | Tagged , , | 2 Comments