I asked an AI to tune my query.
It added DISTINCT, apologized, and said the real index was the friends we made along the way.
AI T-SQL gets a segment at my #PASSDataSummit West precon. Where it helps, where it lies.
passdatacommunitysummit.com/west/
It added DISTINCT, apologized, and said the real index was the friends we made along the way.
AI T-SQL gets a segment at my #PASSDataSummit West precon. Where it helps, where it lies.
passdatacommunitysummit.com/west/
September 29, 2026 at 2:03 PM
I asked an AI to tune my query.
It added DISTINCT, apologized, and said the real index was the friends we made along the way.
AI T-SQL gets a segment at my #PASSDataSummit West precon. Where it helps, where it lies.
passdatacommunitysummit.com/west/
It added DISTINCT, apologized, and said the real index was the friends we made along the way.
AI T-SQL gets a segment at my #PASSDataSummit West precon. Where it helps, where it lies.
passdatacommunitysummit.com/west/
Knock knock.
Who's there?
A writer.
A writer who?
Doesn't matter. You're a reader under Read Committed, so you'll be waiting out here until the writer is done.
Read Committed Is Cruel by Default: #PASSDataSummit West, Seattle.
passdatacommunitysummit.com/west/
Who's there?
A writer.
A writer who?
Doesn't matter. You're a reader under Read Committed, so you'll be waiting out here until the writer is done.
Read Committed Is Cruel by Default: #PASSDataSummit West, Seattle.
passdatacommunitysummit.com/west/
September 24, 2026 at 6:03 PM
Knock knock.
Who's there?
A writer.
A writer who?
Doesn't matter. You're a reader under Read Committed, so you'll be waiting out here until the writer is done.
Read Committed Is Cruel by Default: #PASSDataSummit West, Seattle.
passdatacommunitysummit.com/west/
Who's there?
A writer.
A writer who?
Doesn't matter. You're a reader under Read Committed, so you'll be waiting out here until the writer is done.
Read Committed Is Cruel by Default: #PASSDataSummit West, Seattle.
passdatacommunitysummit.com/west/
What's the difference between a table variable and a temp table?
One of them has statistics.
That's it. That's the joke. It's also why your batch job takes four hours.
Full day of this at my #PASSDataSummit West precon: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
One of them has statistics.
That's it. That's the joke. It's also why your batch job takes four hours.
Full day of this at my #PASSDataSummit West precon: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
September 24, 2026 at 2:03 PM
What's the difference between a table variable and a temp table?
One of them has statistics.
That's it. That's the joke. It's also why your batch job takes four hours.
Full day of this at my #PASSDataSummit West precon: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
One of them has statistics.
That's it. That's the joke. It's also why your batch job takes four hours.
Full day of this at my #PASSDataSummit West precon: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
I put NOLOCK on all the reports.
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
September 22, 2026 at 6:02 PM
I put NOLOCK on all the reports.
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Now they are fast and occasionally fiction.
Row versioning gets you the fast part without the creative writing.
Read Committed Is Cruel by Default: my session at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Knock knock.
Who's there?
An implicit conversion.
An implicit conversion who?
Doesn't matter. You're scanning the whole table now.
T-SQL That Doesn't Suck, my #PASSDataSummit West precon. Bring your worst stored procedures.
passdatacommunitysummit.com/west/
Who's there?
An implicit conversion.
An implicit conversion who?
Doesn't matter. You're scanning the whole table now.
T-SQL That Doesn't Suck, my #PASSDataSummit West precon. Bring your worst stored procedures.
passdatacommunitysummit.com/west/
September 22, 2026 at 2:03 PM
Knock knock.
Who's there?
An implicit conversion.
An implicit conversion who?
Doesn't matter. You're scanning the whole table now.
T-SQL That Doesn't Suck, my #PASSDataSummit West precon. Bring your worst stored procedures.
passdatacommunitysummit.com/west/
Who's there?
An implicit conversion.
An implicit conversion who?
Doesn't matter. You're scanning the whole table now.
T-SQL That Doesn't Suck, my #PASSDataSummit West precon. Bring your worst stored procedures.
passdatacommunitysummit.com/west/
Two sessions try to tell the same knock knock joke.
Neither can say who's there until the other answers.
SQL Server picks a victim. That is the real technical term.
Deadlocks, blocking, and how to stop both: my #PASSDataSummit West session.
passdatacommunitysummit.com/west/
Neither can say who's there until the other answers.
SQL Server picks a victim. That is the real technical term.
Deadlocks, blocking, and how to stop both: my #PASSDataSummit West session.
passdatacommunitysummit.com/west/
September 17, 2026 at 6:02 PM
Two sessions try to tell the same knock knock joke.
Neither can say who's there until the other answers.
SQL Server picks a victim. That is the real technical term.
Deadlocks, blocking, and how to stop both: my #PASSDataSummit West session.
passdatacommunitysummit.com/west/
Neither can say who's there until the other answers.
SQL Server picks a victim. That is the real technical term.
Deadlocks, blocking, and how to stop both: my #PASSDataSummit West session.
passdatacommunitysummit.com/west/
A CTE walks into a bar.
Then walks into the same bar.
Then walks into the same bar.
You referenced it three times. It is not materialized. It will keep walking into that bar.
T-SQL That Doesn't Suck: my full day #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
Then walks into the same bar.
Then walks into the same bar.
You referenced it three times. It is not materialized. It will keep walking into that bar.
T-SQL That Doesn't Suck: my full day #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
September 17, 2026 at 2:02 PM
A CTE walks into a bar.
Then walks into the same bar.
Then walks into the same bar.
You referenced it three times. It is not materialized. It will keep walking into that bar.
T-SQL That Doesn't Suck: my full day #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
Then walks into the same bar.
Then walks into the same bar.
You referenced it three times. It is not materialized. It will keep walking into that bar.
T-SQL That Doesn't Suck: my full day #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
Nobody picked Read Committed. Ever.
It came with the box, like a free knife that only cuts you.
My #PASSDataSummit West session: Read Committed Is Cruel by Default. Pick an isolation level on purpose, once, as a treat.
passdatacommunitysummit.com/west/
It came with the box, like a free knife that only cuts you.
My #PASSDataSummit West session: Read Committed Is Cruel by Default. Pick an isolation level on purpose, once, as a treat.
passdatacommunitysummit.com/west/
September 15, 2026 at 6:02 PM
Nobody picked Read Committed. Ever.
It came with the box, like a free knife that only cuts you.
My #PASSDataSummit West session: Read Committed Is Cruel by Default. Pick an isolation level on purpose, once, as a treat.
passdatacommunitysummit.com/west/
It came with the box, like a free knife that only cuts you.
My #PASSDataSummit West session: Read Committed Is Cruel by Default. Pick an isolation level on purpose, once, as a treat.
passdatacommunitysummit.com/west/
Knock knock.
Who's there?
Your query from this morning.
Your query from this morning who?
Exactly. Still running. Nobody remembers who it is anymore.
I fix this for a living. Full day precon at #PASSDataSummit West: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
Who's there?
Your query from this morning.
Your query from this morning who?
Exactly. Still running. Nobody remembers who it is anymore.
I fix this for a living. Full day precon at #PASSDataSummit West: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
September 15, 2026 at 2:03 PM
Knock knock.
Who's there?
Your query from this morning.
Your query from this morning who?
Exactly. Still running. Nobody remembers who it is anymore.
I fix this for a living. Full day precon at #PASSDataSummit West: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
Who's there?
Your query from this morning.
Your query from this morning who?
Exactly. Still running. Nobody remembers who it is anymore.
I fix this for a living. Full day precon at #PASSDataSummit West: T-SQL That Doesn't Suck.
passdatacommunitysummit.com/west/
We've announced the sessions for PASS Summit West! Absolutely thrilled with this line up, and can't wait to see everyone in action ✨️
See the sessions here: passdatacommunitysummit.com/west/sessions/
#PASSDataSummit
See the sessions here: passdatacommunitysummit.com/west/sessions/
#PASSDataSummit
All Sessions - PASS Data Community Summit
PASS Summit West (Seattle) All Sessions
passdatacommunitysummit.com
June 30, 2026 at 7:30 PM
We've announced the sessions for PASS Summit West! Absolutely thrilled with this line up, and can't wait to see everyone in action ✨️
See the sessions here: passdatacommunitysummit.com/west/sessions/
#PASSDataSummit
See the sessions here: passdatacommunitysummit.com/west/sessions/
#PASSDataSummit
Come join me in Seattle at the #PassDataSummit this November. Registration is open now, and I'm teaching a day-long pre-conference workshop on Tuesday: passdatacommunitysummit.com/west/pre-con...
Pre-Conference Sessions and Speakers - PASS Data Community Summit
PASS Summit West (Seattle) Pre-Conference Speakers Pre-Conference Sessions
passdatacommunitysummit.com
June 19, 2026 at 1:25 AM
Come join me in Seattle at the #PassDataSummit this November. Registration is open now, and I'm teaching a day-long pre-conference workshop on Tuesday: passdatacommunitysummit.com/west/pre-con...
I’m Coming to the #PassDataSummit in Seattle!
The lineup for the PASS Data Community Summit Seattle event was just released,and I'm proud to share that I'll be teaching my new all-day pre-conference workshop. Dev-Prod Demon Hunters: Finding the Real Cause of Production Slowness Production is slow.…
The lineup for the PASS Data Community Summit Seattle event was just released,and I'm proud to share that I'll be teaching my new all-day pre-conference workshop. Dev-Prod Demon Hunters: Finding the Real Cause of Production Slowness Production is slow.…
I’m Coming to the #PassDataSummit in Seattle!
The lineup for the PASS Data Community Summit Seattle event was just released,and I'm proud to share that I'll be teaching my new all-day pre-conference workshop. Dev-Prod Demon Hunters: Finding the Real Cause of Production Slowness Production is slow. Development is fast. The same query runs in both. Somewhere between the two, a performance demon is hiding—and this session is about hunting it down.
www.brentozar.com
June 17, 2026 at 1:15 PM
I’m Coming to the #PassDataSummit in Seattle!
The lineup for the PASS Data Community Summit Seattle event was just released,and I'm proud to share that I'll be teaching my new all-day pre-conference workshop. Dev-Prod Demon Hunters: Finding the Real Cause of Production Slowness Production is slow.…
The lineup for the PASS Data Community Summit Seattle event was just released,and I'm proud to share that I'll be teaching my new all-day pre-conference workshop. Dev-Prod Demon Hunters: Finding the Real Cause of Production Slowness Production is slow.…
Yesterday, we announced the Pre-Cons for PASS Summit West in Seattle. They're a really talented lot, teaching some really cool things. Check out the line up! passdatacommunitysummit.com/west/pre-con...
#PASSDataSummit
#PASSDataSummit
Pre-Con Sessions & Speaker Annoucement for PASS Summit East and Europe - PASS Data Community Summit
We’re excited to reveal the Pre-Conference Sessions and the respective speakers joining us in Chicago...
passdatacommunitysummit.com
June 17, 2026 at 8:14 AM
Yesterday, we announced the Pre-Cons for PASS Summit West in Seattle. They're a really talented lot, teaching some really cool things. Check out the line up! passdatacommunitysummit.com/west/pre-con...
#PASSDataSummit
#PASSDataSummit
Pre-cons for PASS Summit West are official 🎉
I'm teaching a full day: "T-SQL That Doesn't Suck: Solving Performance and Concurrency Problems."
#PASSDataSummit
passdatacommunitysummit.com/west/pre-con...
I'm teaching a full day: "T-SQL That Doesn't Suck: Solving Performance and Concurrency Problems."
#PASSDataSummit
passdatacommunitysummit.com/west/pre-con...
June 16, 2026 at 6:45 PM
Pre-cons for PASS Summit West are official 🎉
I'm teaching a full day: "T-SQL That Doesn't Suck: Solving Performance and Concurrency Problems."
#PASSDataSummit
passdatacommunitysummit.com/west/pre-con...
I'm teaching a full day: "T-SQL That Doesn't Suck: Solving Performance and Concurrency Problems."
#PASSDataSummit
passdatacommunitysummit.com/west/pre-con...
I'm excited to announce that I'm teaching a pre-con workshop at the #PASSDataSummit in Seattle this November: passdatacommunitysummit.com/west/pre-con... Attendees get a free Recorded Class Season Pass: Fundamentals, too! Registration is open now.
Pre-Conference Sessions and Speakers - PASS Data Community Summit
PASS Summit West (Seattle) Pre-Conference Speakers Pre-Conference Sessions
passdatacommunitysummit.com
June 16, 2026 at 4:06 PM
I'm excited to announce that I'm teaching a pre-con workshop at the #PASSDataSummit in Seattle this November: passdatacommunitysummit.com/west/pre-con... Attendees get a free Recorded Class Season Pass: Fundamentals, too! Registration is open now.
June 11, 2026 at 3:20 PM
June 11, 2026 at 6:35 AM
Lovely evening with some of tomorrow's speakers. (Thanks bestie @bweissman.bsky.social for the 📸)
#PASSDataSummit
#PASSDataSummit
June 10, 2026 at 7:46 PM
Lovely evening with some of tomorrow's speakers. (Thanks bestie @bweissman.bsky.social for the 📸)
#PASSDataSummit
#PASSDataSummit
PASS Summit Europe Pre-Cons are well underway! Here's the shiny happy reg team waiting to greet you at the conference tomorrow ✨️
#PASSDataSummit
#PASSDataSummit
June 10, 2026 at 9:00 AM
PASS Summit Europe Pre-Cons are well underway! Here's the shiny happy reg team waiting to greet you at the conference tomorrow ✨️
#PASSDataSummit
#PASSDataSummit
@PASSDataSummit Europe today in Germany, trying to do some admin work. Not only am I now sure of which time zone I'm in, but I realize I've lost track of time. I had no idea what day it is in June. Without may watch I might have guessed the 5th or 15th.
I need a week at home
I need a week at home
June 10, 2026 at 7:26 AM
@PASSDataSummit Europe today in Germany, trying to do some admin work. Not only am I now sure of which time zone I'm in, but I realize I've lost track of time. I had no idea what day it is in June. Without may watch I might have guessed the 5th or 15th.
I need a week at home
I need a week at home
Slowly making my way to Frankfurt and @PASSDataSummit Europe. Looking forward to seeing everyone tomorrow.
June 9, 2026 at 1:43 PM
Slowly making my way to Frankfurt and @PASSDataSummit Europe. Looking forward to seeing everyone tomorrow.
The Redgate Team are on our way to Frankfurt! Excited for our whirlwind visit and seeing everyone who can join us at PASS Summit Europe 🫶
If you'll be there, let me know!
#PASSDataSummit
If you'll be there, let me know!
#PASSDataSummit
June 9, 2026 at 11:31 AM
The Redgate Team are on our way to Frankfurt! Excited for our whirlwind visit and seeing everyone who can join us at PASS Summit Europe 🫶
If you'll be there, let me know!
#PASSDataSummit
If you'll be there, let me know!
#PASSDataSummit
Back in Chicago to bring human-generated joy to the people for PASS Data Comunity SUmmit East! Register here: click.red-gate.com/ODA4LUlURy03...
#PASSDataSummit
#PASSDataSummit
March 27, 2026 at 8:42 PM
Back in Chicago to bring human-generated joy to the people for PASS Data Comunity SUmmit East! Register here: click.red-gate.com/ODA4LUlURy03...
#PASSDataSummit
#PASSDataSummit
Registration is open for all three @PASSDataSummit Summits passdatacommunitysummit.com
Hope to see you there, talking data, analytics, and of course, AI
Hope to see you there, talking data, analytics, and of course, AI
PASS Data Community Summit
PASS Data Community Summit is the year's largest gathering of data platform professionals.
passdatacommunitysummit.com
March 20, 2026 at 6:17 PM
Registration is open for all three @PASSDataSummit Summits passdatacommunitysummit.com
Hope to see you there, talking data, analytics, and of course, AI
Hope to see you there, talking data, analytics, and of course, AI
PASS Data Community Summit 2025, Nov 21st, Community Keynote
The Friday Community Keynote
Adam Jorgensen - The Data Leader’s Playbook for a Faster World
Intro from Ginger Grant - Courageously Conquering Procrastination
www.flickr.com/photos/12711...
@passdatasummit.bsky.social
#PASSDataSummit
The Friday Community Keynote
Adam Jorgensen - The Data Leader’s Playbook for a Faster World
Intro from Ginger Grant - Courageously Conquering Procrastination
www.flickr.com/photos/12711...
@passdatasummit.bsky.social
#PASSDataSummit
PASS Data Community Summit 2025, Nov 21st, Community Keynote
The Friday Community Keynote
Adam with The Data Leader’s Playbook for a Faster World
Introduction was from last years Keynote speaker Ginger with Courageously Conquering Procrastination
www.flickr.com
January 29, 2026 at 5:16 PM
PASS Data Community Summit 2025, Nov 21st, Community Keynote
The Friday Community Keynote
Adam Jorgensen - The Data Leader’s Playbook for a Faster World
Intro from Ginger Grant - Courageously Conquering Procrastination
www.flickr.com/photos/12711...
@passdatasummit.bsky.social
#PASSDataSummit
The Friday Community Keynote
Adam Jorgensen - The Data Leader’s Playbook for a Faster World
Intro from Ginger Grant - Courageously Conquering Procrastination
www.flickr.com/photos/12711...
@passdatasummit.bsky.social
#PASSDataSummit