This repository contains a set of focused diagnostic and tuning scripts for Microsoft SQL Server. These scripts are part of a hands-on capstone project to help develop and demonstrate foundational ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

This paper demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the ...

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...

There is one commonality amongst all these professionals: no one has time to spare. Everyone wants to streamline processes and solve problems as quickly as possible and move on to the next issue of ...

This application lets you interact with a specific SQL Server table using natural language, leveraging the Modal Context Protocol as a communication layer between LLMs and your data source. This ...

Microsoft's SQL Server Migration Assistant lets you move your data and schema to different SQL Servers. Here's what you need to know about the tool. Image: Dilok/Adobe Stock The Microsoft SQL Server ...