Why Hire an SQL Server Consultant?

Hire An Sql Server Consultant

Why Hire an SQL Server Consultant? Almost every business accumulates data that needs to be managed and optimized. If your business has an in-house SQL Server DBA, or team of them, it might be tempting to assume they can handle all your data needs. In other words, if someone suggests you hire an SQL Server […]

Google: Best Friend or Worst Enemy of DBA?

Dba - Database Administrator

Google: Best Friend or Worst Enemy of DBA? Watch the Video on LinkedIn As a Database Administrator, Google can be your best friend and worst enemy. It’s often the first stop for troubleshooting, but you still have to know what you’re doing or you’re going to cause some huge headaches. ๐—จ๐—ป๐—ฑ๐—ฒ๐—ฟ๐˜€๐˜๐—ฎ๐—ป๐—ฑ๐—ถ๐—ป๐—ด ๐—ฆ๐—ฐ๐—ฟ๐—ถ๐—ฝ๐˜ ๐—œ๐—บ๐—ฝ๐—ฎ๐—ฐ๐˜: When you […]

SQL Server Log Shipping – Rapid Restart after Planned Failover

Sql Server Log Shipping

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 Replication Latency Checks

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 […]