Azure Synapse Analytics Data Integration and Orchestration
In this tip we are going to build a sample data pipeline and explore Azure Synapse Analytics data integration and orchestration features.
Fikrat Azizov (MCSE Data Platform and MCSE Azure Solutions Architect) has been working with SQL Server since 2002. Fikrat's main passions are SQL Server performance optimization, cloud data technologies and machine learning. Fikrat is currently working as a Solutions Architect at Slalom Canada.
- MSSQLTips Awards: Author of the Year Contender - 2019-2022 | Rising Star (50+ tips ) - 2021
Explore Azure Cosmos Databases with Azure Synapse Analytics
In this article we are going to learn how to use Spark notebooks to explore the data in the Azure Cosmos DB containers.
Spark Data Exploration with Azure Synapse
In this tip we are going to learn how to use Spark notebooks to explore data in SQL and Spark databases as well as in the storage account.
Azure Synapse Analytics for SQL Server Data
In this tip we are going to learn how to explore data in Synapse databases and how to transfer the data between databases and storage, using Azure Synapse Analytics.
Pivot Transformations for Spark Streaming
In this article we look at how we can apply pivot transformations to Spark streaming data frames.
Explore Data Lake Data with Azure Synapse Analytics
In this article we look at how to load data from Azure Data Lake Storage Gen2 and chart the data using Azure Synapse Analytics.
Azure Synapse Analytics Overview
Azure Synapse Analytics is a platform as a service, designed to unite analytics, data integration and visualization experiences for users. This article is an overview of this service.
Create Azure Data Factory inventory using Databricks
Learn how to build a catalog of your different Azure Data Factory objects such as pipelines, activities, datasets and more.
Terminate Long Running Azure Analysis Services Refresh Using Logic App – Part 4
Learn the Logic App steps and JSON code to terminate a long running Azure Analysis Services Refresh.
Automate Azure Analysis Services Model Refreshes – Part 3
Learn how to Automate Azure Analysis Services model refreshes with Logic Apps for large tables, many small tables and for models with complex queries.
Automate Azure Analysis Services Model Refresh with Logic App – Part 2
Learn the step by step process to automate Azure Analysis Services Management Tasks using Logic App including the scripts, parameters, logging, looping and calling stored procedures.
Overview of Azure Analysis Services and Logic App Tasks – Part 1
In this tip we look at how to automate Azure Analysis Services model refresh tasks using Azure Logic App.
Run SSIS Packages with Azure Data Factory in a Cost Effective Way
In this article we look at how to run an on-premises SSIS package using Azure Data Factory.
Azure Data Factory Execute SSIS Package Activity
In this tip we look at how to execute SSIS packages with Azure Data Factory using SSIS Integration Runtime.
Azure Data Factory Get Metadata Example
In this tip we look at how to use the get metadata activity to read metadata about various objects in Azure.
Azure Data Factory Until Activity Example
In this tip we look at how to use an Until activity in an Azure Data Factory pipeline for iterative logic.
Azure Data Factory ForEach Activity Example
In this tip we look at how to use the ForEach activity when there is a need for iterative loops in Azure Data Factory.
Azure Data Factory Filter Activity and Debugging Capabilities
In this article we look at how to use the debugging functions within Azure Data Factory to set breakpoints to help with development as well as how to use the Filter activity within a pipeline.
Azure Data Factory Lookup Activity Example
To continue our series of tips on Azure Data Factory in this tip we look at how to use the lookup activity to ready objects from a database or file system.
Azure Data Factory If Condition Activity
In this tip we look at how to use an If Condition activity in an Azure Data Factory pipeline for conditional logic.
Azure Data Factory Control Flow Activities Overview
In this article we look at the different types of control flow activities that are available in Azure Data Factory as well as look at how to use the Execute Pipeline activity.
Azure Data Factory Pipeline Variables
In this tip we look at how to create variables that can be used in an Azure Data Factory pipeline.
Build Azure Data Factory Pipeline Dependencies
In this tip we look at Azure Data Factory dependencies and how to build a pipeline using different types of dependencies.
Azure Data Factory Stored Procedure Activity Transformation Activities
In this post we will discuss Azure Data Factory transformation related pipeline activities using Stored Procedure activity.