In the 2nd article of the series for Azure Data Lake Analytics, we will use Visual Studio for writing U-SQL scripts.
Read more »SQL Azure
An overview of Azure Data Lake Analytics and U-SQL
February 10, 2021In this article, we explore the Azure Data Lake Analytics and query data using the U-SQL.
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 »SQL Server PolyBase external tables with Azure Blob Storage
January 15, 2021In this article, we will explore SQL Server PolyBase external tables with Azure Blob Storage.
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 »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 »Dependencies in Azure Data Factory
December 30, 2020In the previous articles of this series, we showed how to create Azure Data Factory pipelines that consist of multiple activities to perform different actions, where the activities will be executed sequentially. This means that the next activity will not be executed until the previous activity is executed successfully without any issue.
Read more »Creating database objects in Azure Data Lake Analytics using U-SQL
December 30, 2020This article will help you create database objects in Azure Data Lake Analytics using U-SQL.
Read more »How to Debug a Pipeline in Azure Data Factory
December 30, 2020In the previous article, How to schedule Azure Data Factory pipeline executions using Triggers, we discussed the three main types of the Azure Data Factory triggers, how to configure it then use it to schedule a pipeline.
Read more »Logging messages from Azure Functions to Azure SQL Database
December 25, 2020In this article, I am going to explain how to create a serverless application using Azure Functions and use Azure SQL Database to log messages generated by the function. In this world of cloud-based applications, it is very important that you are aware of how to create and design serverless applications. An important aspect while designing any application is to generate log messages at every key step or operation that is being performed. This helps us to understand the workflow whenever there are some issues and need debugging at some later point in time.
Read more »Creating your first Azure SQL Database
December 23, 2020Introduction
You might be thinking why do you want to create Azure SQL Database and what are the best configurations. This article will provide you with the basic configurations of the Azure SQL Database.
Read more »Building U-SQL jobs locally for Azure Data Lake Analytics
December 23, 2020This article will help you learn to develop U-SQL jobs locally, which once ready, can be deployed on Azure Data Lake Analytics service on the Azure cloud.
Read more »Deploying U-SQL jobs on Azure Data Lake Analytics
December 23, 2020In this article, we will learn how to execute U-SQL jobs that have been developed or tested locally, to the production environment from a local machine.
Read more »How to track data changes on Azure SQL Database
December 21, 2020In this article, we will guide you through tracking data changes on the Azure SQL database and introduce common use case scenarios and learn how to get the most out of system-versioned tables.
Read more »