Chan Ming Man
Deploy SSIS package to SSIS IR using Visual Studio
Author: Chan Ming Man

This blog post shows you to deploy SSIS project to SSIS IR in Azure. The pre-requisite of this post; 1. You need to know SSIS. 2. You have Windows Azure subscription. (They are few points missed in this document https://docs.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure.) … Continue reading

Published at 02 Jul 2020

Read more...
Goh Chun Lin
Generating Patient Data with Synthea and Storing them in Azure Storage
Author: Goh Chun Lin

Almost two years ago, I was hospitalised in Malaysia for nearly two weeks. After I returned to Singapore, I was then sent to another hospital for medical checkup which took about two months. So I got to experience the hospital operations in two different countries. Since then I always wondered how patient data was exchanged […]

Published at 29 Jun 2020

Read more...
Chan Ming Man
Clean all bin obj folder in all folders Visual Studio
Author: Chan Ming Man

This short post shows you how to clean all bin obj folder in all folders. This will clean up all the builds in all the development folder. You need to run the following PowerShell command with administrator right. gci -inc … Continue reading

Published at 28 Jun 2020

Read more...
Chan Ming Man
Declare a Enum with bitwise operator
Author: Chan Ming Man

This post shows a good practise to declare a Enumerator, Enum. You can see the practical use of bitwise operator in the example. Instead of ReadWrite = 3 You can do ReadWrite = Read | Write like the example below … Continue reading

Published at 27 Jun 2020

Read more...
Chan Ming Man
VC++ CLR connect to SQL Azure Database
Author: Chan Ming Man

This post shows you how to connect to SQL Azure database using VC++ CLR. In previous post https://chanmingman.wordpress.com/2012/01/06/vc-clr-ms-sql-server-access/, the code connect to on-premise database. Here we connect it to SQL Azure database. What you need to do is to get … Continue reading

Published at 25 Jun 2020

Read more...
Chan Ming Man
Update Microsoft Edge in Windows 10 1803
Author: Chan Ming Man

This post shows you how to update Microsoft Edge if you are still having older Windows 10 like 1803. There are many reasons people try not to update Windows 10 to newer version. The key reason is still software compatibilities. … Continue reading

Published at 23 Jun 2020

Read more...
Chan Ming Man
Publish ASP.NET Webform to Azure App Service
Author: Chan Ming Man

This post shows you how to publish an ASP.NET Webform app to Azure App Services. Pre-requisite of this article is you need to know how to create an ASP.NET Webform application. 1. Create an ASP.NET Application using the default ASP.NET … Continue reading

Published at 22 Jun 2020

Read more...
Chan Ming Man
A ‘R’ script error occurred during execution of ‘sp_execute_external_script’ with HRESULT 0x80004004. SQL Server
Author: Chan Ming Man

This post shows you one of the possibilities to fix the above error when you are running R script. Back then I have tested the script runs in SQL Server 2017 when I have posted this https://chanmingman.wordpress.com/2019/03/17/machine-learning-service-in-sql-server-2017/. Somehow I bumped … Continue reading

Published at 20 Jun 2020

Read more...
Chan Ming Man
Azure Virtual Machine Web Server http port 80 Access
Author: Chan Ming Man

This post shows you how to enable web server access through port 80 if you have a Web Server running in a Virtual Machine setup in Azure. It used to only have something called “Firewall” but Azure has changed that. … Continue reading

Published at 20 Jun 2020

Read more...
Chan Ming Man
Quantum computing simulation using Q# with C#
Author: Chan Ming Man

This post shows you a Quantum computing sample that works using Visual Studio 2019 version 16.6.2. First download and install the Microsoft Quantum Development Kit, https://docs.microsoft.com/en-us/quantum/install-guide/standalone#installation, is in preview. Download the code here https://github.com/microsoft/Quantum/tree/master/samples/interoperability/dotnet.. Open dotnet.sln. The solution is actually … Continue reading

Published at 20 Jun 2020

Read more...
Chan Ming Man
SSIS ETL from SQL Azure database to Azure Blob Storage
Author: Chan Ming Man

This post is to show you want to use SSIS with full Azure environment, SQL Azure database and Azure Blob Storage. The pre-requisites to this article are; 1, Visual Studio 2017 and above. 2. You need to be familiar with … Continue reading

Published at 18 Jun 2020

Read more...
Goh Chun Lin
Building COVID-19 Dashboard in Golang with Google BigQuery
Author: Goh Chun Lin

It has been almost half a year since the first case relating to the COVID-19 pandemic in Singapore, the country I am now working at, was confirmed. Two days after the first case was confirmed in Singapore, eight travellers entering Malaysia, my home country, from Singapore were confirmed to be infected as well. Since then, […]

Published at 14 Jun 2020

Read more...
Cheah Eng Soon
Enable Audio in Azure VM
Author: Cheah Eng Soon

1. Go to your local computer, launch the Remote Desktop Connection. (* Not use the default rdp from Azure)2. Select "Show Options"3. Go to "Local Resources".4. Select "Settings" in Remote Audio.5. Configure the Settings as below and click OK. [...]

Published at 12 Jun 2020

Read more...
Goh Chun Lin
Analytical Processing on Transaction Data with Google BigQuery and Data Studio
Author: Goh Chun Lin

Data analysing is not about reporting. While reporting gives data, data analytics gives answers to the whys. Data analytics is the practice of using data and information to make informed decisions. When I was in a startup, I was assigned a task by the CEO to work on analytical processing on transaction data. In the […]

Published at 07 Jun 2020

Read more...
Cheah Eng Soon
4 Steps Integrate Microsoft Graph with Azure Bot Services
Author: Cheah Eng Soon

IMAGE ALT TEXT HERE

Sign Up for M365 Developer Program
https://developer.microsoft.com/en-us/office/dev-program

Setup for Microsoft Graph Postman Collection
https://github.com/microsoftgraph/microsoftgraph-postman-collections

Source Code
https://github.com/cheahengsoon/MicrosoftGraphBotSharePoint

YouTube Channel
https://www.youtube.com/c/engsooncheah

Published at 04 Jun 2020

Read more...
Goh Chun Lin
Automated GUI Testing of UWP Apps Using Appium and Azure DevOps
Author: Goh Chun Lin

There is a popular yet simple checklist on how good a software team is from Joel Spolsky, who has been the CEO of Stack Overflow until last year (2019). The checklist is called the Joel Test. The test has only 12 items but 7 of them are related about DevOps, debugging, and testing. Software testing […]

Published at 25 May 2020

Read more...
Cheah Eng Soon
Automate Your Social Media with Power Automate
Author: Cheah Eng Soon

Prerequites

Steps

  1. Go to Power Automate (https://flow.microsoft.com) and Sign in with your M365 Account.

  2. Search for "Twitter".
    Alt Text

  3. Select Template "RSS Feed news to Twitter".
    Alt Text

  4. Connect your Twitter Account and Click "continue".
    Alt Text

  5. Enter Your RSS Feeds URL.
    For this Demo, I'm using Azure Updates RSS Feed.
    Alt Text
    Alt Text

  6. Select "Primary feed link" from dynamic content and Enter the Hashtag "#PowerPlatformTest". Remember put a spacing after "Feed title".
    Alt Text

7.Click "Save".

8.If any update from Azure updates. Your Social Media Account will auto post the post.
Alt Text

Remember to Subscribe our YouTube Channel
Microsoft User Group Singapore (https://www.youtube.com/channel/UClksqggBISUON-mMsOTVTtQ)

Published at 21 May 2020

Read more...
Goh Chun Lin
Building Driver Tracking System with Eventing in Microsoft Azure
Author: Goh Chun Lin

Recently due to the coronavirus pandemic, ordering food from online platform becomes one of the popular choices here. Drivers will deliver the food to us without us leaving our house to pickup the food from the restaurants. The drivers are all equipped with a smart phone that will send I’m not sure how those online […]

Published at 17 May 2020

Read more...
Cheah Eng Teong
Creating a Release Dashboard
Author: Cheah Eng Teong

Create a Release Dashboard 1. Navigate to Dashboards under Overview and Create a +New Dashboard. Name it Releases. 2. Search the Deployment Status widget and add it to the dashboard 3. Click the configure icon, Set the size 4×3, select PartsUnlimitedE2E build and all the stages of the Linked Release Pipeline and Save the configuration. … Continue reading Creating a Release Dashboard

Published at 09 May 2020

Read more...
Marvin Heng
Exclude localhost from Chrome/Chromium Browsers forced HTTPS redirection
Author: Marvin Heng

Chrome and Chromium browsers such as latest Microsoft Edge (Chromium version) has been consistently redirecting the access to http…

Published at 05 May 2020

Read more...
Cheah Eng Teong
Using Azure Monitor as release gate – Part 2
Author: Cheah Eng Teong

Update and deploy application after adding release gates In this exercise, you will make a small code change in the application and commit to the repository which in-turn triggers build and release. 1.Go to Repos and click Files. Navigate to the path “src/PartsUnlimitedWebsite/Views/Home/Index.cshtml” and modify the content to “30%” form “20%” in line 30. 2. … Continue reading Using Azure Monitor as release gate – Part 2

Published at 02 May 2020

Read more...
Cheah Eng Teong
Using Azure Monitor as release gate – Part 1
Author: Cheah Eng Teong

Setting up the Target Environment You will create two Web Apps in Azure to depict two environments Canary and Production to deploy the application. 1. Go to Azure portal and click on +Create a resource and select Web App. 2. Provide a name for the Web App, create new Resource Group or select existing one form … Continue reading Using Azure Monitor as release gate – Part 1

Published at 01 May 2020

Read more...
Cheah Eng Teong
Technical Question
Author: Cheah Eng Teong

How to Prepare Many candidates just read through problems and solutions. That’s like trying to learn calculus by reading a problem and its answer. You need to practice solving problems. Memorizing solutions won’t help you much. Any problem you might encounter, do the following: 1. Try to solve the problem on your own Push yourself … Continue reading Technical Question

Published at 28 Apr 2020

Read more...
Cheah Eng Teong
The big O notation
Author: Cheah Eng Teong

The complexity of an algorithm The Big O notation is used to classify algorithms according to how their running time or space (e.g. in memory or on disk) requirements grow as the input size grows. It does not depend on implementation details such as programming language, the operating system, the hardware, our programmer skill, and … Continue reading The big O notation

Published at 27 Apr 2020

Read more...
Goh Chun Lin
Pack UWP Class Library with NuGet
Author: Goh Chun Lin

Recently, my team is working on packing our UWP class library as a NuGet package. It turns out that it’s not that straight-forward, because even though there is a documentation from Microsoft, it is for Windows Runtime Component. So, the question on StackOverflow remains unsolved. I thus decided to document down the steps on how […]

Published at 26 Apr 2020

Read more...