Senior Cloud Solution Architect @Microsoft, Microsoft Certified Trainer (MCT), SQL Skills Blackbelt, 5X Fantasy Baseball Champion, and Reader of Books.
Joined September 2009
- Tweets 25,656
- Following 403
- Followers 2,275
- Likes 21,518
3,537 Photos and videos
“Very little is needed to make a happy life; it is all within yourself, in your way of thinking.” - Marcus Aurelius
14
Jun 10
What's New in SSMS 22.7: T-SQL formatting, GitHub Copilot in Agent mode, Copilot execution context, Schema Compare, and more... techcommunity.microsoft.com/…
62
John Deardurff retweeted
Making new friends as an introvert is hard because the people I’d probably get along with best are at home avoiding people too
30
178
2,050
38,742
Jun 8
I earned my "Explore SQL Server 2025 capabilities" trophy! I’m so proud to be celebrating this achievement and hope this inspires you to start your own @MicrosoftLearn journey! learn.microsoft.com/en-us/us…
35
Jun 8
AI Skills Fest is now live. Complete a playlist by June 12 to earn a free Microsoft Learn exam. This is a great opportunity to learn quickly, certify your skills, and save on costs. #Azure #AI #Amaze #AISkillsFest For more information, visit: aiskillsnavigator.microsoft.…
1
140
Jun 4
Microsoft is introducing a consistent pricing model for Extended Security Updates (ESUs) across Azure, on-premises environments, and other public clouds. This change directly impacts organizations running SQL Server 2016 end of support. sqlmct.com/sql-server-2016-e…
1
85
Jun 1
SQL Server evolved from blocking locks to row-versioning. Find out how #SQLServer2025 using Optimized Locking allows for higher concurrency and better scalability. sqlmct.com/understanding-opt…
1
35
May 29
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.
May 29
The most "boring" drive between two American cities: Denver to Kansas City, MO.
3
69
May 28
DP-800 - SQL AI, hands-on: Join a free workshop near you related blog, if you want to learn more: devblogs.microsoft.com/azure…
38
May 28
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 sqlmct.com/writing-sargable-…
ALT So, ask not what an index can do for you, but what you can do for your index.
1
26
May 27
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. sqlmct.com/simplify-sql-serv…
47
May 26
The Final Countdown is 40 years old!
May 26
On May 26, 1986, EUROPE released the 3rd studio album "The Final Countdown"
Which track is your favorite?🤔
1
53
May 26
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. sqlmct.com/fuzzy-matching-in…
1
56
May 22
Fun little prompt I borrowed, "Use everything you know about me, INSERT NAME, from our conversations, including my personality, habits, strengths, profession, and overall vibe, to turn my photo into a hand-drawn sketchbook character sheet."
ALT John Deardurff Character Sheet Sketchbook - SQLMCT.com
1
96
May 21
SQL Server security updates for May 2026. Reminder: #SQLServer2016 reaches End of Support (EOS) on July 14, 2026. sqlmct.com/sql-server-securi…
2
53
May 21
This learning path emphasized Frontier Transformation concepts, along with AI-powered insights and customer scenarios. As part of the challenge, you engaged in a Second Nature AI customer simulation, specifically the Contoso scenario and successfully achieved a 96% score on that component.
ALT MCAPS Q4 Skills Challenge
1
68
May 20
Have you’ve ever run into unexplained CPU spikes caused by dynamic SQL? Introducing OPTIMIZED_SP_EXECUTESQL in #SQLServer2025, which reduces compile storms by allowing one session to compile while others can reuse the plan. sqlmct.com/optimized_sp_exec…
60