PowerShell: Resolve partial computer names, CNAME’s & IP Addresses to concrete Host name / IP

One can refer to a host by several means. Where I am at, we generously use CNAME's to point to host to insulate the applications from having to change when then hostname changes. For example, if the hostname for Dev SQL Server is ddxumapDEV, then we might have a cname entry that says "Dev-SQL". All … Continue reading PowerShell: Resolve partial computer names, CNAME’s & IP Addresses to concrete Host name / IP

Advertisements

Get Operating System Name (Linux / UNIX / Windows) Using PowerShell

As I manage Oracle and SQL Server databases on both Linux and Windows, I sometimes need to determine the OS type before I work with the host so that I can do things conditionally in PowerShell. I looked around the Web and could not find a good example of how to get this information except … Continue reading Get Operating System Name (Linux / UNIX / Windows) Using PowerShell

Parsing Out Oracle TNSNames.ora Using PowerShell

TNSNames.ora If you work with Oracle, you are no stranger to TNSNames.ora whether or not you currently use it. In short, it is a local/network configuration file used by the Oracle client(s) to point and connect to Oracle databases. One could use other methods like LDAP or EZConnect as alternatives but TNSNames.ora is more common … Continue reading Parsing Out Oracle TNSNames.ora Using PowerShell

Invoke-Async – Asynchronous parallel processing for any workload in PowerShell

Why asynchronous processing? If it takes a man 10 hours to do something, technically, it would take just one hour if 10 men did it. Right? Not quite, but it is somewhat true in the analogous computing world if resources are hardly maxed out when 10 threads are at work. It is more true when … Continue reading Invoke-Async – Asynchronous parallel processing for any workload in PowerShell