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…
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 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…
Optimize your SQL Server queries for maximum performance. Learn how to troubleshoot query plans and identify optimization opportunities.
In this post, we will discuss Dynamic Management Objects (DMO’s) used to troubleshoot for Waiting Tasks in SQL Server.
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.
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).
A closer look at the Serializable Transaction Isolation Level and how it could prevent Phantom Reads concurrency issues in SQL Server.
A closer look at the Repeatable Read Transaction Isolation Level and how it could help with Inconsistent Analysis concurrency issues in SQL Server.
A closer look at the Read Committed Transaction Isolation Level and how it could allow Lost Update concurrency issues in SQL Server.