Title Category Date
Enforce Data Integrity with Delta Lake Tables using Azure Synapse Azure Synapse Analytics2022-12-08
Delta Lakes Time Travel Functionality for ETL logging Azure Synapse Analytics2022-06-10
Azure Synapse Analytics Fact to Dimension Mapping Azure Synapse Analytics2022-05-19
Incremental Ingestion for Large Fact Tables on Lakehouse Azure Synapse Analytics2022-04-21
Incremental Processing for Fact Tables with Azure Synapse Analytics Azure Synapse Analytics2022-04-15
Slowly Changing Dimensions on Lakehouse with Synapse Mapping Data Flow Azure Synapse Analytics2022-02-18
Create Surrogate Keys in Azure Synapse Analytics for Data Warehousing Azure Synapse Analytics2022-02-01
Data Deduplication for Azure Synapse Analytics with Mapping Data Flows Azure Synapse Analytics2021-12-06
Data Ingestion into Delta Lake Bronze tables using Azure Synapse Azure Synapse Analytics2021-11-26
Data Warehouse Development Challenges Uncovered Data Warehousing2021-10-20
Scalable Lakehouse Solutions for Azure Synapse Analytics Azure Synapse Analytics2021-10-08
Process Real Time Data Streams with Azure Synapse Analytics Azure Synapse Analytics2021-03-02
Analyze data skew issues with Azure Synapse Analytics Azure Synapse Analytics2021-02-17
Azure Synapse Analytics vs Azure Data Factory for Building a Pipeline Azure Synapse Analytics2021-01-27
Azure Synapse Analytics Data Integration and Orchestration Azure Synapse Analytics2020-12-18
Spark Data Exploration with Azure Synapse Azure Synapse Analytics2020-11-11
Pivot Transformations for Spark Streaming Azure2020-10-05
Explore Data Lake Data with Azure Synapse Analytics Azure Synapse Analytics2020-09-18
Azure Synapse Analytics Overview Azure Synapse Analytics2020-09-08
Create Azure Data Factory inventory using Databricks Azure Data Factory2020-07-31
Terminate Long Running Azure Analysis Services Refresh Using Logic App – Part 4 Azure2020-07-02
Automate Azure Analysis Services Model Refreshes – Part 3 Azure2020-06-12
Automate Azure Analysis Services Model Refresh with Logic App – Part 2 Azure2020-06-02
Overview of Azure Analysis Services and Logic App Tasks – Part 1 Azure2020-05-13
Run SSIS Packages with Azure Data Factory in a Cost Effective Way Azure Data Factory2019-12-06
Azure Data Factory Execute SSIS Package Activity Azure Data Factory2019-11-29
Azure Data Factory Get Metadata Example Azure Data Factory2019-11-28
Azure Data Factory Until Activity Example Azure Data Factory2019-10-24
Azure Data Factory ForEach Activity Example Azure Data Factory2019-10-16
Azure Data Factory Filter Activity and Debugging Capabilities Azure Data Factory2019-09-27
Azure Data Factory Lookup Activity Example Azure Data Factory2019-09-25
Azure Data Factory If Condition Activity Azure Data Factory2019-08-28
Azure Data Factory Control Flow Activities Overview Azure Data Factory2019-08-20
Azure Data Factory Pipeline Variables Azure Data Factory2019-08-14
Build Azure Data Factory Pipeline Dependencies Azure Data Factory2019-07-29
Azure Data Factory Stored Procedure Activity Transformation Activities Azure Data Factory2019-07-12
Create Event Based Trigger in Azure Data Factory Azure Data Factory2019-07-01
Create Schedule Trigger in Azure Data Factory ADF Azure Data Factory2019-06-20
Create Tumbling Window Trigger in Azure Data Factory ADF Azure Data Factory2019-06-11
Transfer On-Premises Files to Azure SQL Database Azure Data Factory2019-05-29
Transfer On-Premises Files to Azure Blob Storage Azure Data Factory2019-05-21
Transfer Data to the Cloud Using Azure Data Factory Azure Data Factory2019-03-08
Create Azure Data Factory Pipeline Azure Data Factory2019-02-22
Azure Data Factory Overview Azure Data Factory2019-02-05
Diagnose and Fix SSIS Performance Problems for ETL Loads Integration Services Data Flow Transformations2019-01-16
Cross-database query performance in Azure SQL Database Azure SQL Database2018-04-25
Identify the best tables for SQL Server 2016 Columnstore Index Migration SQL Server 20162016-08-05
How to Identify Useful SQL Server Table Statistics Maintenance2016-05-18
Creating a Centralized Performance Collection Solution for SQL Server Performance Tuning2016-05-04
SQL Server Columnstore, B-Tree and Hybrid Index Performance Comparison for Data Warehouses Indexing2016-02-08
How to find UDFs causing SQL Server performance issues Functions User Defined UDF2015-12-07
SQL Server Monitoring with Powershell and the SQL Server Platform: Data Processing (Part 2 of 3) Monitoring2015-05-21
SQL Server Monitoring with Powershell and the SQL Server Platform: Data Collection (Part 1 of 3) Monitoring2015-05-14
SQL Server Covering Index Performance Indexing2015-02-20