Queries on SQL Server Replication? Check out our blog to get'em answered , that will give you an overview of the “Replication in SQL server”. Highlights of the blog:- What is replication? Why we should use Replication? What is replication ...read more

In this article We are going to discuss about pre-allocation scenarios and their aftermaths for SQL Server 2008 compressed backup. We will try to simulate that compressed backup may succeed if disk space is less and may fail if disk space is more depending ...read more

I ran into a very interesting issue with temp tables recently, when working on a case. The issue description goes something like this. We have an application preparing some SQL statements, and sending them to the SQL Database engine for execution. However ...read more

In this blog we would discuss about behavior of AlwaysON where the secondary database doesn't come automatically when the primary instance goes down. The secondary database goes into Resolving state. On the failover cluster manager the resource appears ...read more

Recently I have had a customer complaining that when he is adding more subscriptions to his publication, distribution agent job for the newly added subscriptions would not start.  And when he tried to start the distribution agent job manually, it ...read more