Tracy Boggiano's SQL Server  Blog Rotating Header Image

April, 2014:

T-SQL Tuesday #53 – Why So Serious? No SQL Authenication Use Your Own Account

At a previous job I had several developers that had passwords for SQL authenticated accounts for systems that would give them more access than they needed when they had Windows accounts that would give them enough to troubleshoot issues.  Our trick was to write a login trigger that would block any SQL Authentication accounts that […]