A Data Gman
Toggle navigation
  • Home
  • Resources
  • About

Check for Open Firewall Port

By Aaron Grossman • April 06, 2019 • 0 Comments

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

Continue Reading
Quick Reference

Installing Microsoft Visual C++ 14.0 Offline

By Aaron Grossman • November 13, 2018 • 0 Comments

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.

  1. Download the Build Tools executable from the network installation page.
  2. Set up a folder on a drive where you have
Continue Reading
SQL Server,Python

Using PyHive in EMR

By Aaron Grossman • October 31, 2018 • 0 Comments

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

Thrift

Continue Reading
Quick Reference,Python,AWS,EMR,Hive

PowerShell Tips: Call Operator

By Aaron Grossman • September 02, 2018 • 0 Comments

I've really enjoyed working in PowerShell, but having never really worked with the Command Line or shell scripting before, there's a lot of little tips and tricks out there that I wish had been compiled into a quick start guide.

One of those examples is how a command would work

Continue Reading
Quick Reference,PowerShell

Getting started with modern web development

By Aaron Grossman • July 05, 2018 • 0 Comments

Lately my focus has been on becoming more familiar with modern web development practices. To grow this skill set, I ended up using Colt Steele's The Web Developer Bootcamp on Udemy. I would highly recommend this training for anyone wanting to know more about creating the front-end part of a

Continue Reading
Getting Started,Web Development
Page 2 of 3

Find me on

  • Aaron Grossman's DEV Profile

Tags

AWSDAXEMRETLGetting StartedGuideHivePower BIPower QueryPowerShellPresentationPythonQuery FoldingQuick ReferenceSecuritySQL ServerWeb Development

Twitter

Tweets by ADataGman

Recent Post

Filter Table by Another in Power Query
January 25, 2020
Basic App Security for Beginners with Environment Variables
August 16, 2019
Importing Sibling Packages in Python
August 04, 2019

Tags

AWSDAXEMRETLGetting StartedGuideHivePower BIPower QueryPowerShellPresentationPythonQuery FoldingQuick ReferenceSecuritySQL ServerWeb Development
Copyright © 2021, A Data Gman. All right Reserved.