General Availability of SSMS 22
SQL Server Management Studio (SSMS) 22 is now generally available! Discover powerful features and enhancements today.
Deardurff
SQL Server Security Updates: November 2025
Stay updated with SQL Server Security Updates: November 2025. Explore essential fixes and support details.
Meet the NEW Azure SQL Hub
If you’ve ever felt lost trying to figure out Azure SQL, you’re not alone. Microsoft just dropped something pretty cool, the ALL NEW Azure SQL Hub and it’s here to make your cloud database journey much easier. What’s Azure SQL Hub? Think of Azure SQL Hub as your one-stop shop…
Microsoft Certified: Azure AI Fundamentals
It has been a few years since I earned a new Microsoft Certification, but the Azure AI Fundamentals exam is in the books. This was a work requirement for the 2026 fiscal year. So I’m glad I finished it early. Exam Basics and My Study Guide Here are the Exam…
SQL Server: News and Updates (July 2025)
Explore the SQL Server: Security Updates (July 2025) for crucial fixes and enhancements released by the SQL Server team.
Mainstream support for Microsoft SQL Server 2019
Mainstream support for Microsoft SQL Server 2019 will end on February 28, 2025. After this date, Microsoft will no longer provide new features, functionalities, or general fixes for this version. However, extended support for SQL Server 2019 will continue until January 8, 2030; More information here. Here are the most…
Opportunities for Query Optimization
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
Troubleshooting Waiting Tasks
In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.
Execution Plans – Table Operators
How to read Heap and Clustered Index table operators in a SQL Server Execution Plan. One way of determining if a table is structured as a Heap or a Clustered Index is to look at the table operators from the Execution Plan.
Table Structures in SQL Server
Heaps vs Clustered Indexes and how tables are structured and data is stored in SQL Server. Data rows from a table are stored in the data pages in either an unsorted order (Heap) or a sort order (Clustered Index).