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

Should I Upgrade My SQL Server?

Should I Upgrade My Sql Server

Should I Upgrade My SQL Server? Why fix an element of your business that’s still running fine? Many industries run on this idea—don’t fix it until it’s properly broken. When it comes to your server, you may have a similar approach. “Why would I upgrade my SQL server now, when everything is working just fine?”  […]

SQL Server Availability Groups are not the solution!

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

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