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.
Schema-Level Permissions: Granting on a Schema, Not Each Object
Apply schema-level permissions to a database role, include future tables automatically, separate internal data, and review grants.
Given-When-Then for Database Tests
Use Given-When-Then for readable database tests with known input, explicit THROW checks, and transaction rollback after each case.
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.