Be sure to get the latest version of this script from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox Have you ever wanted a quick and easy way to see who was holding (and waiting on) locks on a particular database? Perhaps you've got some blocking issues going on and you want to see exactly which rows the row level... Continue Reading →
Here's a quick one for you, have you ever spent all day working on some query or another only for SSMS to crash or for you to accidentally close the tab that you're working on without saving the query? I'm sure you have, we all have. What happens next is usually a muttering of some... Continue Reading →
This month's T-SQL Tuesday invitation comes from Kevin Chant and he's asking us about a fantasy feature that we'd love to see in SQL Server. I had a little think about this and there's one thing that came straight to my mind, it is something that's possible with third party tools but isn't something supported... Continue Reading →
SQL Undercover 