This article will discuss one of the powerful analytics services in Azure – Azure Synapse Analytics, along with its components, features, security, and more.
Read more »
Azure
How to clone an Azure SQL Database
October 12, 2020In this article, we will learn cloning an Azure SQL Database.
Read more »
Create a Serverless Azure SQL Database
October 6, 2020In this article, we will take a look at how to create a serverless Azure SQL database.
Read more »
Prediction with Regression in Azure Machine Learning
October 6, 2020Introduction
We will be discussing one of the most common prediction technique that is Regression in Azure Machine Learning in this article. After discussing the basic cleaning techniques, feature selection techniques and principal component analysis in previous articles, now we will be looking at a data regression technique in azure machine learning in this article.
Read more »
Create an Azure SQL Database with built-in sample data
September 30, 2020In this article, we will learn to create an Azure SQL Database with built-in sample data.
Read more »
Four different methods to copy your Azure SQL database
September 30, 2020In this article, we will see different methods to copy the Azure SQL database. With the advent of all the business dynamics available in today’s IT industry, there is a huge paradigm shift towards automation. You need to constantly innovate and keep moving forward.
Read more »
How to prepare for the Exam AZ-104: Microsoft Azure Administrator
September 28, 2020In this article, we will discuss how to prepare yourself for the Microsoft Azure Administrator certification exam.
Read more »
How to prepare for the Exam DP-201: Designing an Azure Data Solution
September 21, 2020In this article, we will discuss how to prepare yourself for an important Microsoft Azure exam: Designing an Azure Data Solution (DP-201).
Read more »
How to prepare for the Exam DP-200: Implementing an Azure Data Solution
September 16, 2020In 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 »
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 »