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
Mar26

Consulting 102 – What Do I Promise in Every Engagement?

Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, Consulting, SQL DMV, SQL Server, SQL Wait Stats
No Comments

Know what I promise in every engagement, define a useful baseline, and compare performance changes without trusting a speed claim.

Continue Reading
Mar25

Consulting 101 – Why Do I Never Take Control of Computers Remotely?

Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, Consulting, SQL DMV, SQL Server
6 Comments

I avoid control of computers remotely so your team owns each action, protects credentials, and learns a tuning process it can repeat.

Continue Reading
Mar24

How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Configuration
3 Comments

How Does QUOTED_IDENTIFIER Works in SQL Server? I explain it in very simple words, using SELECT “Order By” with the setting OFF and then ON.

Continue Reading
Mar23

SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login

Pinal Dave
SQL Tips and Tricks
AlwaysOn, Computer Network, SQL High Availability, SQL Server, SQL Server Management Studio
2 Comments

A client’s Always On read-only routing failed with: an error was encountered during handshakes before login. Here are the checks I shared and how we fixed it.

Continue Reading
Mar22

Wide Update Plans: What Every Extra Index Costs a Write

Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Server
No Comments

Inspect wide update plans, compare index-maintenance work with narrow updates, and read per-index counters without misreading STATISTICS IO.

Continue Reading
Mar21

Recent Rows Only: A Filtered Index for the Data Everyone Reads

Pinal Dave
SQL Performance
Data Warehousing, Master Data Services, SQL Data Storage, SQL Index
No Comments

A filtered index for recent rows is small and fast, but its date never moves by itself. Here is how to build it, test it and keep it fresh.

Continue Reading
Mar20

How to Track Data Platform Service Level and Performance Before and After Consolidation?

Pinal Dave
SQL Tips and Tricks
Resource Governor, SQL Server
No Comments

Planning data platform consolidation? Track service level and performance before and after consolidation, so you know how well the planning worked.

Continue Reading
Previous 1 … 173 174 175 176 177 178 179 … 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