A client’s ERRORLOG said: New parallel operation cannot be started due to too many parallel operations executing at this time. Here is what I found behind it.
SQL SERVER – Cluster Install Failure – Code 0x84cf0003 – Updating Permission Setting for Folder Failed
A SQL Server cluster install failed with code 0x84cf0003: Updating permission setting for folder failed. Here is why volume mount points can cause it.
How to Shrink All the Log Files for SQL Server? – Interview Question of the Week #203
Question: How to Shrink All the Log Files for SQL Server? Here is the script, plus why you should shrink only log files and never data files.
SQL SERVER – Small Backup for Large Database
A client’s 900 GB database made a backup of under 300 MB, and they feared data was missing. Here is what explained the small backup for a large database.
SQL SERVER – What is the Meaning of PREEMPTIVE_HTTP_EVENT_WAIT? How to Fix it?
I blocked internet access on my Azure SQL Server VM with an outbound rule and started seeing PREEMPTIVE_HTTP_EVENT_WAIT. Here is one possible cause of this wait.
SQL SERVER – Finding Compression Ratio of Backup
Is there a way to know the compression ratio of backup files in SQL Server? Here is a quick script on msdb backupset that compares backup size with compressed size.
SQL SERVER – SQL Server Management Studio Crash While Using Backup to URL or Connecting to Storage
During an urgent restore, SSMS crashed each time my client picked URL to restore from Azure Blob Storage. Here is how to fix the crash when connecting to storage.