In SQL Server, using the KILL
command to terminate a session results in an entry being logged in the error log.
This raises the question: Does the ALTER INDEX REBUILD
command with the WAIT_AT_LOW_PRIORITY
option also log its actions in the error log?
This month’s invitation is from Grant Fritchey, inviting us to talk about one of my favourite tools in SQL Server - the Extended Events.
Read a cautionary tale on how I’ve deceived the SSMS, then promptly forgot about it and, in turn, ultimately confused myself.
I’m using SQL and KQL to solve Advent of Code puzzles this year. It’s an annual event in which participants solve a series of increasingly complex challenges.
This blog post will show you how to find and affect the default Extended event file target’s path.
Wrap up post for November’s T-SQL Tuesday about what makes code production grade.
There are many qualities of a production-grade code, but this one is the most important to me.