In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which might appear during installation or AddNode.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 1
In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which might appear during installation or AddNode.
SQL SERVER – Parallel Redo on AlwaysOn Secondary – DIRTY_PAGE_TABLE_LOCK
As most of you might know that my expert area in SQL Server in performance tuning. But, I also deal with almost every issue related to SQL Server engine. Many times, it so happens then clients call me for performance tuning and while fixing, we see some other problem. In this blog, we would learn about Parallel Redo on AlwaysOn Secondary causing new waits which were introduced in SQL Server 2016.
SQL SERVER – Setup / Installation Error – Updating Permission Setting for File ResumeKeyFilter.Store Failed
My client contacted me for a quick assistance in a setup trouble. She informed me that it’s a brand-new install and its failing at the end. She was installing SQL Server 2016 on Windows Server 2016. Let us learn about how to fix Installation Error.Â
SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.
One of my clients had an interesting situation where none of the SQL Maintenance plans were working. The example what I am using here is a SQL Server backup maintenance plan failing. I also saw a behavior where all the individual jobs were working fine as expected.
SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled
This was one of an interesting issue reported by my client. They informed that after some hardening by the security team, they are not able to bring SQL resource online in the cluster. In this blog, we would learn about how to fix the issue where SQL cluster is not coming online.
How to Generate Fibonacci Series for the First 1000 Values? – Interview Question of the Week #174
Question:Â How to Generate Fibonacci Series for the First 1000 Values?