Skip to content
Tracy Boggiano's Blog

Tracy Boggiano's Blog

Musing on more than data, trying to make a difference somewhere…

  • Home
  • About Me
  • Presentations
  • Events
  • DEI Virtual Group
  • Speaking Mentors
  • TriPass
  • WITspiration
  • Mental Health Resources
  • DBA Resources

Month: April 2014

  • Home
  • 2014
  • April
T-SQL Tuesday
Miscellaneous T-SQL Tuesday

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

April 8, 2014September 8, 2022By Tracy Boggiano

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

Recent Posts

  • Looking Back at 2025: Volunteering Is My Way of Life January 9, 2026
  • Living with Chronic Suicidal Thoughts: A Personal Reflection November 20, 2024
  • MVP No more, But It’s OK July 12, 2024
  • Presenting at PASS Summit 2023 – Atomic Habits July 26, 2023
  • Twenty Years as a Guardian ad Litem June 26, 2023

Categories

  • Automation (24)
  • Exam Prep (9)
  • High Availability/Disaster Recovery (5)
  • Mental Health (14)
  • Miscellaneous (51)
  • Performance (14)
  • PowerShell (7)
  • Scripts (23)
  • Security (8)
  • SQLskills (1)
  • T-SQL Tuesday (32)
  • Training (4)
All Rights Reserved 2022.
Proudly powered by WordPress | Theme: Saya by Candid Themes.