Primer If you haven’t already read up on cooperative and preemptive scheduling or aren’t sure what those are, please read…
I am often asked about all kinds of various errors, of course with absolutely no context. I also get asked…
The Dude I get asked if I know anything about <newest SQL vulnerability as reported by random website>, quite often.…
You’ve Asked, It’s Now Here! The largest complaint, by far, for Availability Groups (AG) has been that system databases could…
It’s Great When No One Asks Questions You’re taking the best steps to track what goes on in your instance…
Many DBAs haven’t had the experience of using database mirroring, since it was deprecated in 2012 when availability groups were…
I’ve been writing some technical, some troubleshooting, but all items that come up often enough without a resource that when…
Hey Dispatch, We Have a Code 8 If you’ve been following with the series of demystifying dumps then you’re probably…
What’s an IOCP? IO Completion Ports are a set of Windows APIs which allow for efficient, fast, multithreaded asynchronous IO.…
Initially I thought to myself, “this is the most misunderstood wait type that exists in the HA space for SQL…