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

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

Free Webcast: DBA vs Memory Settings

Join me in two weeks for a really fun free webcast.

Continue reading

Register for My Free Session on Execution Plan Forcing

I am excited to be giving a free online session as part of the Idera Live Virtual Conference, 2018!

Continue reading

New Free Webcasts for November and December 2017

I’ve Just Scheduled a Whole Batch o’ Free Webcasts!

Webcasts are held on Thursdays at 9 AM Pacific / noon Eastern / 4 pm UTC.

Here’s the upcoming slate of topics:

• Oct 5 – RCSI and Snapshot Isolation
• Oct 19 – Pressure Testing Memory
• Oct 26 – What’s REALLY in That Index?
• Nov 9 – Filtered Columnstore Indexes
• Nov 16 – Defragging: Reorg or Rebuild?
• Nov 30 – In-Memory Indexes & Isolation
• Dec 7 – Indexing for Windowing Functions
• Dec 14 – Serializable & Repeatable Read

I can’t wait to put together these presentations, and I hope to see you on Thursdays!

Continue reading

Desktop Wallpapers and Webcasts on Isolation Levels and Memory

I’ve been having lots of fun drawing and doing webcasts this summer. I’ve got four SQL Server themed desktop wallpapers to share, and I’ve got lots more coming– along with a new chunk of free webcasts.

Continue reading

Free Webcast on SQL Server Isolation Levels: (NOLOCK) or YESFUN?

Tomorrow evening I will be presenting for the SQL PASS Application Development chapter. Stop by and say hello!

Continue reading