SQL Server Availability Groups Are Not the Solution!
SQL Server Availability Groups Are Not the Solution! That’s right. Availability groups are fairly easy to set up and can add flexibility and recovery capabilities to your SQL Server database environment, but they are not your solution. They can be your disaster without proper planning, evaluation, and implementation. Let’s take a look at some of […]
SQL Server Log Shipping – Rapid Restart after Planned Failover
SQL Server Log Shipping – Rapid Restart after Planned Failover I was chatting with a group of DBAs the other day when the subject of SQL Server Log Shipping came up. The consensus between them was that Log Shipping is a great, cheap feature but that the time it took to get it restarted after […]
SQL Server Transactional Replication Latency Check
SQL Server Transactional Replication Latency Check SQL Server replication latency checks are often unreliable. Sure, you can automate tokens and the like, but in the end, you need to know “Am I synchronizing regularly?” and “Do I have a large number of undistributed commands?” Requirements: Setup: The first step is to establish a table to […]