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
In Part 1 of this series we began to look at how you can leverage PowerShell as a DBA and there was a brief discussion about automation. Today you will experiment with the DBATools command Copy-DbaLogin and learn about Out-Gridview and the -whatif switch. Let’s suppose you have one, or more logins you need to … Continue reading Introduction To PowerShell For The DBA Part 2
Automating Tasks With PowerShell What we’re really talking about in this series is automation, specifically by using PowerShell. Now, in simple terms, automation is about removing the human, manual element in doing tasks. Why should you care about that? Automation will provide the following benefits: Automation saves you time Automation provides consistency Automation results … Continue reading Introduction To PowerShell for the DBA Part 1
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