Hello my fellow DBAs and dear readers!
My personal project in this case, started as a need for my job. High security measures were forcing us to stop any scripting over Linux, where our databases are (100+ databases, over 200 instances) running. Added to those limitations, no BASH for Windows or cygwin available for installation on workstations. This pushed me to find something else. Python, maybe? Can’t install extensions. Perl? adds complexity that I couldn’t afford due to time frames. I end up saying: Let’s give PowerShell a shot.
I start looking for resources and found some nice videos about PowerShell on the Microsoft Virtual Academy a couple weeks ago. As I progress on the lessons from MVA and start applying what I learn to my own PS scripts, I get a nice taste of what this can become.
We all know for a fact that the Windows console sucks big time. It falls pale when compared to Bourne Again Shell (a.k.a. BASH) and other popular Linux shells. So, it happened that Microsoft started this PowerShell thing. something that looked similar to the console, but different.
On it early stages, it was awful. But now, this kid known as PS has grown to a solid v5.1 that has some very nice functionalities. Let’s face it. We rely on Linux for servers, but Windows, Active Directory and the general Microsoft ecosystem is pretty robust when it comes to enterprise software infrastructure.
Now, I’m an Oracle DBA, looking for a way to do what I did on Linux, but from a Windows workstation. What I found was amazing and as I advance on my PS skills building, I will be posting PowerShell scripts on my GitHub powershell repository to share it with you all.
I highly recommend automation and scripting enthusiasts to take a look at what PowerShell has to offer, especially now that PowerShell 6(Beta) is also available for Linux.
The ability to use other tools and integrate them into the PS script make it a particularly good option for interacting with files, databases and all kinds of objects and data sources.
The future is uncertain, but everything seems to lead to a wonderful mix of tools and architectures that can make our life as DBAs a lot easier.
Write-Output "See you soon"