Managing quorum failover in SQL cluster
SQL Server cluster is one of the HA feature. If we are confiureing 2 node cluster one being active and the other being passive. If there...
Transaction management Part(1)
The core feature of any database including SQL Server is its ability to ensure that transactions are atomic—that is, all or nothing....
Accelerating business with SQL Server 2016
Business users and decision makers demand: Retain cold data for many years (indefinitely) Cold data must be available and online Storage...
Msg 7314 + The OLE DB provider "SQLNCLI11"
I was unable to run queries against another database table using link server. The query yell with the following error Msg 7314, Level 16,...
Handling memory corruption
I think you will all agree with me that database corruption is one of the nightmares in the life of a DBA. . A database corruption issue...
SQL Server In-memory story
In-memory table was introduced in SQL Server 2014. This powerful technology allows usto take advantage of large amounts of memory and CPU...
Stretch database to Azure
With stretch Database to Azure you will be able to store or archives your historical data transparently and securely. This feature is...
Upgrade fails from SQL Server 2008R2 to SQL Server 2014
After a great struggle & multiple tries, I was able to upgrade the DB engine to SQL 2014 from SQL Server 2008R2 for one of my client....
The initial snapshot for publication is not yet available.
After removing one of the article from my existing publisher, I reinitilized the replication with new snapshot but nothing was being...
