Reading the SQL Server Error Log is important when troubleshooting many issues for SQL Server. Some example issues would be errors related to Always On Availability Groups, long IO occurrence messages, and login failures. Unfortunately, the SQL Server Error Log can be very full of information, making specific things hard to find, … Continue reading How To Read The SQL Server Error Log
You need to create a SQL Server inventory. Without this information, you’ll be unaware of critical information about the environment your responsible to manage. We’re on a journey to make sure that you as a DBA know what SQL Servers are in your environment so you know what you’re responsible for managing. As your guide, … Continue reading How to Build a SQL Server Inventory Using T-SQL Scripts
Everyone wants good performance from their database systems. Some even expect and need a high performing Ferrari all the time. How is this achieved though? What do you need to understand about SQL Server specifically in order to make your company’s applications hum along like a well tuned car? We will look at three keys … Continue reading Three Keys to SQL Server Performance
So, I realize it’s now almost April of 2021 when I’m posting this. Normally this sort of post would come out in January for the previous year. However, I have a reason for this being late and I’ll actually post about that separately. Showing My Blog Some Love In mid-2020 I decided to give my … Continue reading Top 3 Most Popular Posts of 2020
I currently manage 5 AlwaysOn Availability Groups. Two are on SQL Server 2014 and overdue for an upgrade, while three of them are on SQL Server 2017. From time to time I have run into a couple of different situations that I needed to troubleshoot and I want to tell you where to look and … Continue reading My Availability Group Database Isn’t Synchronizing
Production and Development DBA Skills and Things We Didn’t Touch On We’ve covered a lot of ground for Production and Development DBAs in terms of the skills and applicable career topics. We’ve mentioned necessary skills with T-SQL, backup/restore, automation, PowerShell, troubleshooting, SSIS, SSRS, patching, Query Store, HA/DR, leadership and emotional intelligence. That’s quite a list! … Continue reading How Do I Measure My DBA Skills Part 9
Senior Development DBA You’ve now likely reached the last stop in your career as a Development DBA. You have arrived at the Senior level. What skills do you have or should you be working on as a Senior Development DBA? I’m glad you asked. Let’s find out. Senior Development DBA – 7+ years of experience … Continue reading How Do I Measure My DBA Skills Part 8
Lead Development DBA Over the past few weeks I have been writing about DBA skills for various career levels, and for a couple of different DBA types – the Production DBA and the Development DBA. Today, we’re examining the Lead Development DBA. You’ll discover what this person needs to know. DEV DBA III/Lead Development DBA … Continue reading How Do I Measure My DBA Skills Part 7
Development DBA II With the last post, we began talking about the Development DBA and the skills needed at the beginning of this career path. Now it’s time for you to ponder what the next level looks like. Development DBA II – 2 to 4 Years of Experience All competencies from level 1 Develop basic … Continue reading How Do I Measure My DBA Skills Part 6
In this series on measuring your DBA skills, we’ve been discussing what skills you should have at each phase of your career. So far we’ve covered the entry level skills and the phase 2 skills a Production DBA needs. In this part of the series you’re discovering what a Production DBA needs to know or … Continue reading How Do I Measure My DBA Skills Part 3