SQL Server Express has no SQL Agent, so automation is harder. Here is a PowerShell script to delete old backup files in SQL Express with Task Scheduler.
SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node
Many problems lead to the same symptom. Here is another reason for an empty startup parameter in SQL Cluster, when it was not a registry permission issue.
SQL SERVER – Backup to URL error: Operating system error 50(The request is not supported.)
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.
SQL SERVER – Unable to Get Listener Properties Using PowerShell – An Error Occurred Opening Resource
A client could not change listener properties with PowerShell and got “An error occurred opening resource”. Here is the T-SQL query I shared and what fixed it.
SQL SERVER – PowerShell Script – Remove Old SQL Database Backup Files From Azure Storage
Earlier back, I wrote blog to help my blog reader SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files from Azure Storage
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 – PowerShell Script – Getting Properties and Details
A retail client runs 1500+ databases with fewer than 10 DBAs, so automation matters. Here is a PowerShell script to get SQL Server properties and details.