Two Free Sessions Next Week: Fighting Bad Data and Deadlocks

I am excited and honored to be giving two free online sessions next week. Both events are sponsored by the fine folks over at Quest Software.

Why is That Data Wrong? How Choosing the Wrong Isolation Level Causes Bad Results

Tuesday, June 12, Noon Pacific 24 Hours of PASS, Sponsored by Quest Software

If you haven’t thought much about isolation levels in SQL Server, chances are your applications can return inconsistent data to your users: data that looks completely wrong. If your user re-runs their report or reloads their screen, the data may look right the second time… but after this happens, your customer feels that they can’t trust your data.

Continue reading

Row Width Impact on Version Store Usage under Snapshot Isolation

A question came up in my webcast today on the topic of Snapshot and Read Committed Snapshot Isolation - what impact will enabling these have on my SQL Server instance?

Continue reading

Code: Fixing a Filtered Index Which is Causing Data Modifications to Fail

This question came up in a webcast recently: if a filtered index is causing data modifications to fail, does disabling the filtered index fix the problem?

Continue reading

Free Session! DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario

DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario

June 14, 2018 8:30 AM – 9:30 AM PST <- This is past, but no worries, it was recorded

Deadlocks strike fear into the hearts of even seasoned DBAs — but they don’t have to!

In this session, you’ll get the code to cause a sample deadlock in SQL Server. You’ll see how to interpret the deadlock graph to find out where the conflict lies, and how to design an index to make the deadlock disappear.

Continue reading

What is Deferred Name Resolution, and How Can It Go Wrong?

I got a question recently about why a particular bit of code was failing when running.

My first thought: oh, that’s probably related to… whatsitcalled.

Continue reading

Dear SQL DBA: Dealing With a Lack of Control

This week I discuss a question that I’ve gotten in many forms over the years - a lot of the scenarios are so specific that it’s hard to keep them anonymous, but they can be generalized as a bigger problem: how do I deal with being responsible for things that I can’t fully control?

Continue reading

Fake News about Auto Parameterization/Simple Parameterization

I saw a question on Twitter today that took me down a little rabbit hole. And when I go down rabbit holes, I like to blog about it! There’s a TLDR at the bottom of this post if you’re short on time.

Continue reading