We’ll go through the steps to set up an Extended Events session, run a sample stored procedure, and then query the captured data.
A Walkthrough – DATETRUNC Function in SQL Server
One such tool is the DATETRUNC function, introduced in SQL Server 2022. Let’s take a journey to understand how this function can simplify date handling.
Functions and Missing Indexes – SQL in Sixty Seconds 204
In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203
In this blog post, I will share three quick and effective methods to tune your SQL Server using ChatGPT. These tricks can help you optimize.
Majoring in the Minors in SQL Server Performance Tuning
We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors.
Advanced Data Retrieval Techniques in SQL Server – Video Course
The “Advanced Data Retrieval Techniques in SQL Server” course, designed to elevate your proficiency in handling complex SQL Server tasks.
SQL Server Data Manipulation Essentials – Video Course
In today’s data-driven world, mastering SQL Server for optimal performance and workload management is indispensable. Introducing my latest offering, the “SQL Server Data Manipulation Essentials” course.