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
Jan27

Tracking Which Updates Every Server Has

Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Monitoring, SQL Patch, SQL Server
No Comments

Tracking Which Updates each SQL Server runs takes a dated inventory table, SERVERPROPERTY snapshots, and a report of instances behind the target.

Continue Reading
Jan27

Connecting to SQL Server From Java, Python and .NET

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

Choose a SQL Server driver for Java, Python, or .NET, then verify encryption, authentication, pooling, and the application's connection.

Continue Reading
Jan26

Operator Cost Percentages Are Estimates: Read Actual Time Instead

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

Read operator cost percentages as estimates, then use actual rows, elapsed time, IO, and repeated work to find the real bottleneck.

Continue Reading
Jan25

SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation

Pinal Dave
SQL Performance
SQL Data Storage, SQL Scripts, SQL Server DBCC, SQL Server Security
58 Comments

Is shrinking NDF and MDF files safe? A reader asked if it causes data loss. It does not, but I explain why shrinking them is often not a good idea.

Continue Reading
Jan24

Connecting Excel to SQL Server Safely

Pinal Dave
SQL Tips and Tricks
Excel, SQL Server, SQL Server Security, SQL View
No Comments

Connecting Excel to SQL Server safely means a narrow read-only view, a scoped login, controlled refresh load, and no saved password in the workbook.

Continue Reading
Jan23

SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2

Pinal Dave
SQL Performance
Best Practices, SQL Scripts, SQL Server DBCC, SQL System Table
19 Comments

An updated script to find the longest running query in SQL Server 2005 and 2008, with the divide by zero error fixed and time now shown in milliseconds.

Continue Reading
Jan22

SQLAuthority News – Milestone of 6 Million Visits – 60 Lak Visits – Search and Job

Pinal Dave
SQLAuthority News
Database, DBA
4 Comments

SQLAuthority.com crossed 6 Million Visits in 2 years and 3 months. Thank you, readers! I also announce a small surprise for readers who take part here.

Continue Reading
Previous 1 … 723 724 725 726 727 728 729 … 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