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

Optimize SQL Queries: Make Your Database Run Faster

Optimize Sql Queries: Make Your Database Run Faster

Optimize SQL Queries: Make Your Database Run Faster As a business or project owner, you know the importance of efficiently using resources. You know that time wasted on inefficient queries is expensive. Your business may rely on cloud database technology for its robust ability to store and analyze data. But unless you optimize SQL queries, […]

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