Reading about tools more commonly used on *nix than Windows such as Python and Ruby, there's often references to command line utilities on Linux. These often have a Windows equivalent, and I'm going to compile the list of references I use here to make them easier to find.
Aaron Grossman
Hi, I'm Aaron Grossman, a Business Intelligence developer documenting what I've learned as I continue to grow my career.
I can be reached at me@aaronjgrossman.com.
To call a PowerShell (PS) script from another PowerShell script and have it run in a second terminal window without exiting, you can use a script similar to:
Start-Process PowerShell.exe -ArgumentList "-noexit", "-command .\local_path\start_server.ps1"
When developing in Visual Studio Code, I
If you need to figure out whether a port is open between two machines in the firewall, Telnet is a useful program commonly referenced at my employer.
The format for the command in Windows is: telnet <address> <port>. A successful connection is just a blank command
To install Microsoft Visual C++ 14.0 offline requires a few steps. This was part of the process for getting SQL Server 2017 with Machine Learning / Python running at work.
- Download the Build Tools executable from the network installation page.
- Set up a folder on a drive where you have
Using PyHive on AWS (Amazon Web Services) has been a real challenge, so I'm posting all the pieces I used to get it working.
Components Installed
PyHive
python3 -m pip install --user pyhive
SASL
sudo yum install cyrus-sasl-devel - Courtesy of Stack Overflow
python3 -m pip install --user sasl
