Goh Chun Lin
Building a Healthcare Dashboard with FAST Framework and Azure API for FHIR
Author: Goh Chun Lin

In our previous article, we have successfully imported realistic but not real patient data into the database in our Azure API for FHIR. Hence, the next step we would like to go through in this article is how to write a user-friendly dashboard to show those healthcare data. For frontend, there are currently many open-source […]

Published at 12 Jul 2020

Read more...
Chan Ming Man
Add Web API controller to Blazor project ASP.NET
Author: Chan Ming Man

In article shows you how to add a Web Api controller to Blazor project. This is not like the good old day that you insert a page then put a /page then you will reach that page. They are few … Continue reading

Published at 12 Jul 2020

Read more...
Chan Ming Man
The item is already under source control at selected location Visual Studio 2019
Author: Chan Ming Man

This article shows you how to resolve the error “The item is already under source control at selected location” when you are adding the source code to Visual Studio 2019. The message is like the one below. Go to File … Continue reading

Published at 11 Jul 2020

Read more...
Chan Ming Man
Stop Azure Data Factory SSIS Integration Runtime
Author: Chan Ming Man

This short post shows you how to stop the Azure Data Factory SSIS Integration Runtime. Why you need to do that? It will be very costly if you let it running. When you go into Azure Data Factory. Click on … Continue reading

Published at 08 Jul 2020

Read more...
Goh Chun Lin
Authentication of Azure API for FHIR® and the Import of Patient Info with Azure Function
Author: Goh Chun Lin

In the previous article, we talked about how to generate realistic but not real patient data using Synthea(TM) and then also how to store them securely in Azure Storage. Setup Azure API for FHIR® Today, we will continue the journey. The first step we need to do is to setup the Azure API for FHIR®. […]

Published at 06 Jul 2020

Read more...
Chan Ming Man
CTO July 2020 articles and resources
Author: Chan Ming Man

These are the good reads found in this month. SECRET WEAPON IN YOUR ENTREPRENEURIAL SUCCESS: SOLUTION ARCHITECT In a nutshell, you could summarize the roles of a solution architect as follows: Analyzing the tech space for appropriate solutions. Harmonizing tech … Continue reading

Published at 05 Jul 2020

Read more...
Chan Ming Man
Azure SQL Server database to Json
Author: Chan Ming Man

This blog post shows you how to retrieve the data from SQL Azure database using Entity Framework and serialize it to Json string. The pre-requisite for this article; 1. You need to know Entity Framework, 2. You have an Azure … Continue reading

Published at 03 Jul 2020

Read more...
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...
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...