The Cloud or On-Premise – Is it a go or no go?
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...
2022-03-17
1 reads
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Cluster Service Failed To Bring Clustered Role Online Or Offline
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...
2022-02-18
Call for Speaker Surat Tech Talks 2022
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...
2021-12-14
Data Platform MVP
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...
2021-12-03
SQL Server Agent failed to update history
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...
2021-07-27
How to fix replication issue cannot truncate table
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...
2020-11-21
Recovery Unit InitPersistentVersionStore Failed
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...
2020-07-14
Recover Database using Stellar Repair for MS SQL
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...
2019-05-28
An error occurred while writing an audit trace. SQL Server is shutting down
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...
2019-01-01
Query Store Best Practice and Configuration
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...
2018-09-25
1 reads
Blogs
Daily Coping 27 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Seeding an Availability Group Replica from Snapshot
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
Forums
OLE DB provider \"SQLNCLI11\" for linked server
We have a DTS package running on one of the production server. This is...
Need to provide access to database without giving access to production
Hoping I could find some best practice answers here: We have analysts who need...
Fill missing rows in dataset
I have data in table like this. I want to fill/insert the rows with...
Ask SSC