Azure Synapse Analytics

In this article, learn how to integrate Power BI reports with data from Azure Synapse Analytics in this step-by-step tutorial.

In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs.

Learn about Azure Synapse Analytics serverless SQL pools to replace the interactive SPARK cluster with a lower-cost service to help reduce Azure bill.

This tip will cover two simple examples of copying data from Azure Blob Storage (or any other source) to Snowflake.

This article provides a simple example of how to copy data from Snowflake using the Azure Synapse Analytics pipeline.

Use Azure Synapse Link to replicate tables from Azure SQL Database or SQL Server 2022 to a dedicated SQL Pool in an Azure Synapse Analytics workspace.

In this article, we look at ways to enforce data integrity when working with Delta Lake tables when using Azure Synapse Analytics.

In this tip we explore ways to build reporting based on the Lakehouse data when using Azure Synapse Analytics.

In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.

In this article we discuss ways to handle late-arriving dimensions when working with a Lakehouse and Azure Synapse Analytics.

In this article we cover a common fact processing task which is fact-to-dimension mapping and how this can be done with Azure Synapse Analytics.

Learn how Synapse Analytics and Snowflake handle Delta format files, Machine Learning workloads, table relationships, constraints and more.

Learn about the incremental processing challenges related to fact tables for Azure Synapse Analytics and how to solve.

In this article we discuss the incremental processing challenges related to fact tables for Azure Synapse Analytics and how to solve.

In this article you will learn about various real-time analytics, advanced analytics, and reporting capabilities in Azure Synapse Analytics.

Learn how to web scrape table data from a web page by using Azure Synapse notebooks and Python along with a step by step example.

Learn about security, governance, and CI/CD capabilities of Azure Synapse Analytics to better understand how it fits within your Azure Data Lakehouse.

In this article we discuss time dimensions for data modeling in Azure Synapse Analytics and how to design time dimensions and use flowlets.

Learn about Azure Synapse Analytics workspace offerings like storage, development notebooks, integration capabilities, monitoring and management.

This article looks at building Slowly Changing Dimensions (SCD) logic to build end-to-end Lakehouse solutions based on Azure Synapse Analytics.

In this article we cover how to create surrogate keys in Azure Synapse Analytics to simplify your data warehouse and allow you to track changes easier

In this article we discuss dimensional denormalization when working with Azure Synapse Analytics to reduce joins and improve performance.

Learn how to handle missing data values in your data set and things that can be done with Azure Synapse to generate the missing values.

In this tip we explore another common Lakehouse transformation, data enrichment, when using Azure Synapse Analytics.