A client added a DR node but was unable to failover AlwaysOn Availability Group to it. The listener had only one IP address, and here is the fix.
How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161
How do you get VLF Count and size in SQL Server? Newer versions add a Dynamic Management Function for it. Here is the query, plus links to my older methods.
SQL SERVER – Patch Rule Failure: Not Clustered or the Cluster Service is Up and Online
A SQL Server 2016 service pack failed the rule “Not clustered or the cluster service is up and online”. Here is what Detail.txt showed and how we fixed it.
SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)
Creating a new maintenance plan on my virtual machine failed with cannot create a task from XML, error 0x80070057. Here is the fix that worked for me.
SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
Patching a clustered SQL instance, setup warned: Cluster Resource DLL Update Restart Check. A hard lesson on why you should not ignore this warning.
SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine
Can’t connect from SSMS on your own machine to SQL Server in an Azure Virtual Machine? Here is the network-related error users see and what to check to fix it.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed
One more cause of the script level upgrade failure for ‘sqlagent100_msdb_upgrade.sql’: Error 5041, MODIFY FILE failed. Here is how I fixed it.