I came across a puzzle about “The Two Doors, Two Guards,” popularly known as the “Two Doors Riddle” or the “Heaven and Hell Riddle”.
Deciphering the SQL Server Performance Mysteries with SQL DM
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;
SQL SERVER – Generating Complex Passwords with T-SQL
The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today.
SQL SERVER – Setting up a Robust Password Policy
Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.