Azure

Ahmad Yaseen
Create SQL Virtual Machine

Migrating SQL workloads to Microsoft Azure: Databases Trip to SQL Server on Azure VM

July 31, 2020 by

In the previous articles of this series, we built the bridge that leads us to the best way of migrating our SQL workload to Microsoft Azure, by showing how to create the databases migration strategy that contains a deep study of the current environment and the available options in Azure to replace the on-premises setup, which we tried to make it easier by providing all Azure database services and the workload that fits each service, and finally, we introduced several Microsoft tools and services that can be used to assess the current setup, provide migration guidance steps and migrate the databases to Microsoft Azure services with the minimal downtime.

Read more »
Ahmad Yaseen
Assess and Migrate Databases

Migrating SQL workloads to Microsoft Azure: Assessment and Migration Tools

July 31, 2020 by

In the previous articles of this series we discussed how to draw the initial strategy when planning to migrate the SQL workload to Microsoft Azure, the different database target platforms provided by Microsoft Azure that can be used as a migration target, based on the workload type, and finally, we went through some tools that help in discovering and assessing the on-premises environment by identifying the migration blocking issues and providing guidance steps for the migration process.

Read more »
Ahmad Yaseen
Migrate a SQL database

Migrating SQL workloads to Microsoft Azure: Guidance and Assessment Tools

July 30, 2020 by

In the previous articles, Migrating SQL workloads to Microsoft Azure: Planning the jump and Migrating SQL workloads to Microsoft Azure: Services Selection, we discussed the steps that you should follow when you start thinking loudly that you need to migrate your SQL workload to Azure, by checking your on-prem site and the available services and features in Azure that meet your workload handling requirements. After that, we went through different database services provided by Azure and which one fits a specific workload, in order to make it easy for you to translate the current workload as an Azure service.

Read more »
Ahmad Yaseen
Azure SQL Database

Migrating SQL workloads to Microsoft Azure: Services Selection

July 28, 2020 by

In the previous article, Migrating SQL workloads to Microsoft Azure: Planning the jump, we discussed the main points that should be checked and considered while drawing your plan to migrate the SQL workload from the on-premises datacenters to Microsoft Azure. In this article, we will go through the different database services that are provided by Microsoft Azure to help you in selecting the proper service that can serve your SQL workload when migrating it to Microsoft Azure.

Read more »
Dinesh Asanka
After publishing the model.

Prediction in Azure Machine Learning

July 16, 2020 by

Introduction

After discussing the basic features of azure machine learning and how to clean the data from Azure Machine learning, let us look at how to perform prediction in Azure Machine Learning. Prediction is one of the important aspects of machine learning as it will help to make strategic decisions.

Read more »
Aveek Das
Deploy to Azure

Deploy Python apps to Azure Functions using Visual Studio Code

July 10, 2020 by

In this article, we are going to build a small python application and deploy it to Azure Functions. The development and the deployment will be done using the Visual Studio (VS) Code. As you might be aware, VS Code is one of the most widely used and preferred code editors for programmers. It is a cross-platform tool, which means you can install this tool on any operating system of your choice, starting from Windows, Linux, or Mac OS.

Read more »
Aveek Das
Function URL up and running

Getting started with Azure Function Apps

June 25, 2020 by

In this article, I am going to explain how to get started with Azure Function Apps. In my previous article, An introduction to Serverless Applications, I have mentioned the serverless architecture and the various cloud offerings to develop serverless applications. As we know, in serverless architecture, the users only write the business logic code, and all other worries are taken care of by the cloud provider. This helps businesses to quickly implement solutions and ship it to customers with more quality. Also, another important point about serverless applications is that they are scalable on-demand, which means as a developer, we no longer need to monitor or manually pull up the resources when the executions are more.

Read more »
Aveek Das
AWS Lambda – Serverless Applications

An introduction to Serverless Applications

June 25, 2020 by

In this article, I am going to describe what are serverless applications and how are these developed. I will also introduce the concepts of serverless computing and how to deploy one using Azure Functions. This article is targeted towards most of the data professionals who want to gain some basic knowledge of serverless applications and the underlying architecture and cloud computing. In recent times, cloud computing has become one of the most important domains for many big organizations and it has thus become essential for all to have some basic information on the same.

Read more »
Dinesh Asanka
Experiement configuration is Azure ML Studio.

Introduction to Azure Machine Learning using Azure ML Studio

June 18, 2020 by

Introduction

Let us see how Azure ML studio can be used to create machine learning models and how to consume them in this series. As we discussed during the data mining series, we identified the challenges in the predictions in data. In the Azure Machine learning platform, machine learning workflows can be defined in easy scale models in the cloud environment. Today will be looking at how datasets can be uploaded.

Read more »
Aveek Das
SQL Database created

Working with Azure SQL databases using Azure CLI 2.0

May 22, 2020 by

In my previous article, Getting started with Azure CLI 2.0, I have explained how to get started with the Azure CLI 2.0. I have also explained how to install it on a local machine and demonstrated a few commands. In this article, I’m going to explain how to create a SQL Database using Azure CLI 2.0. Further, in the later part of the article, I’ll also show how to create a backup of the SQL Database using Azure CLI. Creating a SQL Database using the Azure CLI helps us to get things automated and removes the error-prone manual creation of the databases and backups.

Read more »
Aveek Das
Azure Cloud Shell

Getting started with Azure CLI 2.0

May 12, 2020 by

In this article, we are going to understand what Azure CLI is and how to work with it. For the purpose of this article, we will take the version 2.0 to demonstrate the features and functionalities. The Azure CLI, as the name suggests is a cross- platform and open-source command-line tool that we can use to create or manage resources in the Azure Portal. This tool gives us the ability to issue commands right from the windows command prompt and deal with the Azure resources. Since this tool is a cross-platform, that means the users can easily install the utility on Windows, Linux or Mac OS and still work with the same set of commands without making any changes.

Read more »
Nisarg Upadhyay
List of all database services provided by Azure

Deploying Azure Databases for MySQL server using Azure Portal

April 24, 2020 by

In this article, I am going to explain the step by step process to create an Azure Database for MySQL Server. Azure Database for MySQL is a fully-managed database as a service that uses MySQL community edition. It can manage the mission-critical workload with dynamic scalability. We can use it to develop various applications that leverage open-source tools and cross-platform applications. Let me explain these steps of a deployment process of MySQL Server on Azure.

Read more »
Nisarg Upadhyay
Data loaded in the Power Query editor

How to access data from Azure Blob Storage using Power BI

March 17, 2020 by

In this article, I am going to explain how we can access the data from the Azure Blob Storage using Power BI. To do that, we are going to use the below tools:

  1. Azure BLOB Storage account: We have uploaded the source CSV file to it
  2. Power Query editor: To choose the data that we want to load in the Power BI report
  3. Power BI Desktop: To view the data imported from the CSV file
Read more »