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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
Interview Question of the Week #040 – Difference Between Unique Index vs Unique Constraint
Compare index vs unique constraint behavior, test filtered uniqueness and NULLs, inspect catalog flags, and remove each object correctly.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.