In this article, we will show how to prepare yourself for one of the important Microsoft Azure exams, DP-200: Implementing an Azure Data Solution certificate exam.
Read more »
Azure
Configuring ODBC drivers for Azure Database for MySQL
September 15, 2020In this article, I am going to show how we can configure the ODBC driver to connect the Azure Database for MySQL Server. Also, I am going to demonstrate the configuration using the SQL Server Integration Services (SSIS) package.
Read more »
How to prepare for the Exam DP-300: Administering Relational Databases on Microsoft Azure
September 14, 2020In this article, we will show how to prepare yourself for the DP-300 exam: Administering Relational Databases on the Microsoft Azure certificate exam.
Read more »
How to prepare for the Exam AZ-900: Microsoft Azure Fundamentals
September 9, 2020In this article, we will show how to prepare yourself for the Microsoft Azure Fundamentals exam (AZ-900).
Read more »
Getting started with Azure SQL Database using Azure CLI
September 9, 2020There are plenty of tools out in the market to manage Azure Cloud platform— Azure Management Web portal, Visual Studio, Visual Studio Code with Azure Studio SDK, Azure PowerShell, Azure CLI, and Azure Cloud Shell.
Read more »
Getting started with Azure Automation
September 1, 2020Microsoft Azure Automation service provides a framework to create and schedule workflows to simplify the repetitive and mundane tasks that Cloud administrators perform with Azure. The workflows are commonly known as run-books.
Read more »
Data Reduction Technique: Principal Component Analysis in Azure Machine Learning
August 31, 2020Introduction
We will be discussing one of the most common Data Reduction Technique named Principal Component Analysis in Azure Machine Learning in this article. After discussing the basic cleaning techniques, feature selection techniques in previous articles, now we will be looking at a data reduction technique in this article.
Read more »
Uploading SQL data into Azure Blob Storage using SSIS
August 20, 2020In this article, we will learn to upload the excel file to Azure blob storage using SQL Server Integration Service Package. The excel file contains the output of a T-SQL query. This article is a small demonstration that gives some idea about the Azure Blob Upload task and how it can be used to upload files using SSIS.
Read more »
Data Engineer Interview Questions and Answers: SQL Workload Migration to Microsoft Azure Database Platforms
August 13, 2020In this article, we will discuss a number of questions that you may face when being interviewed to a Microsoft Azure Data Engineer position. These questions will focus on the process of migrating the SQL Server databases from the on-premises instances to the Microsoft Azure database services.
Read more »
Export data from MySQL tables to Azure SQL database
August 12, 2020In this article, I am going to explain how we can export the data of the on-premise MySQL database to Azure SQL database. This task can be performed in two phases.
Read more »
Backup SQL databases to Azure using the database maintenance plan
August 6, 2020In this article, we are going to learn how we can back up the SQL database to Azure using a database maintenance plan. To demonstrate the process, I have restored the AdventureWorks2017 database on my workstation. I have created an Azure container named sqlbackups in my storage account.
Read more »
Migrating SQL workloads to Microsoft Azure: Databases trip to Azure SQL Database Managed Instance
August 5, 2020In the previous two trips of this articles series, databases trip to SQL Server on Azure VM and to Azure SQL Database, we discussed the benefits of migrating your on-premises SQL Server databases to the Microsoft Azure database platforms and the methods that can be followed to migrate the on-premises databases to the Azure database platforms.
Read more »
Migrating SQL workloads to Microsoft Azure: Databases Trip to Azure SQL Database
August 3, 2020In the previous article of this series, Migrate SQL workloads to Microsoft Azure: Databases trip to SQL Server on Azure VM, we went through the methods that can be used for assessing your on-premises SQL Server databases before the migration process then migrating it to a SQL Server instance hosted in a Microsoft Azure VM.
Read more »
Migrating SQL workloads to Microsoft Azure: Databases Trip to SQL Server on Azure VM
July 31, 2020In 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 »
Migrating SQL workloads to Microsoft Azure: Assessment and Migration Tools
July 31, 2020In 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 »
Migrating SQL workloads to Microsoft Azure: Guidance and Assessment Tools
July 30, 2020In 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 »
Getting started with Azure SQL Analytics
July 29, 2020Using Azure SQL Analytics, you will rediscover the new ways to manage the Azure SQL Database. Microsoft is driving an intelligent platform to provide seamless collaboration for all their end users to business analysts, by building an effective Log Analytics stack and intelligent insight through dashboards.
Read more »
Migrating SQL workloads to Microsoft Azure: Services Selection
July 28, 2020In 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 »
Migrating SQL workloads to Microsoft Azure: Planning the jump
July 27, 2020In this article, we will discuss several points that should be considered when planning to migrate the on-premises SQL workload to Microsoft Azure cloud services. This article is the first step in a series of articles that discuss how to perform the SQL and No-SQL workload migration smoothly to the cloud.
Read more »
Prediction in Azure Machine Learning
July 16, 2020Introduction
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 »
Automating Azure SQL Database index maintenance using Elastic Job Agents
July 14, 2020In this article, I am going to explain how we can automate the index and statistics maintenance of Azure SQL Database using an Elastic Job Agent.
Read more »
Deploy Python apps to Azure Functions using Visual Studio Code
July 10, 2020In 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 »
Data Cleansing in Azure Machine Learning
July 2, 2020Introduction
After discussing the basic features of Azure Machine Learning in my previous article, Introduction to Azure Machine Learning using Azure ML Studio, we will look at techniques of data cleansing in Azure Machine Learning. Data Cleansing or Data Cleaning is an important aspect when it comes to predicting as quality data will improve the quality of data prediction.
Read more »
Migrate an on-premises SQL Server database to an Azure SQL database
June 30, 2020In this article, we will discuss and understand a method to migrate an on-premises SQL Server database to the Azure SQL database.
Read more »
Getting started with Azure Function Apps
June 25, 2020In 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 »