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 – 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?
SQL SERVER – Unable to Start SQL Service – Server TCP provider failed to listen on [‘any’ 1433]. Tcp port is already in use.
While playing with my multiple SQL instances, I realized that I was not able to start one of the SQL instance on my laptop. Here is the error which I received when I tried starting it from Start > Run > Servics.msc . This error is related to TCP provider.
SQL SERVER – Installation Error – [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
One of my blog readers sent an email to me asking for assistance. They were trying to patch SQL Server 2005 in the cluster and the setup was failing to patch database services with below error related to data source name.
SQL SERVER – Fix Error Msg 13603 working with JSON documents
Working with new data types is something we need to evolve. In this blog, I have written on a number of articles on JSON which you can take a look at. I wanted to write about some of the interesting errors one will get when using JSON custom paths. This is something I stumbled accidentally when using JSON constructs. Let us see how to fix error 13603 while working with JSON documents.