This post is based on a document I wrote a long time ago as part of my DBA knowledge transfer to other DBAs. It’s also goes hand in hand with a question I like to ask in interviews: ‘Someone has raised a ticket with your IT Service Desk and assigned Continue Reading
Monitoring
2 Great Extended Event Sessions
I hate SQL Profiler. It’s clunky, slow, hard to read and filter, and it can suck resources away from the Server you are trying to monitor. However, Extended Events also seemed a little daunting at first but there are other people out there that have taken one for the team Continue Reading