Skip to content

Instantly share code, notes, and snippets.

View ahkim's full-sized avatar
๐Ÿ 
Working from home

Aaron Kim ahkim

๐Ÿ 
Working from home
  • Perth, Australia
View GitHub Profile
@ahkim
ahkim / Why Insights matter to Integration.md
Created July 19, 2016 07:13
Food for thoughts. Why would data insights matter to integration? How integration helps better Data Insights? etc. Summary of the deck found in http://biztalk360.blob.core.windows.net/integrate2016/Michael-Stephenson-Integration-in-Digital-Transformation.pptx

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.

Benefits

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

Process Insights

@ahkim
ahkim / ManipulateADF.ps1
Created July 14, 2016 01:56
Useful powershell cmdlets for Azure Data Factory
#
# 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
ahkim / ๊ทธ๊ฒƒ์„์•Œ๋ ค์ฃผ๋งˆ - Blackfish vs Black Drummer.md
Last active July 11, 2016 07:44
์„œํ˜ธ์ฃผ ๋ธ”๋ž™ํ”ผ์‹œ์™€ ๋™๋ถ€ํ•ด์•ˆ ๋ธ”๋ž™ํ”ผ์‹œ์˜ ์ฐจ์ด
@ahkim
ahkim / yammer2slack.md
Created July 4, 2016 06:39
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
ahkim / Quotes.md
Last active February 18, 2018 12:16
ํ•จ๊ป˜ ํ•˜๊ณ  ์‹ถ์€ ๋ช…์–ธ
  • ๊ธฐํšŒ๋Š” ๋Š˜ ๋‹จ ํ•œ๋ฒˆ ๋ฟ์ด๋ผ๋Š” ๊ฑธ ์•Œ์•˜์„๋•Œ ๋‚œ ๋ˆ„๊ตฌ๋ณด๋‹ค ํ•„์‚ฌ์ ์œผ๋กœ ์ž„ํ•  ์ˆ˜ ์žˆ์—ˆ๋‹ค. ๊ทธ ์–ด๋–ค ์ž‘์€ ์ผ์ด๋ผ๋„ ์‹œ์‹œํ•˜๊ฒŒ ๋ณด์ง€ ๋งˆ๋ผ. ๊ทธ๊ฑธ ๊ธฐ๊ฐ€ ๋ง‰ํžˆ๊ฒŒ ํ•ด๋‚ด ๋ฒ„๋ ธ์„ ๋•Œ ๋‹น์‹ ์€ ๊ฐ€์žฅ ์šฐ๋š ์†Ÿ์„ ์ˆ˜ ์žˆ์„ ํ…Œ๋‹ˆ๊นŒ. ์•ˆ๋„ ๋‹ค๋‹ค์˜ค

  • ๋ฆฌ์Šคํฌ์™€ ์ˆ˜์ต๋ฅ ์„ ์ ์ ˆํžˆ ์ถ”์ •ํ•  ์ˆ˜ ์—†๋‹ค๋ฉด ํˆฌ์žํ•ด์„  ์•ˆ ๋œ๋‹ค. ๋ฆฌ์Šคํฌ๋ž€ ์ž์‹ ์ด ๋ฌด์—‡์„ ํ•˜๋Š”์ง€ ๋ชจ๋ฅด๋Š” ๋ฐ์„œ ์˜จ๋‹ค. ๊ทธ ๋ฌด์—‡์ด๋“  ๊ฐ€์น˜๊ฐ€ ์•„๋‹Œ ๊ฐ€๊ฒฉํ๋ฆ„์— ๋ฒ ํŒ…ํ•˜๋Š” ๊ฒƒ์€ ํˆฌ๊ธฐ๋‹ค.

  • 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
ahkim / 0. Prerequisites.sql
Last active January 24, 2020 09:45
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.
DECLARE @serverName VARCHAR(20)
DECLARE @storageSecret VARCHAR(MAX)
DECLARE @storageLocation VARCHAR(MAX)
SET @serverName = convert(VARCHAR(20),(SELECT SERVERPROPERTY('ServerName')))
IF(@serverName = 'peet-bi-dev')
BEGIN
SET @storageSecret = '{your_own_secret}'
SET @storageLocation = 'wasbs://{container_name}@{storage_name}.blob.core.windows.net'
@ahkim
ahkim / Australia Open APIs.md
Last active June 27, 2016 08:21
Open Data - Add open data source here
@ahkim
ahkim / VMWareToHyperV.makefile
Last active June 22, 2016 03:21
Converting VMWare image to Hyper-V image
- This covers converting image to creating virtual machine from Hyper-V using converted image.
http://infrahouse.wordpress.com/2013/10/28/how-to-convert-vmware-based-virtual-machines-and-disks-vmdk-to-hyper-v-based-virtual-machines-and-disks-vhd-using-microsoft-virtual-machine-converter-solution-accelerator-mvmc/
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
http://wdbuc.com/blog/2015/03/09/convert-vmware-virtual-disks-to-hyper-v-virtual-disks-with-powershell-mvmc-3-0/
- I find this still doesn't work with oracle virtual box. In that case, you could also use the tool oracle virtual box provides
http://superuser.com/questions/483756/converting-a-vmdk-to-vhd