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
Apr18

Windows Clusters in Different Domains: Deploying a Distributed Availability Group

Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL High Availability, SQL Server, SQL Server Cluster
3 Comments

After a merger, a client had Windows clusters in different domains that were connected but not trusted, and no wish to use certificates. Here are the steps I shared to deploy a Distributed Availability Group with NTLM pass-through authentication.

Continue Reading
Apr17

SQL SERVER – Event ID 1069 – Unable to Failover Clustered Instance to Another Node. Resource is not Loaded

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

My lab failover clustered instance would not move to the other node: Event ID 1069, resource is not loaded. Here is what the logs showed and the fix.

Continue Reading
Apr16

SQL SERVER – Unable to Add Node – Could not find subkey System \ CurrentControlSet \ Services \ MSSQLFDLauncher. Error code 0x851B0001

Pinal Dave
SQL Tips and Tricks
SQL Search, SQL Server, SQL Server Cluster, SQL Server Services
2 Comments

Running add node on Node2 failed with “Could not find subkey MSSQLFDLauncher”, error 0x851B0001. The cause was a missing Full-Text MSI in the setup media.

Continue Reading
Apr15

What are Ports Needed to Configure Log Shipping? – Interview Question of the Week #169

Pinal Dave
SQL Interview Questions and Answers
Computer Network, Log Shipping, SQL Server
No Comments

What are ports needed to configure log shipping? A client in a locked-down network asked me, and here is the list of ports to open on the firewall.

Continue Reading
Apr14

SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Trigger, Starting SQL
1 Comment

A reader used HOST_NAME() in a logon trigger to limit access. Here is why that is risky, and why Logon Triggers can lock everyone out if you are not careful.

Continue Reading
Apr13

SQL SERVER – Error: 1067 – Unable to Bring Analysis Service Online in Cluster

Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Analysis Services, SQL Error Messages, SQL Server, SQL Server Cluster
No Comments

A client could not bring the Analysis Service online in a cluster, and the logs only said Error 1067. Here is the systematic approach that found the cause.

Continue Reading
Apr12

Faster Backups With BUFFERCOUNT and MAXTRANSFERSIZE, Measured

Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Performance, SQL Server
No Comments

Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.

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