Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?

Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot? Welcome to my series on Disaster Recovery. I will spend the entire month of January focusing on all things related to disaster recovery including topics like corruption, data integrity, data loss, DBCC commands, and more. For my first post of this month, I want to take a look at the myth that the DBCC CHECK commands will automatically use an existing database snapshot if one exists
read more

Error 25602 When Creating an Extended Events Session: a Security Risk

Error 25602 When Creating an Extended Events Session: a Security Risk I came across an interesting issue recently when helping someone troubleshoot error 25602 that he was receiving when starting an Extended Events session. I found the cause of the error to be quite alarming. To make matters worse, the way some people are working around the problem is even more troubling. In short, if you output the session to a file, but you only provide a filename with no
read more