What is Transactional Replication

SQL Server Transactional Replication Internals SQL Server Transactional Replication is one of the most common Replication techniques used to share, copy, or distribute data to multiple destinations. In this article, we will discuss Replication, various Replication Types, and pay special attention to the Transactional Replication work. What is SQL Transactional Replication? Replication is the SQL […]

The ultimate guide to High Availability methods for Microsoft SQL Server

Backups, downtime, and the importance of High Availability Following on from our High Availability Whitepaper and Server Sizing Guide, which focus on the Application Server, I’m going to drill down into the High Availability options available within Microsoft SQL Server to hopefully set you up to have some high-level chats with customers. As you’ll see, there’s no one-size-fits-all […]