A Data Gman
Toggle navigation
  • Home
  • Resources
  • About

Filter Table by Another in Power Query

By Aaron Grossman • January 25, 2020 • 0 Comments

There are many approaches to filter one table with another using Power Query. The most common solution I found was to join tables together, and then delete the resulting joined results. This feels like a poor solution, and reviewing Table.Contains, this seems like a good way to provide filtering

Continue Reading
Power BI,Power Query

Basic App Security for Beginners with Environment Variables

By Aaron Grossman • August 16, 2019 • 0 Comments

I'm learning about application development, and I rarely see beginner topics discuss security for an application as you begin development. I've found that using environment variables to keep your secrets safe is an effective way to use source control and not commit your passwords or expose other material you want

Continue Reading
Python,Security

Importing Sibling Packages in Python

By Aaron Grossman • August 04, 2019 • 0 Comments

I've put together a snippet of code to demonstrate how to import sibling packages and modules in Python 3, with a working example out on GitHub as python-sibling-import-example.

To run this, add this snippet to the start of any Python file in your project not at the root:

if __name_
Continue Reading
Python

Linux Equivalent on Windows

By Aaron Grossman • July 27, 2019 • 0 Comments

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.

  • Windows Commandline
Continue Reading
Quick Reference

Start PowerShell script from one window in another

By Aaron Grossman • June 25, 2019 • 0 Comments

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

Continue Reading
PowerShell,Quick Reference
Page 1 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.