Profiler showed a SQL transaction called UpdateLoginStats before every Audit Login. The cause was the Common Criteria Compliance option I had turned on.
SQL SERVER – To Find Events Mapped to Channels in Extended Events
How exhaustive are Extended Events compared to Profiler? A DBA asked me, so here is how to find events mapped to channels in Extended Events.
SQL SERVER – Error Fix: Msg 300, VIEW SERVER STATE
Fix SQL Server Msg 300 when a user lacks VIEW SERVER STATE permission, and learn how to grant it safely without giving away too much access.
SQL SERVER – Trick – Running SSMS With Different Windows Account
Many admins have a regular and an admin login. Instead of logging off, here is a trick for running SSMS with a different Windows account on the same desktop.
SQL SERVER – Database Testing and Waitfor Delay – Notes from the Field #099
Kevin Hazzard shows how WAITFOR DELAY helps with database testing, like mocking procedures that simulate client data for ETL. Notes from the Field #099.
SQL SERVER – Why Should You Not to Use Old Style JOIN?
You can join tables with ANSI INNER JOIN or the old style JOIN in the WHERE clause. Here is an example that shows why you should avoid the old style JOIN.
SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results – Part 2
Every query in SSMS showed Command(s) completed successfully but no results. Here is the SSMS option I had changed that caused it, in part 2 of this story.