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
Oct28

Searching Every Error Log for Slow I/O Warnings

Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server
No Comments

The warning you need may be in an archived log. Here is a short loop that searches every retained error log and tells you which ones it could not read.

Continue Reading
Oct27

SQL Server Wait Stats: eBook to Download on Kindle and My Answer to Free PDF Requests

Pinal Dave
Personal
SQL Book, SQL Server, SQL Wait Stats
9 Comments

SQL Server Wait Stats was my first book experiment. Here is how I answered readers who asked for a free PDF, and what the Kindle offer looked like in 2011. Prices and offers are from that time.

Continue Reading
Oct26

What to Check When You Are Woken at Three in the Morning

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server
10 Comments

Use a DBA on call checklist to establish impact, inspect blocking and disk space, review failed jobs, and choose a safe next step during incidents.

Continue Reading
Oct25

SQLAuthority News – Meeting SQL Friends – SQLPASS 2011 Event Log

Pinal Dave
SQLAuthority News
SQL PASS, SQLAuthority Author Visit
4 Comments

The best part of SQLPASS 2011 was meeting SQL friends I usually only talk to on Facebook and Twitter. Here are a few of our photos together.

Continue Reading
Oct24

SQLAuthority News – Story of Seattle – SQLPASS 2011 Event Log

Pinal Dave
SQLAuthority News
SQL PASS, SQLAuthority Author Visit
2 Comments

My SQLPASS 2011 event log in photos from Seattle: the skyline, the convention center, the gum wall, the first Starbucks and people on the street.

Continue Reading
Oct23

SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

Pinal Dave
SQL Interview Questions and Answers
SQL Error Messages, SQL Server Express
7 Comments

Connecting to SQL Server Express failed while obtaining the dedicated administrator connection (DAC) port. Here is why it happens and how to fix it.

Continue Reading
Oct22

Personal Notes – Random Thoughts and Random Ideas

Pinal Dave
Personal
Personal Technology
5 Comments

There are days when I keep on wondering about SQL, and even my life overall. Let us see some random thoughts and random ideas.

Continue Reading
Previous 1 … 570 571 572 573 574 575 576 … 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