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
May10

SQL SERVER – Error Msg 5042, Level 16 – The File ‘tempdev02’ Cannot be Removed Because it is Not Empty

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL TempDB
7 Comments

Removing an extra TempDB file gave me Error Msg 5042: the file ‘tempdev02’ cannot be removed because it is not empty. Here is how I got rid of it.

Continue Reading
May9

PowerShell – Backup SQL Server System Databases

Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Backup and Restore, SQL Scripts, SQL Server
2 Comments

A client visit showed me that basics like system database backups often get missed. Here is a PowerShell way to back up SQL Server System Databases.

Continue Reading
May8

List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Stored Procedure
12 Comments

In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.

Continue Reading
May7

SQL SERVER – Change Color for System Object Name in Text Editor (SSMS 2016)

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio
No Comments

SSMS 2016 shows system objects and DMVs in a color that is hard to read. Here is how I changed the system object color in the Text Editor back to the old style.

Continue Reading
May6

SQL SERVER – Optimizing Tabular Models for Self-Service Reporting: Summarize By – Notes from the Field #123

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Analysis Services, SQL Scripts, SQL Server
1 Comment

Bill Anton explains how the Summarize By property helps you optimize Tabular Models for self-service reporting, where users build their own reports.

Continue Reading
May5

SQL SERVER – Skip “Save Changes to the Following Items?” Prompt in Management Studio (SSMS 2016)

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio
11 Comments

Tired of the ‘Save changes to the following items?’ prompt when closing query windows? SSMS 2016 has a setting to skip it, and here is where to find it.

Continue Reading
May4

SQL SERVER 2016 – Scroll Bar Enhancement in Management Studio (SSMS 2016)

Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio
3 Comments

SSMS 2016 has new Scroll Bar settings tucked away under Tools, Options. I walk through each option, what it changes and which ones I find useful.

Continue Reading
Previous 1 … 325 326 327 328 329 330 331 … 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