SQL Server professionals may be reluctant to start using PowerShell. After all, you already know T-SQL well and can do a lot with that to manage SQL Server. I’ve been using PowerShell to manage SQL Server for the last 5 years and it has revolutionized how I interact with SQL Server. For example, … Continue reading 6 Reasons to Learn PowerShell
As data professionals responsible for SQL Server, it is drilled into our heads that we need to take backups. But, how do we know we actually have backups available to us when we need them? How can we verify that a backup has been taken? Some types of auditing that an employer has to … Continue reading 3 ways to verify that a backup has taken place
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’re a data professional and you’ve been given the keys to a new SQL Server environment. You know you need to build a SQL Server inventory so you know what is in your environment, but how do you get that information? One of the things I have talked about in other posts is how to … Continue reading How to Build a SQL Server Inventory Using PowerShell
I recently needed to configure log shipping for multiple databases at once as part of a migration project. I turned to PowerShell to do this. But before we get to that part, this post assumes that you’ve done the upfront work to create shares for the backups to write to and for the backups to … Continue reading How To Use Powershell to Configure Multiple Databases for Log Shipping
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
Over the last 9 weeks I took you on a journey of skills and career topics related to being a SQL Server DBA. We looked at the Production DBA. We saw skills and career topics from the beginning to mid-career to Senior DBA. Then we looked at the Development DBA and their skills and career … Continue reading Measuring Your DBA Skills
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
Hello dear reader! This is the third post in a series to help you get started automating things with PowerShell. You will be looking at how to start and stop SQL Server using PowerShell as well as setting the Max Server Memory setting, measuring free disk space and more. This series is just an introduction … Continue reading Introduction To PowerShell For The DBA Part 3