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
May2

Splitting DBCC CHECKDB Across the Week for a Large Database

Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Server, SQL Server DBCC
No Comments

Keep a large database under regular integrity checks by splitting DBCC CHECKDB work across seven nights and auditing coverage.

Continue Reading
May1

SQL SERVER – How to Get SQL Server Agent Properties?

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Agent, SQL Server Management Studio
1 Comment

During a health check someone asked if SQL Server Agent has settings to tune. It does. Here is how to get SQL Server Agent properties with a simple script.

Continue Reading
Apr30

SQL SERVER – Installation Error – Unable to Open Windows Installer File – 2147286960

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, SQL Server Management Studio, Windows
No Comments

Installing SQL Server 2016 failed with “Unable to open Windows Installer file” and error -2147286960. Here is what caused it and how I fixed the setup.

Continue Reading
Apr29

How to List All the SQL Server Jobs When Agent is Disabled? – Interview Question of the Week #171

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Agent
No Comments

When SQL Server Agent is disabled, you cannot expand it in SSMS to see its jobs. Here is how to list all the SQL Server Jobs with a simple query instead.

Continue Reading
Apr28

SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing

Pinal Dave
SQL Tips and Tricks
Registry, SQL Error Messages, SQL Log, SQL Server, SQL Server Installation, SQL Service Pack
1 Comment

A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.

Continue Reading
Apr27

ENCRYPTBYPASSPHRASE: Simple Encryption and Its Weak Spot

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

One function in, one function out, and then the real question: where does the passphrase live? A short tour with demos you can run.

Continue Reading
Apr26

PowerShell – Get Maximum Memory of Server with dbatools

Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Memory, SQL Scripts, SQL Server
No Comments

Readers asked how to get started with dbatools. Here is a simple first step: finding the maximum memory of a server with one PowerShell command.

Continue Reading
Previous 1 … 220 221 222 223 224 225 226 … 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