I ran SQL Server setup on a domain controller by mistake, and the Installation Failed at ‘Wait on the Database Engine recovery handle’. Here is what fixed it.
SQL SERVER – What is the OVER Clause? – Notes from the Field #101
The OVER Clause arrived in SQL Server 2005, yet few know all its uses. In Notes from the Field #101, Kathi Kellenberger explains it with window functions.
Interview Question of the Week #043 – What is the Difference Between EXCEPT operator vs. NOT IN
Compare EXCEPT operator vs. NOT IN using NULL and duplicate examples, add NOT EXISTS, and inspect actual SQL Server anti-join plans.
The Milestone – Notes from the Field #100
The 100th episode of Notes from the Field is a true milestone. A thank you to the experts who shared real-world lessons with all of us.
Plan Guides: Fixing a Query You Cannot Change
Apply plan guides to a parameterized query you cannot edit, validate the guide, confirm plan matching, and compare Query Store hints.
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.