Azure SQL Database Failover Groups with Multiple Secondaries: What’s New and How to Use It – SQLYARD Leave a Comment / Articles, Azure, High Availability / By SQLYARD Azure SQL Database Failover Groups with Multiple Secondaries Public Preview By David Yard · SQLYARD.com · April 2026 · Estimated read: 18–22 min What’s New, Why It […]
Azure SQL Database Failover Groups with Multiple Secondaries Read More »
Summary for Parts 0 through 11 Modern analytics platforms are no longer simple data warehouses with nightly ETL jobs. Enterprises today operate hybrid ecosystems of structured warehouse data, raw event streams, machine learning pipelines, operational analytics, and AI-driven automation. This requires a unified architectural approach capable of handling scale, governance, performance, flexibility, and reliability. This
This Completes the Guide to Building Modern Data Warehouses and Lakehouses Read More »
Part 11 — Data Quality, Testing, Validation, and Observability – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series — Building a Modern Data Warehouse and Lakehouse Part 11 — Data Quality, Testing, Validation, and Observability By SQLYARD · SQLYARD.com · April 2026 · Estimated read: 30–35 min Part
Part 11 — Data Quality, Testing, Validation, and Observability Read More »
Part 10 — Orchestration and Automation – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series — Building a Modern Data Warehouse and Lakehouse Part 10 — Orchestration and Automation By SQLYARD · SQLYARD.com · April 2026 · Estimated read: 30–35 min Part 10 of 14 — Deep Technical
Part 10 — Orchestration and Automation Read More »
Part 9 — Designing the Semantic Layer and Metrics Layer – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series — Building a Modern Data Warehouse and Lakehouse Part 9 — Designing the Semantic Layer and Metrics Layer By SQLYARD · SQLYARD.com · April 2026 · Estimated read: 30–35
Part 9 — Designing the Semantic Layer and Metrics Layer Read More »
Part 8 — Implementing the Lakehouse: Fabric, Databricks, and AWS – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series — Building a Modern Data Warehouse and Lakehouse Part 8 — Implementing the Lakehouse: Fabric, Databricks, and AWS By SQLYARD · SQLYARD.com · April 2026 · Estimated read: 35–40
Part 8 — Implementing the Lakehouse: Fabric, Databricks, and AWS Read More »
A Complete Guide from Novice to Expert SQL Server’s In-Memory OLTP engine (also called “Hekaton”) is one of the most powerful performance features in the platform. It allows you to create memory-optimized tables, natively compiled stored procedures, and high-throughput transactional workloads. This guide explains what in-memory tables are, when to use them, how to set
In-Memory OLTP (Memory-Optimized Tables) in SQL Server Read More »
Part 5 — Transformations Part 1: ELT Strategy, dbt Modeling, and SQL Pipelines – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series — Building a Modern Data Warehouse and Lakehouse Part 5 — Transformations Part 1: ELT Strategy, dbt Modeling, and SQL Pipelines By SQLYARD · SQLYARD.com ·
Part 5 — Transformations Part 1: ELT Strategy, dbt Modeling, and SQL Pipelines. Read More »
Part 4 — Ingesting Data: Fivetran, Airbyte, Snowpipe, Autoloader, Glue, ADF, and CDC – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series — Building a Modern Data Warehouse and Lakehouse Part 4 — Ingesting Data: Fivetran, Airbyte, Snowpipe, Autoloader, Glue, ADF, and CDC By SQLYARD · SQLYARD.com ·
Part 4 — Ingesting Data: Fivetran, Airbyte, Snowpipe, Autoloader, Glue, ADF, and CDC Read More »
Part 3 — Building the Data Lake: Bronze, Silver, and Gold Architecture – SQLYARD Leave a Comment / Articles, Data Engineering, Scripts / By SQLYARD Deep Technical Series — Building a Modern Data Warehouse and Lakehouse Part 3 — Building the Data Lake: Bronze, Silver, and Gold Architecture By SQLYARD · SQLYARD.com · April 2026
Part 3 — Building the Data Lake: Bronze, Silver, and Gold Architecture Read More »
