This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to get insight into the top offenders. I mentioned that workload analysis could be […]
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? Where did the availability group go when the failover occurred? The goal of this blog […]
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! John Sterrett will be presenting a half day precon in Mufreesboro, TN on Thursday, January 11, 2018, […]
T-SQL Tuesday #96: Folks Who Have Made A Difference Today’s blog post is about T-SQL Tuesday. If you haven’t seen T-SQL Tuesday before its a great monthly call for all SQL Server bloggers to write about one topic that always changes from month to month. In this months installment, we’re focusing on folks who made […]
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, I want to focus on two small underdog features that might be game changers on how you do […]
We are proud to announce that John Sterrett will be speaking at Microsoft Ignite. This will be John’s first time speaking at the Microsoft Ignite conference. John will be talking about migrating existing databases over to Azure. If you are going and passionate about your data, SQL Server, or just want some help solving your […]
In my opinion, automation will enhance DBAs. It will allow DBAs to provide more value to the business. Good DBAs will be fine. If you are a DBA with ten years of DBA experience who just repeats year one ten times, this might be a different story for a different blog post. Therefore, automation enhances […]
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 when taking the transactional log backups?” The Missing Question First, a better question is “should […]
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 Log Backups Your last line of defense in any SQL Server Disaster Plan is recovering […]
The following are some resources that are included in John Sterrett’s Introduction to Performance Tuning with Azure SQL Databases Idera Geek Sync. Performance Root Cause Analysis Toolkit Calculate DTU on Your Own Benchmark Azure SQL Database Wait Stats What Is Running Microsoft – Improved Automated Tuning SQL Database Advisor Azure SQL Database Features