Tag Archives: security

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 | Comments Off on Long Live All Passwords

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 , , | Comments Off on Clearing an Email from the Microsoft Directory

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

A Double Failure

Update: Perhaps not, as Evisort dispute any customer data was exposed and they’ve updated security. 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 … Continue reading

Posted in Editorial | Tagged | Comments Off on A Double Failure