Along with performance consulting, sometimes I also get requests from a few clients to look at the AlwaysOn availability group related problems.
SQL SERVER – Unable to Apply Security Patch – The setup has encountered an unexpected error in datastore
One of my clients reported that he is trying to apply security patch for SQL Server clustered instance and it was failing. Since this is SQL 2005 instance, there is no official support available from Microsoft at this point. So, they contacted me. I asked to share setup logs and found a very interesting note.
SQL SERVER – Fix – Error 15240, Severity: 16, State: 2 – Cannot write into file
I always keep playing with my virtual machine which has SQL Server installed. Recently I was trying to apply the patch of SQL Server and I was surprised to see that SQL Server was not getting started after patching. The error was Error 15240 it cannot write into file.
SQL SERVER – The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid
Let us learn in this blog how to fix The Log Scan Number Passed to Log Scan in Database ‘master’ is not Valid. Let us learn in this blog post.
SQL SERVER – Why Cluster Network is Unavailable in Failover Cluster Manager?
It’s always a good experience to visit customer sites and talk to people. Sometimes I get to see things outside SQL world as well. There is a lot to learn and I believe that I can do that by sharing what I learned. In this blog post we will discuss Why Cluster Network is Unavailable in Failover Cluster Manager?
SQL SERVER – Query to Get the List of Logins Having System Admin (sysadmin) Permission
Though the script sounded simple to me, but I found that there are lots of incorrect scripts available on the internet. Here is the one of the script I found to find out the details of the system admin.
SQL SERVER – How to get historical deadlock Information from System Health Extended Events?
Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier?