After a merger, a client had two Windows clusters in untrusted domains and no wish to use certificates. Here is how I deployed a Distributed Availability Group.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Event ID 1069 – Unable to Failover Clustered Instance to Another Node. Resource is not Loaded
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.
SQL SERVER – Unable to Add Node – Could not find subkey System \ CurrentControlSet \ Services \ MSSQLFDLauncher. Error code 0x851B0001
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.
What are Ports Needed to Configure Log Shipping? – Interview Question of the Week #169
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.
SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name
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.
SQL SERVER – Error: 1067 – Unable to Bring Analysis Service Online in Cluster
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.
Faster Backups With BUFFERCOUNT and MAXTRANSFERSIZE, Measured
Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.
SQL Server slow? Let's fix it together in about four hours.
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.