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 …
