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

T-SQL Tuesday

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 were logged in with SSMS.  Many a developer fell pry to our logon trigger and because of the severity of the message did not quite understand why.  This made my troubleshooting life easy because I didn’t have to figure out if a developer ran something to fix something or if something legitimate was broke.  Of course I made sure to not block my sa account just in case I needed it.

Tracy Boggiano
Follow me

Tracy Boggiano

Database Administrator at ChannelAdvisor
Tracy has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Platform. She has worked on SQL Server 6.5 and up including currently SQL 2017 CTP 2.0. She enjoys monitoring, performance tuning, and disaster recovery technologies.

She also tinkered with databases in middle school to keep her baseball card collection organized.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through http://www.casaforchildren.org.
Tracy Boggiano
Follow me