Content rating: intermediate/tips. We'll do an intro deadlocking blog sometime soon. I had a bear of a deadlocking issue last week, and reached out to my SQL Tweeps for help. Jonathan Kehayias (blog, SQLSarg on twitter) responded with email, repros, and solutions. I was trying to think of a funny way to say thank you, […]
Author: Jen McCown
Need Speakers & Sponsors for Dallas SQL Saturday!
We’re holding our first SQL Saturday event in Dallas on May 22, 2010. I'm in charge of getting this great event sponsored, so if your company (or one you know) is interested in sponsoring, shoot me an email at Jen@JenniferMcCown.com and I'll get you the details double-quick. We're expecting over 400 attendees (and I wonder […]
Find Deprecated SQL Code Using Profiler
I stumbled across something really cool when I was reading through the BOL entry on sp_trace_setevent*, which gives a list of all events and columns available to trace. This is, by the way, an extremely useful entry to have bookmarked. There are two events I hadn't really noticed before: number 39, Deprecated, and 125, Deprecation […]