This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Aug3

SQL SERVER – Stored Procedures to Check for Pythagorean Triples

Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function
4 Comments

I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.

Continue Reading
Aug2

Masking Functions in SQL Server: What Each One Shows

Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server 2022, SQL Server Security
No Comments

Dynamic data masking hides values at query time, and the masking functions decide what a reader still sees. This post tests default, email, partial, random and datetime on SQL Server 2025 and shows what each one returns. It also covers adding and dropping a mask on an existing column.

Continue Reading
Aug1

MySQL – Identifying and Optimizing the Busiest Tables

Pinal Dave
SQL Performance
MySQL, Performance Schema, Schema
No Comments

Let us learn Identifying and Optimizing the Busiest Tables in MySQL. MySQL provides an easy way to identify the busiest tables using the performance_schema.

Continue Reading
Jul31

SQL SERVER – The Flight Connection Puzzle

Pinal Dave
SQL Puzzle
CTE, SQL Server
5 Comments

Today we are going to see another such puzzle – The Flight Connection Puzzle. This blog post is going to be really fun blog post.

Continue Reading
Jul28

SQL SERVER – The Two Doors, Two Guards Puzzle

Pinal Dave
SQL Puzzle
SQL Scripts
3 Comments

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

Continue Reading
Jul27

Running Distinct Counts: Working Around COUNT(DISTINCT) OVER

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server
No Comments

Your report wants unique customers so far, and SQL Server refuses COUNT(DISTINCT) over a window. Flag each first appearance and add up the flags instead.

Continue Reading
Jul26

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

Pinal Dave
SQLAuthority News
Life Lessons, Pluralsight, SQL Milestone
2 Comments

12 Years, 50 Courses looks back on how one SQL Server video course grew into more than fifty, the setbacks along the way, and the people who made it possible.

Continue Reading
Previous 1 … 34 35 36 37 38 39 40 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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