This weekend I was working, as usual, holding the on-call and listening to my favorite singer Kishor Kumar. And, my…
Last year, September 2020 we had organized 1st yearly event and we named it Surat Tech Talk. That event was…
I have a good news to share with you all. This year, 1st of August 2021 I have received an…
By Hemantgiri Goswami Administration Troubleshooting
Recently I have faced a very interesting issue. A good friend of mine and my batchmate Rakesh called me this…
By Hemantgiri Goswami HADR Troubleshooting
I have the privilege to work on Saturday and Sunday, holding a pager during my shift hours. I get most…
By Hemantgiri Goswami HADR Troubleshooting
As usual, I was working on my weekend on-call and I have had an alert. Our monitoring system has reported…
By Hemantgiri Goswami Troubleshooting
One of my friends client has got an issue with his SQL Server. A weekly database integrity check has reported…
By Hemantgiri Goswami Troubleshooting
There was this incident at one of the clients in recent past. It was a nice morning. I was…
By Hemantgiri Goswami Configuration
In my previous blog post I have talked about What is the Query Store and How to setup the Query…
By Hemantgiri Goswami Configuration
In the previous blog post, I have discussed the Query Store (QS) explaining what it is? In this blog post,…
By Hemantgiri Goswami HowItWorks
What is the Query Store in SQL Server 2016? – Rakesh asked me. And, the discussion continued for half an…
By Hemantgiri Goswami Troubleshooting
This week’s blog post comes from Rakesh Yadav, a good friend of mine. Rakesh is dealing in hardware basically, and…
By Hemantgiri Goswami HADR Troubleshooting
Always On, it is the feature that I liked the most. In the recent past, I have had so many…
Last week, during my on-call stint I was paged for an error. This error message wasn’t unfamiliar actually but I…
Lately, I have had the chance to work on the replication topology a lot. Few of our customers had implemented…
By Hemantgiri Goswami HowItWorks
Just like the other days I was talking to a good friend of mine about performance issues he had lately….
In the past I have had written many articles that talks about Cloud technology including a series of articles that…
By Hemantgiri Goswami Administration
This week I am going to tell you a story. A story of a friend of mine who always come…
By Hemantgiri Goswami Administration HADR
I have often seen many people get confused about High Availability[HA] and Disaster Recovery [DR]. HA and DR both serve…
By Hemantgiri Goswami Configuration Troubleshooting
At begining of the week, I had this email from a good friend of mine. On one of his server,…
By Hemantgiri Goswami HADR Troubleshooting
There is always a story behind a blog post for me. This week’s blog post is not an exception….
Last week, in my previous post I talked about the Data Validation and explained what it means. I talked about…
Replication is an amazing topology, it is one of the most used technology when it comes to making available data…
This week’s blog post comes out of the discussion I and Manish, a friend of mind. A few weeks back,…
By Hemantgiri Goswami Configuration
In this post, let’s take a look at Best Practice for Anti Virus on SQL Server. Before we jump into…