Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

Aaron Kim ahkim

🏠
Working from home
View GitHub Profile
@ahkim
ahkim / Why Insights matter to Integration.md
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 http://biztalk360.blob.core.windows.net/integrate2016/Michael-Stephenson-Integration-in-Digital-Transformation.pptx
View Why Insights matter to Integration.md

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 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
ahkim / 그것을알려주마 - Blackfish vs Black Drummer.md
Last active Jul 11, 2016
서호주 블랙피시와 동부해안 블랙피시의 차이
@ahkim
ahkim / yammer2slack.md
Created Jul 4, 2016
This demonstrates how you could post message from yammer group to slack channel using Azure Logic App + API App.
View yammer2slack.md

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

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

  • 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 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 @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 Jun 27, 2016
Open Data - Add open data source here
View Australia Open APIs.md
@ahkim
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.
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