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
Mar14

SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server DBCC, SQL Server Security
No Comments

Attaching MDF and LDF files after a disaster failed with Msg 2571: user guest does not have permission to run DBCC checkprimaryfile. Here is the fix.

Continue Reading
Mar13

SQL SERVER – Puzzle – How Does YEAR Function Work?

Pinal Dave
SQL Puzzle
SQL DateTime, SQL Function, SQL Scripts, SQL Server
18 Comments

SELECT YEAR(35000/20) returns 1904, which looks strange. This puzzle shows how the YEAR function treats a plain integer. Can you explain the result?

Continue Reading
Mar13

Salted Password Hashes With HASHBYTES and CRYPT_GEN_RANDOM

Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Random, SQL Server
No Comments

A salt makes two identical passwords look different, yet it does not slow down guessing. Here is a small demo of both, and what to use instead.

Continue Reading
Mar12

SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (404) Not Found

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, Starting SQL
1 Comment

Error 3271 during backup to URL has many causes. After the 403 and 400 versions, here is what causes the (404) Not Found error and how to fix it.

Continue Reading
Mar11

What is Alternative to CASE Statement in SQL Server? – IIF Function – Interview Question of the Week #164

Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts, SQL Server
46 Comments

What is the alternative to CASE statement in SQL Server? The IIF function. Here are two examples of CASE and IIF, and why IIF deserves more use.

Continue Reading
Mar10

Automatic Plan Correction: Reading SQL Server’s Tuning Advice

Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Performance, SQL Server 2017
No Comments

Read automatic plan correction advice, compare regressed and recommended plans, and verify that forcing the last good plan held.

Continue Reading
Mar9

SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (403) Forbidden

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, Starting SQL
5 Comments

A reader’s backup to URL failed with Error 3271: the remote server returned an error: (403) Forbidden. Here is how I reproduced it and the easy fix.

Continue Reading
Previous 1 … 227 228 229 230 231 232 233 … 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