Skip to content

Instantly share code, notes, and snippets.

Working from home

Aaron Kim ahkim

Working from home
View GitHub Profile
ahkim / Why Insights matter to
Created Jul 19, 2016
Food for thoughts. Why would data insights matter to integration? How integration helps better Data Insights? etc. Summary of the deck found in
View Why Insights matter to

Insights matter to Integration

Product owner, BA, IT Pro/Support, etc. no one knows what Integration ninja does and the integration platform is just a secret box to them. However, there are always available insights for every stakeholder in your integration solutions.


  • Insights are the secret sauce to culture change
  • Insights make people feel aware and involved

Process Insights

ahkim / ManipulateADF.ps1
Created Jul 14, 2016
Useful powershell cmdlets for Azure Data Factory
View ManipulateADF.ps1
# ManipulateADF.ps1
# automate log-in
$resourceGroupName = "{your_resource_group}"
$azureAccountName = '{your_email}'
$azurePassword = ConvertTo-SecureString '{your_password}' -AsPlainText -Force
$azureRMCredential = New-Object System.Management.Automation.PSCredential($azureAccountName, $azurePassword)
$account = Login-AzureRmAccount -Credential $azureRMCredential
ahkim / 그것을알려주마 - Blackfish vs Black
Last active Jul 11, 2016
서호주 블랙피시와 동부해안 블랙피시의 차이
ahkim /
Created Jul 4, 2016
This demonstrates how you could post message from yammer group to slack channel using Azure Logic App + API App.

Yammer message in a group to Slack channel using Azure Logic App

This is how easy it is from a designer view. Add api app for yammer and slack in sequence and configure login. Done.

When you switch to codeview, you can configure more in detail(trigger interval, etc.)

ahkim /
Last active Feb 18, 2018
함께 하고 싶은 명언
  • 기회는 늘 단 한번 뿐이라는 걸 알았을때 난 누구보다 필사적으로 임할 수 있었다. 그 어떤 작은 일이라도 시시하게 보지 마라. 그걸 기가 막히게 해내 버렸을 때 당신은 가장 우뚝 솟을 수 있을 테니까. 안도 다다오

  • 리스크와 수익률을 적절히 추정할 수 없다면 투자해선 안 된다. 리스크란 자신이 무엇을 하는지 모르는 데서 온다. 그 무엇이든 가치가 아닌 가격흐름에 베팅하는 것은 투기다.

  • A calm and humble life will bring more happiness than the pursuit of success and the constant restlessness that comes with it. - Albert Einstein

  • There's no better feeling than throwing what you've caught on the table and feeding your family

  • When I was 17, I read a quote that went something like: "If you live each day as if it was your last, someday you'll most certainly be right." It made an impression on me, and since then, for the past 33 years, I have looked in the mirror every morning and asked myself: "If today were the last day of my life, would I want do to what I am about to do today?" And whenever the answer has been "No" for too many days in a row, I know I need to chance something. - Steve Jobs

ahkim / 0. Prerequisites.sql
Last active Jan 24, 2020
These code snippets are to demonstrate how you should use PolyBase in step by step. You should have a blob storage and storage secret handy beforehand and execute this from SQL Server 2016 or Azure DW, etc.
View 0. Prerequisites.sql
DECLARE @serverName VARCHAR(20)
DECLARE @storageLocation VARCHAR(MAX)
SET @serverName = convert(VARCHAR(20),(SELECT SERVERPROPERTY('ServerName')))
IF(@serverName = 'peet-bi-dev')
SET @storageSecret = '{your_own_secret}'
SET @storageLocation = 'wasbs://{container_name}@{storage_name}'
ahkim / Australia Open
Last active Jun 27, 2016
Open Data - Add open data source here
View Australia Open
ahkim / VMWareToHyperV.makefile
Last active Jun 22, 2016
Converting VMWare image to Hyper-V image
View VMWareToHyperV.makefile
- This covers converting image to creating virtual machine from Hyper-V using converted image.
PS C:\Program Files (x86)\Microsoft Virtual Machine Converter Solution Accelerator> .\mvdc.exe "G:\Application Data\vpc\VMWare\AK_SP_DoFSupport\SP_DoFSupport-cl1.vmdk" "D:\temp\AK_SP_DoFSupport.vhd"
- Above now no longer available. Instead, use Powershell way
- I find this still doesn't work with oracle virtual box. In that case, you could also use the tool oracle virtual box provides