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 , , | 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 , , | Leave a comment

A Double Failure

Every server ought to have a password. Every one. It’s 2019, and apparently that advice hasn’t sunken in. I still can’t believe there are people without passwords/codes on their mobile devices or home PCs, but there are. It’s crazy, and … Continue reading

Posted in Editorial | Tagged | Leave a comment