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 …

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 …

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 …

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

Update (Mar 16, 2018): Please check-out my most recent blog post related to this on how to use this to invoke your own PowerShell function in parallel: https://sqljana.wordpress.com/2018/03/16/powershell-sql-server-run-in-parallel-collect-sql-results-with-print-output-from-across-your-sql-farm-fast/ 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 …