Backup to a domain share from a Workgroup SQL Server failed with operating system error 1326, unknown user name or bad password. Here is the fix.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage
My backups to Azure kept piling up. Here is the PowerShell script I wrote to remove old SQL database backup files from Azure Storage automatically.
SQL SERVER – FIX: Msg 15281- SQL Server Blocked Access to Procedure ‘sys.xp_cmdshell’ of Component ‘xp_cmdshell’
Msg 15281: SQL Server blocked access to procedure ‘sys.xp_cmdshell’ because it is turned off. Here is how to turn xp_cmdshell on with sp_configure.
Linked Server Error Msg 7356: Provider Metadata That Changed
Diagnose Msg 7356 by comparing linked-server column metadata, stabilizing pass-through projections, and reviewing provider configuration.
SQL SERVER – FIX – Error 1402. Could not open key: UNKNOWN\Components. System error 5
Installing a SQL Server service pack failed with Error 1402. Could not open key: UNKNOWN\Components. System error 5. Here is the fix.
SQL SERVER – FIX: Error 19456: None of the IP Addresses Configured for the Availability Group Listener can be Hosted by the Server
Deploying a hybrid AlwaysOn availability group across on-premises and Azure, adding a replica failed with error 19456. Here is what fixed it.
How to Add Date to Database Backup Filename? – Interview Question of the Week #109
A reader using Backup to URL asked how to add the date to a Database Backup Filename. Here is a script that builds the name for you.
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.