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
Aug19

SQL SERVER – Backup to URL Fails in Azure Resource Manager (ARM) Deployment Model with Error – (400) Bad Request

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Error Messages, SQL Server
5 Comments

Backup to URL failed with (400) Bad Request on storage created in the Azure Resource Manager model. Here is why and how my client got it working.

Continue Reading
Aug18

SQL SERVER – False Error – Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.)

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server
5 Comments

BULK INSERT said ‘Operating system error code 5 (Access is denied.)’ but that was not the real problem. A repro of this misleading error and the real cause.

Continue Reading
Aug17

Database Sharding – How to Identify a Shard Key?

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Server, SQL Server Architecture
1 Comment

Picking the shard key is the hardest part of Database Sharding. Here are the guiding principles I shared at a user group for choosing a good one.

Continue Reading
Aug16

PowerShell – SQL Server Paging of Memory Identification

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

After a client case of memory pressure, I wrote a PowerShell script to spot SQL Server Paging, when SQL Server memory is being paged out to disk.

Continue Reading
Aug15

SQL SERVER – A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Wait Stats
1 Comment

Event ID 7011: a timeout was reached while waiting for a transaction response from MSSQLSERVER. It happened when my client expanded an Oracle linked server.

Continue Reading
Aug14

How to Drop Clustered Index on Primary Key Column? – Interview Question of the Week #084

Pinal Dave
SQL Interview Questions and Answers
Clustered Index, SQL Constraint and Keys, SQL Server
8 Comments

DROP INDEX fails with Msg 3723 on a primary key. Here is how to drop clustered index on a primary key column the right way, through the constraint.

Continue Reading
Aug13

SQL SERVER – Installation Fails With Error – A Constraint Violation Occurred

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Error Messages, SQL Server
No Comments

SQL Server cluster Installation Fails with ‘A constraint violation occurred’ as the network name won’t come online. I’ve fixed it for 10 clients.

Continue Reading
Previous 1 … 310 311 312 313 314 315 316 … 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