SQL Server blocking occurs when one connection places a lock on a table (or selected rows, pages, extent) and another connection attempts to read or modify the data when the lock is in effect. Continue reading #SqlServer interview question: What is blocking?
Tag Archives: server
Automating Tranzactional Initialization from a backup in SQL Server
Scenario
There are situations where you might have a large SQL Server database that you need to replicate. Since the database is very large we want to initialize the Subscriber from the SQL Server backup and not use a snapshot. How do we bundle all the steps together to achieve this without performing them manually?
Solution
I want to cover the basic steps needed to setup a “Push Type Transactional Replication”. This tip assumes you already have an understanding of SQL Server Transactional Replication and I will show how to bundle all the steps into one process. Continue reading Automating Tranzactional Initialization from a backup in SQL Server
Peer to peer replication in SQL Server 2005
SQL Server 2005 has a lot of features and sometimes these additions are overlooked as a new way of configuring and managing your SQL Server environment.
One of these features is Peer to Peer transactional replication. In the past, people have used transactional replication for load balancing, to keep a read only version for reporting purposes or possibly for a failover solution. Continue reading Peer to peer replication in SQL Server 2005
Reinitialize subscriptions in SQL Server replication
Scenario
You have a transactional replication configured in your production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that you can use to reinitialize a subscription for transactional replication.
Solution
If we come across this requirement there are different ways by which we could achieve this. In this tip, we will accomplish this by using SQL Server Management Studio (SSMS) and Replication Monitor. Note, both options assume transactional replication is already configured in your server. Continue reading Reinitialize subscriptions in SQL Server replication
Availability options for SQL Server
Scenario
You need to implement a high availability solution for one of your SQL Server databases, but you’re not sure of which option to implement to satisfy your company’s needs. Check out this tip to learn about the five native SQL Server High Availability options: