The Cloud or On-Premise – Is it a go or no go?
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
I have seen this question many a time that people have asked “The Cloud or On-Premise – is it a go or no go?”. This is something that has been discussed and debated, in detail for a longer period of time. Let’s see what it is and if it is a go or no go? What is On-Premise? As we know, by definition On-Premise is a term that we use when our data, application, server(s), or data are kept at one of the premises of the Organization. What is the Cloud? Cloud – This is one of the best things that happened in this era. Basically, the cloud is a service offering using which we can host our server(s ..read more
Visit website
Cluster Service Failed To Bring Clustered Role Online Or Offline
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
This weekend I was working, as usual, holding the on-call and listening to my favorite singer Kishor Kumar. And, my friend Rakesh call me in jeopardy. One of his clients has reported that one of their Cluster Service failed to bring clustered role online or offline. And, that the cluster is failing back to the primary, not moving to the secondary server.  Before proceeding further I have asked him a few questions that we normally asked like: What is the version of the SQL Server? It was SQL Server 2012 What is the edition of the SQL Server? SQL Server Enterprise Edition What is t ..read more
Visit website
Call for Speaker Surat Tech Talks 2022
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
Last year, September 2020 we had organized 1st yearly event and we named it Surat Tech Talk. That event was a great success. This year, we are organizing this event again and the call for speaker Surat Tech Talks 2022 is now open. The event is being organized with the help of Surat User Group and Surati iLab Foundation. Last year, the event this year is 2 day event, online only event. We had total of 12 sessions covering various technical and semi technical topics from Cloud Technologies, Data Platform, DevOps, Development, BigData, Patent and Research, Science of Great UI, GitHub, Kubernetes ..read more
Visit website
Data Platform MVP
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
I have a good news to share with you all. This year, 1st of August 2021 I have received an email that surprised me. The email reads that I have been awarded Most Valuable Professional. I am feeling so happy and excited to be the Data Platform MVP again, almost after 10 years. Here is the link to my MVP profile on Microsoft website. I am feeling gear up and charged. I will be now more active in community activities. Please expect more blog(s), YouTube videos, Speaking and forum contribution hereafter. Not because I am recipient of the MVP award but because my contribution will now have more vis ..read more
Visit website
SQL Server Agent failed to update history
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
Recently I have faced a very interesting issue. A good friend of mine and my batchmate Rakesh called me this morning. He told me that one of his customers has an on-premise SQL Server standard edition. His customer has scheduled a handful of jobs and it runs fine. However, when he wanted to check the job history using Job Activity Monitor he noticed that the SQL Server Agent failed to update history. This means, he is unable to see the next run date and if the job was completed successfully or failed in the last run. At first, he thought it is an issue with the SQL Server Agent service account ..read more
Visit website
How to fix replication issue cannot truncate table
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
I have the privilege to work on Saturday and Sunday, holding a pager during my shift hours. I get most of the blog ideas during this stint. Today’s post is no exception. In the month of  October while working on one of the weekends I have the pager alert that reads like the one below. cannot truncate table SomeTble_Subscriptions because it is published for replication or enabled for Change Data Capture. It was past midnight for my client so I was the one who has to decide the next course of action, I don’t even need to inform him. Of course, at these hours of night, he is not going to r ..read more
Visit website
Recovery Unit InitPersistentVersionStore Failed
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
As usual, I was working on my weekend on-call and I have had an alert. Our monitoring system has reported a message printed from the error log. I was seeing this very message I haven’t seen so far. The message Recovery::UnitInitPersistentVersionStore Failed exactly looks like the one below: RecoveryUnit::InitPersistentVersionStore failed with db [18] name [master] I was a little skeptical about this message. Hence I logged into the server for further investigation. The server was all good. Everything is green. And this message looks like For Your Information type of message to me. I have dec ..read more
Visit website
Recover Database using Stellar Repair for MS SQL
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
One of my friends client has got an issue with his SQL Server. A weekly database integrity check has reported a corruption for one of his databases. The corruption reported was of consistency type. There are manual and automated methods for repairing database corruption. I have Recover Database using Stellar Repair for MS SQL for this very case. Let me brief you about the consistency error first and then I will give you overview of how easy it is to use Stellar Repair for MS SQL. Consistency Errors SQL Server database is Crucial and important where in your production are dependent on this and ..read more
Visit website
An error occurred while writing an audit trace. SQL Server is shutting down
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my shift. And, just a few minutes later after assuming the pager. The mobile screen flashed with the message, a welcoming message. The message on my phone says An error occurred while writing an audit trace. SQL Server is shutting down. Just like what I have always done. I Logged on to the system. The SQL Server is not up and running. Tried to start the Service manually and it failed. I have then started reviewing the error logs. SQL Server Error log ..read more
Visit website
Query Store Best Practice and Configuration
SQL Server Citation Blog
by Hemantgiri Goswami
7M ago
In my previous blog post  I have talked about What is the Query Store and How to setup the Query Store. In this blog post today, I will explain the options that you may need to configure according to the need of your workload, let’s call it the Query Store Best Practice and Configuration. Query Store Best Practice and Configuration Best Practice, most probably you all are aware what does this means but let me tell you. Best practice is a method which is generally accepted as standard practice. Best practices are to keep standards or quality or bench-marking. Normally, Best practice is not ..read more
Visit website

Follow SQL Server Citation Blog on Feedspot

Continue with Google
OR