A Beginner’s Guide to SQL Server Backups
DBA 101, Disaster Recovery or High Availability, EducationAs 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?
Disaster Recovery or High AvailabilityIn 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
Disaster Recovery or High Availability, EducationHave 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!
Disaster Recovery or High AvailabilityIn 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?
Disaster Recovery or High Availability
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…
Five Reasons Why Log Shipping Should Be Used
Disaster Recovery or High AvailabilitySQL 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?
Community, Disaster Recovery or High AvailabilityCurious 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
Disaster Recovery or High AvailabilityThe 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…