Dear SQL DBA: Training Resources for SQL Newbies
Category:
dear-sql-dba
New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up.
Perks for My SQLPASS Summit Precon: Prevent Fake News in Your Data! Isolation Levels Demystified
I’m proud, giddy, and just plain overly excited to be giving a pre conference session at the SQL PASS Summit in Seattle, Washington on November 5, 2018.
This is going to be a fun, demo-packed day which will teach you skills you can use throughout your career as a developer, database administrator, or data professional.
Two Free Sessions Next Week: Fighting Bad Data and Deadlocks
Category:
community
, course-announcements
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.
Row Width Impact on Version Store Usage under Snapshot Isolation
Category:
isolation-levels
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?
Code: Fixing a Filtered Index Which is Causing Data Modifications to Fail
Category:
index-tuning
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?
Free Session! DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario
Category:
monitoring-troubleshooting
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.
What is Deferred Name Resolution, and How Can It Go Wrong?
Category:
tsql-programming
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.