On the first day of Christmas dbatools gave to me: Find-DbaCommand On the second day of Christmas dbatools gave to me: Get-DbaCmsRegServer Command Information: On the second day of Christmas we are going to build upon what we learned and how to scale the use of the commands in dbatools. I am sure like me Read More …
On the first day of Christmas dbatools gave to me: Find-DbaCommand Command Information: Let’s start the festivities off with a way to get familiar with the over 500 commands that dbatools provides us. It can be a daunting task to import the module and then start scrolling through the functions directory to find what you Read More …
In the spirit of the Holiday Season, I am going to pay tribute to dbatools using the Christmas carol; “The 12 Days of Christmas” to highlight 12 of the greatest functions to help a SQL DBA’s life. I have been wanting to do a series of blog posts, and felt inspired when I heard the Read More …
Recently I have been taking an online training course in preparation to take the Microsoft 70-532 certification exam. My studies have made me realize how easy to use and fun playing in the cloud can be. You can create a virtual machine, install some stuff, do some stuff and then delete it all in Read More …
From the creators of the wildly popular dbatools open source PowerShell project comes dbachecks. Harnessing the power of the Pester framework and the amazing PSFrameWork module by Fred Weinmann (t) , the team has put together a module that compiles the checklists that all good DBA’s should be performing on their environments. This list of checks Read More …
For this week I am going to go through a process that I developed and am pretty proud of. We the DBA Team are responsible for getting data in to our Integration environments and higher. We do not trust the developers with this responsibility as they would probably break something. Issue Recently one of our Read More …
It is no secret that I have become a Fan-Boy of the open source community project dbatools. I have been in IT for over 20 years and have worked with different scripting languages for performing tasks. In recent years, I have “hacked” together PowerShell scripts I found online to accomplish specific tasks. dbatools takes DBA Read More …
Here is a continuation blog on things I learned to do with PowerShell to fix an issue in my day-to-day task list. This one may not be daily, but I think it might help someone out there. Previous Posts: Part 1 of 4 Part 2 of 4 Issue: A couple weeks ago we had a Read More …
Continuing on my PowerShell learning journey, this is part two of my series for the SQL DBA. This will focus on the DBATools utility that was originally built for SQL Migration by Chrissy LeMaire (t) and has evolved into an awesome tool that will help your average DBA automate tasks and be able to get Read More …
In years past I have attempted to learn PowerShell numerous times. Usually I just hack together a solution to a current problem I am trying to solve. I never really sat down and learned the fundamentals. As my SQL environment grows and interesting requests come in from management and other internal partners I see the Read More …
