Objectives: To migrate data from an On-premises SQL Sever to Azure SQL Database. To show a quick and summarized walk through and practical insights of this specific process. Background: I have a .NET Web app using the sample Adventure Works database all running in an on-premises dev server. Steps: Install the Data Migration Assistant Tool …
Continue reading Walk-through of Data Migration Assistant with Azure SQL DB
Azure Analysis Services is essentially Analysis Services from SQL Server served as a platform-as-a-service in the Microsoft Azure cloud. The following are the steps I have taken to build, deploy and use Analysis Services for business intelligence. To get a complete overview and see more comprehensive steps, read What is Azure Analysis Services? In the …
In the recent months, the hype around Machine Learning has caught my attention. Therefore, I spent reading articles and watching videos and university lectures on the topic. Wearing the developer hat, I wondered how a developer can build a machine learning solution in Azure. This blog post hopes to share how I built a machine …
Continue reading A Basic Demo of an Azure Machine Learning Experiment
In my previous blog post, Power BI Embedded Walk Through Part 1 of 3 I have shown how to create a Power BI Embedded workspace collection in the Azure Portal as one of the first major steps. In this post, I will show how to get your Power BI report into the Azure Power BI …
Power BI Embedded is an interesting approach to allow web applications to embed Power BI reports such that users of the application do not require any Office 365 account and user license. In trying to figure out how to do a simple demo for myself, I found the documentation to be fragmented. I will provide a …
In continuation from my blog article Building a Spark Application for HDInsight using IntelliJ Part 1 of 2 which outlines my experience in installing IntelliJ, other dependent SDKs and creating an HDInsight project. To add some code, right click src, create Scala Class Project folders and MainApp Scala code: Logic Read from csv file in …
Continue reading Building a Spark Application for HDInsight using IntelliJ Part 2 of 2
For developers with a Microsoft .NET background who want to get familiar with building Spark applications with Scala programming language, this blog post series is a walk through from installing the development tools and building a simple Spark application, then submit against an HDInsight Spark cluster. My HDInsight configuration is Spark 2.0 (HDI 3.5) with …
Continue reading Building a Spark Application for HDInsight using IntelliJ Part 1 of 2
With Power BI Desktop you can use the Azure HDInsight Spark BI Connector to get data from the Spark cluster to build reports. I have an HDInsight Spark 2.0 cluster with Azure Data Lake Store as the primary storage. Open Power BI Desktop Click Get Data Enter url of your HDInsight Spark cluster. Enter the …
Continue reading Build Power BI Reports with HDInsight Spark Connector
Upon creating an HDInsight cluster for big data analytics development, the costs can be quite high at around $4 an hour. This adds up, especially when running idle most of the time. To save on the costs, I delete the cluster and re-create when needed. For simple development purposes, my HDInsight depends on Azure Data …
Part 1 of 2: Text Analytics of Movie Reviews using Azure Data Lake, Cognitive Services and Power BI (part 1 of 2) Take a csv file, analyze with an U-SQL script in Azure Data Lake Part 2 of 2: Applicable Business Scenario Marketing or data analysts who need to review sentiments and key phrases of a […]
Roy Kim on Azure and Microsoft 365 