Copy data into Azure Synapse Analytics using the COPY command
March 8, 2021In this article, we will learn how to copy data from an external data source using the COPY command into a dedicated SQL pool of Azure Synapse Analytics.
Search Results for: azure
Creating Azure Data Shares for Azure SQL Database
March 4, 2021This article will walk you through the process of creating Azure Data Shares for an Azure SQL Database.
Restore dedicated SQL pools in Azure Synapse Analytics
March 2, 2021This article will walk you through the process of restoring dedicated SQL pools in Azure Synapse Analytics.
Analyze Azure Cosmos DB data using Azure Synapse Analytics
February 24, 2021This article will help you understand how to analyze Azure Cosmos DB data using Azure Synapse Analytics.
Deploy Azure Data Lake Analytics database using the U-SQL scripts
February 23, 2021In this 3rd article of the Azure Data Lake Analytics series, we will explore deploying a database, tables using U-SQL scripts.
Two ways to build SQL Database Projects in Azure Data Studio
February 18, 2021This article talks about the two standard ways of building SQL Database Projects in Azure Data Studio along with the simple steps of implementation.
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 […]
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
Getting started with Azure Synapse Studio
January 19, 2021This article will help you get started with Azure Synapse Studio and its various features.
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.
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.
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.