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
Dec7

SQL SERVER – Fix the Error – Accessing this Server via SQL Management Objects (SMO) or Distributed Management Objects is Currently Not Permitted

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Management Studio
2 Comments

After applying STIG to SQL Server 2016, SSMS said accessing this server via SQL Management Objects (SMO) is not permitted. Here is the cause and the fix.

Continue Reading
Dec6

SQL SERVER – Unable to Launch SSMS Error – Cannot Find One or More Components. Please Reinstall the Application

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Management Studio
22 Comments

I had SSMS 17.1 installed on the machine and it was working fine. I don’t remember what I installed, but I started facing an SSMS error.

Continue Reading
Dec5

SQL SERVER – Msg 3743: The Database is Enabled for Database Mirroring. Database Mirroring Must be Removed Before you Drop the Database

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Mirroring, SQL Scripts, SQL Server
3 Comments

Msg 3743 says the database is enabled for database mirroring, and mirroring must be removed before you drop it. Here is how my client got past it.

Continue Reading
Dec4

Building Demo Data With GENERATE_SERIES

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Sample Database, SQL Server, Testing
No Comments

Build demo data with GENERATE_SERIES, weighted categories, customer skew, random amounts, and validation that preserves repeatable tests.

Continue Reading
Dec3

When to Use IDENT_CURRENT? – Interview Question of the Week #150

Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Identity, SQL Scripts, SQL Server
1 Comment

When should you use IDENT_CURRENT instead of SCOPE_IDENTITY()? A question I heard at the Group By conference, answered with the key difference.

Continue Reading
Dec2

SQL SERVER – Backup to URL error: Operating system error 50(The request is not supported.)

Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Error Messages, SQL Server, Windows
4 Comments

Backing up a database to Azure gave me a backup to URL error: Operating system error 50, the request is not supported. Here is the cause and the fix.

Continue Reading
Dec1

SQL SERVER – Execution Failed. See the Maintenance Plan and SQL Server Agent Job History Logs for Details

Pinal Dave
SQL Tips and Tricks
Maintenance Plan, SQL Error Messages, SQL Server
4 Comments

My client ran a new Maintenance plan for full and log backups and it failed at once. The reason was two subplans in one plan. Here is how to run them.

Continue Reading
Previous 1 … 241 242 243 244 245 246 247 … 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