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
Dec31

Ranking Items by Rating Fairly With a Bayesian Average

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

Use Bayesian average in SQL Server with practical examples, clear checks, and the limits you need before changing your database.

Continue Reading
Dec30

SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution

Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts, SQL Server
10 Comments

Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.

Continue Reading
Dec29

SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?

Pinal Dave
SQL Tips and Tricks
MySQL, PostgreSQL, SQL Function, SQL Scripts, SQL Server
3 Comments

How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.

Continue Reading
Dec28

Developer – 10 Phrases Developer Use Too Often

Pinal Dave
SQL Tips and Tricks
Professional Development, SQL Server
20 Comments

I am a developer and so are most of my friends. Here are 10 phrases every developer says too often, from ‘I can fix that’ to ‘That’s not my code’.

Continue Reading
Dec27

MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL

Pinal Dave
SQL Tips and Tricks
MySQL
1 Comment

Copied a SQL Server script with GO into MySQL and got an error? Here is how to change delimiter in MySQL so it accepts GO as a statement terminator.

Continue Reading
Dec26

SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health

Pinal Dave
SQL Tips and Tricks
Notes from the Field
No Comments

How did Notes from the Field start? Here is the story behind the series and a roundup of the 2013 episodes on performance tuning and database health.

Continue Reading
Dec25

SQL Server Performance Stack: Look Beyond the Query

Pinal Dave
SQL Tips and Tricks
Disk, Notes from the Field, SQL Performance, SQL Server, Virtualization
No Comments

Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.

Continue Reading
Previous 1 … 453 454 455 456 457 458 459 … 847 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