Tag Archives: security

High Security Prices–Always Encrypted 2019 needs Datacenter Edition

I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and then encountered this issue: After embarrassing myself to other MVPs and … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Long Live All Passwords

I remember the first time I had to create a password for a system. It was an application that a friend and I wrote, and we wanted to separate the ways that we stored data, so we added a login … Continue reading

Posted in Editorial | Tagged | Leave a comment

Clearing an Email from the Microsoft Directory

Years ago I was working on a demo with Microsoft and someone added me to their VSTS (now Azure DevOps) project. Somehow, I got an account in the Live/Passport/Joe-Schmo Azure directory with my red-gate.com email. This hasn’t been a problem … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Always Use Roles–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Which of these is more complex? GRANT SELECT ON dbo.Customer TO JoeDev or CREATE ROLE SalesGRANT SELECT ON dbo.Customer … Continue reading

Posted in Blog | Tagged , , | 2 Comments