dbatools installs as a PowerShell module on a Windows management machine. Rob Sewell, known as DBA with Beard, introduced me to it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Transaction Log Backups Based on Log Size
Transaction log backups on a schedule can miss a burst of activity that fills the disk. This post builds a procedure that reads the log written since the last backup and takes a log backup once it passes a limit you choose. It also explains why the old habit of shrinking the log after each backup does harm.
SQL SERVER – SharePoint not Working After Failover to Another Node
After a SQL Server cluster failover, SharePoint users could not open any page, though all SQL resources were online. Here is what we found and how we fixed it.
How to Force a Parallel Execution Plan for a Query? – Interview Question of the Week #170
A customer asked how to force a Parallel Execution Plan for a query. Here are two methods, including QUERYTRACEON 8649, with a simple example.
SQL SERVER – FIX – Error 1402 – Could not Open Key: UNKNOWN\Components – System Error 5 (Another Solution)
Installing KB3045311 failed with Error 1402, could not open key UNKNOWN\Components, system error 5. When my earlier fix did not help, this one worked.
SQL SERVER – FIX: Unable to Create Distribution Database on a UNC Share – Configure Distribution
With SQL Server on a UNC share, the Configure Distribution wizard refuses network paths for the distribution database. Here is how to create it anyway.
SQL SERVER – Unable to Start SQL After Patching – Database SSISDB is Enabled for Database Mirroring
After patching, SQL Server would not start. The SSIS hotfix script failed because database SSISDB is enabled for Database Mirroring. Here is the fix.
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.