Latest from the Blog
Searching a Stored Procedure for Text
Story time. Let’s say a database server is receiving a new release that include a change to a stored procedure. All of the databases are supposed to get the changes but one way or another there are problems with the release and it has to be stopped part of the way through. Maybe some changes … Continue reading Searching a Stored Procedure for Text
T-SQL Tuesday #138: Managing Technology Changes
This month’s T-SQL Tuesday topic comes from Andy Leonard who asks “how do you respond when technology changes under you?” Check out Andy’s invitation blog post by clicking the image below: For my contribution this month, I want to go over how I work to make the scenario of technology changing under me happen as … Continue reading T-SQL Tuesday #138: Managing Technology Changes
Viewing Deadlock Graphs
Deadlocks can be frustrating to troubleshoot. I’ve blogged about deadlock priority in the past but what about deadlock graphs? Let’s take a look at deadlock graphs and what I think is the best way to decipher them. Test Deadlock Setup Let’s open up two query windows in SSMS. In the first window, we’ll have these … Continue reading Viewing Deadlock Graphs
- May 2021 (4)
- April 2021 (8)
- March 2021 (8)
- February 2021 (8)
- January 2021 (9)
- December 2020 (10)
Get new content delivered directly to your inbox.
