John Deardurff

Senior Cloud Solution Architect @Microsoft, Microsoft Certified Trainer (MCT), SQL Skills Blackbelt, 5X Fantasy Baseball Champion, and Reader of Books.

[John Deardurff @SQLMCT]

@TrevDon We only had three channels: 2 (NBC), 10 (CBS), and sometimes 38 (ABC).

[John Deardurff @SQLMCT]

@mass_ave Instead of the Beatitudes, maybe the Beatle Dudes...
Let it Be
All You Need is Love
Carry That Weight
Octopus’s Garden

[John Deardurff @SQLMCT]

@piyush784066 Trick question!

[John Deardurff @SQLMCT]

SQL Server evolved from blocking locks to row-versioning. Find out how #SQLServer2025 using Optimized Locking allows for higher concurrency and better scalability. https://t.co/lbki1WAp1M

[John Deardurff @SQLMCT]

@EllaJeanrz b2 or not b2, that is the question. (The answer is 9)

[John Deardurff @SQLMCT]

@JenMsft @Microsoft I'm sure you could... Build one.

[John Deardurff @SQLMCT]

@HawkEmDownChris Yes

[John Deardurff @SQLMCT]

@sqlstudent144 @GFritchey The reverse of stressed is desserts!

[John Deardurff @SQLMCT]

I've made the KC to Denver through Nebraska drive. I pulled over for an hour and did not see another living creature the entire time.

[Epic Maps 🗺️ @theepicmap]

The most "boring" drive between two American cities: Denver to Kansas City, MO.

[John Deardurff @SQLMCT]

@TheBookNewb 24 https://t.co/s7EqIXYC4L

[John Deardurff @SQLMCT]

@goodreads Will probably get to book five tomorrow, but... https://t.co/douitZb5ON

[John Deardurff @SQLMCT]

@obvious_shirts Still the best team in the AL West!

[John Deardurff @SQLMCT]

DP-800 - SQL + AI, hands-on: Join a free workshop near you related blog, if you want to learn more: https://t.co/G0y1e4y1Gq

[John Deardurff @SQLMCT]

@TheBookNewb As an older person I am limited to Kindle for larger fonts. Plus, it is easier to carry the dozen books I might read during vacation.

[John Deardurff @SQLMCT]

A search condition is considered SARGable (Search ARGument ABLE) when SQL Server can use an index to efficiently locate rows. So, ask not what an index can do for you, but what you can do for your index. #SQLServer #SQL #Sargable https://t.co/ll5UJsDL9I

[John Deardurff @SQLMCT]

SQL Server migrations have become significantly easier with the introduction of the new “Migrate SQL Server” experience in SSMS 22.5 or later. This unified, guided, end-to-end flow combines assessment, migration, and modernization into one streamlined process. https://t.co/oXpZ5aYf8W

[John Deardurff @SQLMCT]

The Final Countdown is 40 years old!

[𝑯𝑬𝑨𝑽𝒀 𝑴𝑬𝑻𝑨𝑳Ⓒ @HeavyMetal_999]

On May 26, 1986, EUROPE released the 3rd studio album "The Final Countdown"
Which track is your favorite?🤔

[John Deardurff @SQLMCT]

@mass_ave I would be happy going back to pre-2006 when we didn't change our clocks.

[John Deardurff @SQLMCT]

Data rarely arrives in perfect condition. Typos, regional spelling differences, and inconsistent formats make exact matching unreliable in real-world scenarios. That’s where similarity matching comes in; and #SQLServer2025 introduces powerful built-in functions to handle it directly in T-SQL. https://t.co/iK0AMytvwP