A Beginner’s Guide to SQL Server Backups

, ,
As was discussed in a previous blog, (The Most Important Role of a SQL Server DBA) Backups and Recovery are the cornerstone of all successful SQL Server DBA careers.  Exactly how much attention is paid to backups until something drastic…

Where is my Availability Group Primary Replica?

In SQL Server 2012 we got this new high availability feature called availability groups. With readable secondaries under the covers, it can be harder to figure out the answer to the following two questions. When did the availability group failover?…

Building Your First Always On Availability Group

,
Have you wanted to build an availability group but didn’t know where to start?  If so, we have discounted SQL Server Availability Group training for you! Join us for pre-conference training brought to us by SQL Saturday Nashville!…

SQL Server 2017: Making Backups Great Again!

In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators.  While SQL Server 2017 added so many great features like graph, SQL on Linux, and more.  Today,…

Should We Compress SQL Server Backups?

Last week we covered five reasons why log shipping should be used.  I got a great question that I thought should be answered here in a short blog post.  The question is "how do you configure transactional log shipping to include compression…
Automatic Tuning: Execution Plan Correction

Five Reasons Why Log Shipping Should Be Used

SQL Server comes with several options to keep your data highly available. Today we are going to cover five different reasons why Transactional Log Shipping should be one of your best tools in your SQL Server DBA Toolbelt.  Validates Transactional…

Want to Learn which SQL Server High Availability Features Are For You?

,
Curious about the basics of SQL Server High Availability?  Please join our founder and MVP, John Sterrett, where he will be presenting SQL Server High Availability 101 on Tuesday, July 18th, 2017 at the North Austin SQL Server User Group.…

The Most Important Role of a SQL Server DBA

The most important task a DBA can perform is Recovery. The work of a SQL Server DBA is ever-changing; data is fluid, and accordingly, so is the manner in which data is treated.  Thankfully there are a vast number of ways to keep up with the…