Decipher the SQL Server performance mysteries with SQL DM. Microsoft’s SQL Server is a robust and widely adopted database.
12 Years, 50 Courses: A Tale of Enthusiasm, Determination, and Resilience
12 Years, 50 Courses: A Tale of Enthusiasm, Determination, and Resilience. Looking back, the past twelve years feel almost dream-like.
SQL Server Security Fundamentals at Pluralsight
I’m delighted to announce the launch of my 51st course on Pluralsight – “SQL Server Security Fundamentals.”
BDD with Cucumber and Java at Pluralsight
It is with immense pride and joy that I announce the successful completion of my 50th course on Pluralsight – “BDD with Cucumber and Java.”
SQL SERVER – STRING_AGG Function to Concatenate Strings
We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn.
SQL SERVER 2022 – GENERATE_SERIES Function
Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function.
SQL SERVER – Monitoring Database Autogrowth Settings
Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.