John Deardurff
@sqlmct.bsky.social
Microsoft Certified Trainer (MCT), SQL Skills Blackbelt, 5X Fantasy Baseball Champion, and Reader of Books. https://sqlmct.com/
I’ve pulled together my favorite tools, scripts, and learning materials for anyone working with SQL Server for performance tuning and diagnostics. If you’re a DBA, developer, or architect, this curated list is a quick way to level up your SQL Server toolkit. Check it out: sqlmct.com/sql-resources/
SQL Server Community Resources You Should Explore
Unlock the power of SQL Server with valuable community resources curated by John Deardurff (@SQLMCT)
sqlmct.com
January 19, 2026 at 3:57 PM
I’ve pulled together my favorite tools, scripts, and learning materials for anyone working with SQL Server for performance tuning and diagnostics. If you’re a DBA, developer, or architect, this curated list is a quick way to level up your SQL Server toolkit. Check it out: sqlmct.com/sql-resources/
I'm going to the moon. go.nasa.gov/artemisnames
January 19, 2026 at 12:55 PM
I'm going to the moon. go.nasa.gov/artemisnames
SQL Server Security updates for January 2026. Including the first Cumulative Update for #SQLServer2025. sqlmct.com/sql-server-u...
SQL Server Security Updates: January 2026
Check out the latest SQL Server Security Updates to protect your database and keep your systems running smoothly.
sqlmct.com
January 17, 2026 at 4:57 PM
SQL Server Security updates for January 2026. Including the first Cumulative Update for #SQLServer2025. sqlmct.com/sql-server-u...
With the retirement of the Data Migration Assistant (DMA) and Azure Data Studio, what tools should you use to assess and migrate databases to Azure SQL? #SQLServer #AzureSQL sqlmct.com/options-for-...
Options for Migration to Azure SQL
Explore options for migration to Azure SQL amid tool retirements. Learn about alternatives for your database migration needs.
sqlmct.com
January 15, 2026 at 10:30 AM
With the retirement of the Data Migration Assistant (DMA) and Azure Data Studio, what tools should you use to assess and migrate databases to Azure SQL? #SQLServer #AzureSQL sqlmct.com/options-for-...
Just goes to show, you all need to be speaking more. #TopSessionizeSpeaker
January 13, 2026 at 5:11 PM
Just goes to show, you all need to be speaking more. #TopSessionizeSpeaker
Don't know who needs to hear this today, but DaBears, DaCubs.
a man wearing a chicago bears jersey and a hat is sitting at a table in a bar .
ALT: a man wearing a chicago bears jersey and a hat is sitting at a table in a bar .
media.tenor.com
January 11, 2026 at 4:18 PM
Don't know who needs to hear this today, but DaBears, DaCubs.
Book 1 of 25 for my 2026 @goodreads. Co-Intelligence: Living and Working with AI. www.goodreads.com/review/show/...
John Deardurff's review of Co-Intelligence
3/5: Helpful but not groundbreaking. Co‑Intelligence offers a clear, approachable introduction to working with AI, and Ethan Mollick’s enthusiasm makes the topic feel accessible rather than intimidati...
www.goodreads.com
January 7, 2026 at 5:48 PM
Book 1 of 25 for my 2026 @goodreads. Co-Intelligence: Living and Working with AI. www.goodreads.com/review/show/...
SQL Server 2025 now supports integration with modern AI embedding models, allowing new vector search capabilities directly within the database. I’ve put together a guide to help you get everything configured and ready for hands‑on learning. sqlmct.com/setting-up-o...
Setting up Ollama for SQL Server 2025
Learn to set up Ollama for SQL Server 2025 and run AI embedding models locally for privacy-sensitive applications.
sqlmct.com
January 5, 2026 at 3:39 PM
SQL Server 2025 now supports integration with modern AI embedding models, allowing new vector search capabilities directly within the database. I’ve put together a guide to help you get everything configured and ready for hands‑on learning. sqlmct.com/setting-up-o...
Documenting for future me. If you are trying to CREATE VECTOR INDEX in the pre-release of SQL Server 2025, documentation was to turn on Trace Flags 466, 474, and 13981. This will cause an error message of 343 on SQL Server 2025 RTM. So, be sure to turn these off. DBCC TRACEOFF(466, 474, 13981, -1)
January 2, 2026 at 4:16 PM
Documenting for future me. If you are trying to CREATE VECTOR INDEX in the pre-release of SQL Server 2025, documentation was to turn on Trace Flags 466, 474, and 13981. This will cause an error message of 343 on SQL Server 2025 RTM. So, be sure to turn these off. DBCC TRACEOFF(466, 474, 13981, -1)
Finishing the year strong with the new AI Vector Search Essentials badge from SQLskills! www.credly.com/badges/4a5b5...
SQLskills SQL Server 2025 AI: Vector Search Essentials was issued by SQLskills to John Deardurff.
This badge shows attendance of the SQLskills AI Vector Search Essentials course. Attendees learned how to implement native vector search capabilities in SQL Server 2025 for semantic search operations....
www.credly.com
December 31, 2025 at 8:49 PM
Finishing the year strong with the new AI Vector Search Essentials badge from SQLskills! www.credly.com/badges/4a5b5...
SQL Server 2025 introduces the ability to integrate with various AI embedding models to perform vector searching. To practice these capabilities, we need to first setup a secure environment. Here is a guide to help you setup #Ollama on #SQLServer2025. sqlmct.com/setting-up-o...
Setting up Ollama for SQL Server 2025
Learn to set up Ollama for SQL Server 2025 and run AI embedding models locally for privacy-sensitive applications.
sqlmct.com
December 31, 2025 at 1:30 AM
SQL Server 2025 introduces the ability to integrate with various AI embedding models to perform vector searching. To practice these capabilities, we need to first setup a secure environment. Here is a guide to help you setup #Ollama on #SQLServer2025. sqlmct.com/setting-up-o...
SQL Server 2025 introduces advancements in performance, security, and AI-ready capabilities. This guide walks you through the full installation process of #SQLServer2025 and #SSMS22 to create a practice environment to test the new features.
sqlmct.com/create-a-sql...
sqlmct.com/create-a-sql...
Create a SQL Server 2025 Practice Environment
Set up your SQL Server 2025 practice environment with this comprehensive installation guide and explore its new features.
sqlmct.com
December 30, 2025 at 12:46 PM
SQL Server 2025 introduces advancements in performance, security, and AI-ready capabilities. This guide walks you through the full installation process of #SQLServer2025 and #SSMS22 to create a practice environment to test the new features.
sqlmct.com/create-a-sql...
sqlmct.com/create-a-sql...
The Champ is here! Thank you, Derrick Henry and Christian
McCaffrey. 🏆
McCaffrey. 🏆
December 30, 2025 at 9:44 AM
The Champ is here! Thank you, Derrick Henry and Christian
McCaffrey. 🏆
McCaffrey. 🏆
What it is like to live in the Midwest.
December 28, 2025 at 1:47 PM
What it is like to live in the Midwest.
If you received a book from me as a holiday gift, remember they need to be returned to the library by next Friday.
December 27, 2025 at 6:48 PM
If you received a book from me as a holiday gift, remember they need to be returned to the library by next Friday.
I was researching vectors and embeddings earlier this week and now YouTube thinks I want to study linear algebra. Which goes to prove, AI can obviously make huge errors. 😀
December 26, 2025 at 12:30 PM
I was researching vectors and embeddings earlier this week and now YouTube thinks I want to study linear algebra. Which goes to prove, AI can obviously make huge errors. 😀
Book 25 of my Goodreads goal of 25 books for 2025. Brigands and Breadknives by @travisbaldree.bsky.social #25of25for25 www.goodreads.com/review/show/...
John Deardurff's review of Brigands & Breadknives (Legends & Lattes, #2)
4/5: Cozy fantasy is not really my genre, but I do enjoy the Legends and Lattes series. Brigands & Breadknives is no different; though I’ll admit, I liked it a little less than the first two books in ...
www.goodreads.com
December 25, 2025 at 1:51 PM
Book 25 of my Goodreads goal of 25 books for 2025. Brigands and Breadknives by @travisbaldree.bsky.social #25of25for25 www.goodreads.com/review/show/...
The best award that I received this year!
December 22, 2025 at 3:29 AM
The best award that I received this year!
I’m just glad I learned about parallelograms in school instead of how to do taxes. It really came in handy last year during parallelogram season.
December 21, 2025 at 3:57 PM
I’m just glad I learned about parallelograms in school instead of how to do taxes. It really came in handy last year during parallelogram season.
Someone just got mad at me for telling dad jokes as I don't have any kids. I apologized and said, that's my Faux Pa.
December 20, 2025 at 4:09 AM
Someone just got mad at me for telling dad jokes as I don't have any kids. I apologized and said, that's my Faux Pa.
Finishing the year with a new badge! Earners of this badge have gone above and beyond by not only innovating, executing, maintaining, and refining Value-Based Delivery (VBD) solutions, but also demonstrating the ability to lead and inspire. www.credly.com/badges/c4722...
FY26 Value Acceleration IP Contributor - Platinum was issued by Microsoft Customer Service and Support to John Deardurff.
Earners of this badge have gone above and beyond by not only innovating, executing, maintaining, and refining Value-Based Delivery (VBD) solutions, but also demonstrating the ability to lead and inspi...
www.credly.com
December 19, 2025 at 7:21 PM
Finishing the year with a new badge! Earners of this badge have gone above and beyond by not only innovating, executing, maintaining, and refining Value-Based Delivery (VBD) solutions, but also demonstrating the ability to lead and inspire. www.credly.com/badges/c4722...
I just submitted a session, "Ten Tips to Teaching Technical Topics!" to the 2026 North America MCT Summit in Redmond, WA, March 18-20th. The Call for Sessions is open until December 31st. #MCTSummit #mctbuzz #mct #microsoftcertified sessionize.com/north-americ...
North America MCT Summit 2026: Call for Speakers
Get ready to level up your skills and connect with fellow Microsoft Certified Trainers at the exclusive MCT Summit in Seattle! Whether you're looking ...
sessionize.com
December 16, 2025 at 2:46 PM
I just submitted a session, "Ten Tips to Teaching Technical Topics!" to the 2026 North America MCT Summit in Redmond, WA, March 18-20th. The Call for Sessions is open until December 31st. #MCTSummit #mctbuzz #mct #microsoftcertified sessionize.com/north-americ...
What does transforming into a Frontier Firm, an organization that is AI-powered and human-led, actually look like in practice? Lessons from Microsoft’s #AI journey. #FrontierPlaybook www.linkedin.com/pulse/fronti...
The Frontier Playbook: Early Learnings From Our Collective Journey Into AI-Powered Transformation
For all the noise about AI, one truth rarely gets said out loud: most organizations aren’t becoming AI-powered – they’re becoming AI-decorated. They’re deploying copilots, running pilots, and hosting ...
www.linkedin.com
December 12, 2025 at 12:16 AM
What does transforming into a Frontier Firm, an organization that is AI-powered and human-led, actually look like in practice? Lessons from Microsoft’s #AI journey. #FrontierPlaybook www.linkedin.com/pulse/fronti...
SQL Server 2016 is approaching End of Support on July 14, 2026! The new #SSMS22 Hybrid & Migration Tool streamlines the process of upgrading to #SQLServer2025 or migrating to #AzureSQL. sqlmct.com/upgrade-to-s...
Upgrade with the SSMS 22 Migration Component
Upgrade to SQL Server 2025 with SSMS Migration Component. Simplify your migration and enhance performance seamlessly.
sqlmct.com
December 11, 2025 at 2:27 PM
SQL Server 2016 is approaching End of Support on July 14, 2026! The new #SSMS22 Hybrid & Migration Tool streamlines the process of upgrading to #SQLServer2025 or migrating to #AzureSQL. sqlmct.com/upgrade-to-s...