Jan 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
The Two Doors, Two Guards Puzzle

SQL SERVER – The Two Doors, Two Guards Puzzle

July 28, 2023
Pinal Dave
SQL Puzzle
SQL Scripts

I came across a puzzle about “The Two Doors, Two Guards,” popularly known as the “Two Doors Riddle” or the “Heaven and Hell Riddle”.

Read More

Deciphering the SQL Server Performance Mysteries with SQL DM

July 27, 2023
Pinal Dave
SQL Performance
Idera

Decipher the SQL Server performance mysteries with SQL DM. Microsoft’s SQL Server is a robust and widely adopted database.

Read More

12 Years, 50 Courses: A Tale of Enthusiasm, Determination, and Resilience

July 26, 2023
Pinal Dave
SQLAuthority News
Pluralsight, SQL Milestone

12 Years, 50 Courses: A Tale of Enthusiasm, Determination, and Resilience. Looking back, the past twelve years feel almost dream-like.

Read More
security fundamentals

SQL Server Security Fundamentals at Pluralsight

July 25, 2023
Pinal Dave
SQLAuthority News
Pluralsight, SQL Server Security

I’m delighted to announce the launch of my 51st course on Pluralsight – “SQL Server Security Fundamentals.”

Read More
Cucumber

BDD with Cucumber and Java at Pluralsight

July 24, 2023
Pinal Dave
SQLAuthority News
BDD, Java, 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.”

Read More
STRING-AGG-Function

SQL SERVER – STRING_AGG Function to Concatenate Strings

July 21, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL String

We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn.

Read More
generate series

SQL SERVER 2022 – GENERATE_SERIES Function

July 20, 2023
Pinal Dave
SQL Tips and Tricks
GENERATE_SERIES, SQL Function, SQL Server 2022

Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function.

Read More
Previous 1 … 17 18 19 20 21 22 23 … 828 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version