This article talks about the two standard ways of building SQL Database Projects in Azure Data Studio along with the simple steps of implementation.
Read more »
Azure
Elastic Jobs in Azure SQL Database
February 18, 2021Introduction
I have dedicated this article to the topic of Elastic Jobs in Azure SQL Database which is in Public Review. This feature allows you to run scheduled tasks in your Azure SQL Databases. This is similar to SQL Server Agent you have in the On-prem SQL Server versions. However, in Elastic Jobs, you can execute the scheduled tasks in multiple Azure SQL Servers and multiple Databases which is an added advantage when considering the features of SQL Server Agent. Further, this execution performs parallelly.
Read more »
Join database tables using U-SQL scripts for Azure Data Lake Analytics
February 17, 2021In this article, we will explore joining database tables using U-SQL scripts for Azure Data Lake Analytics.
Read more »
Azure Data Factory Interview Questions and Answers
February 11, 2021In this article, we will discuss a number of questions about the Azure Data Factory service that you may be asked when applying to an Azure Data Engineer role.
Read more »
Writing U-SQL scripts using Visual Studio for Azure Data Lake Analytics
February 11, 2021In the 2nd article of the series for Azure Data Lake Analytics, we will use Visual Studio for writing U-SQL scripts.
Read more »
Analyzing data hosted in Azure Cosmos DB with Notebooks
February 10, 2021In this article, we will learn how to analyze data hosted in Azure Cosmos DB using Notebooks.
Read more »
Getting started with Azure Cosmos DB Serverless
February 8, 2021In this article, we will learn how to create a serverless instance of Azure Cosmos DB as well as understand its applicability in use-cases.
Read more »
How to migrate to Azure ML: A quick start guide
February 5, 2021This article provides a quick overview of Azure Machine Learning, an end-to-end cloud framework that can help you build, manage and deploy up to thousands of machine learning models. We provide a quick tutorial that shows how to take your existing, pre-trained machine learning models and migrate them into the Azure ML framework.
Read more »
Explore Azure Analysis Services Model and Data
February 4, 2021This article will walk you through how you can deploy a sample model on Azure Analysis Services and you will also learn the way to consume it using different tools.
Read more »
Creating external tables in Azure Synapse Analytics
February 4, 2021In this article, we will learn to create external tables in Azure Synapse Analytics with dedicated SQL pools.
Read more »
Populate Azure Synapse Analytics from Azure SQL databases using SSIS
February 2, 2021In this article, we will learn how to populate data from the Azure SQL database into Azure Synapse Analytics using SQL Server Integration Services (SSIS).
Read more »
Working with Spark pools in Azure Synapse Analytics
January 29, 2021In this article, we will learn how to create a Spark pool in Azure Synapse Analytics and process the data using it.
Read more »
Dedicated SQL pools in Azure Synapse Analytics
January 28, 2021This article helps you create a dedicated SQL pool in Azure Synapse Analytics, which is the first step to set up a data warehousing environment in Synapse.
Read more »
SQL on-demand pools in Azure Synapse Analytics
January 22, 2021This article will show how to work with SQL on-demand pools and understand the fundamentals of working with this pool in Azure Synapse Analytics.
Read more »
How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server
January 20, 2021In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server.
Read more »
Getting started with Azure Synapse Studio
January 19, 2021This article will help you get started with Azure Synapse Studio and its various features.
Read more »
Creating Azure Synapse Analytics Workspaces
January 18, 2021This article will help you understand the process to create an Azure Synapse Analytics workspace and some other features related to it.
Read more »
How to monitor Azure Data Factory
January 15, 2021In the previous articles of this series, we discussed how to perform different types of activities using Azure Data Factory. These tasks include copying data between different data stores, running SSIS packages and transforming data before writing it to a new data store.
Read more »
How to perform Azure SQL database Import/Export operations using PowerShell
January 14, 2021In Azure, the Import/Export operation of the Azure SQL database is a vital part of the database migration methods. It is important to choose the most viable option as per the database migration strategy and business requirements. In addition, the applications that are configured with Azure SQL PaaS databases, the migration specialist could decide and identify several common scenarios where Azure PaaS database are scripted, copied, migrated, moved or backed up.
Read more »
How to access an Azure SQL database from Azure Data Lake Analytics
January 14, 2021In this article, we will see how we can access data from an Azure SQL database from Azure Data Lake Analytics.
Read more »
Getting started with Azure Analysis Services
January 13, 2021This article will describe how to get started with Azure Analysis Services and help you understand the configuration and pricing options to create our first Analysis Services instance.
Read more »
Clustering in Azure Machine Learning
January 13, 2021Introduction
In this article, we will be discussing Clustering in Azure Machine Learning which is another machine learning technique such as Regression analysis, Classification analysis. During this article series, we have discussed the basic cleaning techniques, feature selection techniques and Principal component analysis, Comparing Models and Cross-Validation until today. We will introduce further few techniques that were not discussed before in this article as well. Previously, we have discussed how to perform clustering in SQL Server during the SQL Server Data Mining series.
Read more »
Using Source Control in Azure Data Factory
January 12, 2021In this article, we will show how to use the GIT repository during the pipeline development phase in Azure Data Factory, to save the changes incrementally before publishing it completely to the Data Factory production environment.
Read more »
Processing file sets with U-SQL in Azure Data Lake Analytics
January 11, 2021This article will help you process file sets with U-SQL in Azure Data Lake Analytics.
Read more »
Using Templates in Azure Data Factory
January 8, 2021In the previous articles of this Azure Data Factory series, we showed different scenarios in which we can take advantage of the Azure Data Factory in copying data from variant data stores and optionally transform the data before loading it to the destination datastore. In all examples that are provided in the previous articles, we created a new pipeline from scratch to achieve the required functionality.
Read more »