Cloud and Azure

Azure SQL, Fabric, Managed Instance, migrations, Arc, hybrid scenarios, Snowflake

Assessing an On-Premises SQL Server Estate for Azure Migration: A Step-by-Step Checklist

Assessing an On-Premises SQL Server Estate for Azure Migration: A Step-by-Step Checklist Leave a Comment / Articles, Operations, Cloud and Azure / By SQLYARD Assessing an On-Premises SQL Server Estate for Azure Migration: A Step-by-Step Checklist By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 18–22 min Applies to: Mixed-hypervisor SQL Server estates, […]

Assessing an On-Premises SQL Server Estate for Azure Migration: A Step-by-Step Checklist Read More »

From PVSCSI to virtio-scsi: The Real Storage Driver Equivalent on Nutanix AHV for SQL Server

From PVSCSI to virtio-scsi: The Real Storage Driver Equivalent on Nutanix AHV for SQL Server Leave a Comment / Articles, Performance Tuning, Operations / By SQLYARD From PVSCSI to virtio-scsi: The Real Storage Driver Equivalent on Nutanix AHV for SQL Server By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 15–19 min Applies

From PVSCSI to virtio-scsi: The Real Storage Driver Equivalent on Nutanix AHV for SQL Server Read More »

VMware to Nutanix: A Beginner’s Terminology Map for SQL Server DBAs

VMware to Nutanix: A Beginner’s Terminology Map for SQL Server DBAs Leave a Comment / Articles, Operations / By SQLYARD VMware to Nutanix: A Beginner’s Terminology Map for SQL Server DBAs By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 15–19 min Applies to: Nutanix AHV, general orientation for VMware-trained administrators The hardest

VMware to Nutanix: A Beginner’s Terminology Map for SQL Server DBAs Read More »

Fabric Mirroring for SQL Server: The On-Premises Path Into the Medallion Model

Fabric Mirroring for SQL Server: The On-Premises Path Into the Medallion Model Leave a Comment / Articles, Data Engineering, Cloud and Azure / By SQLYARD Fabric Mirroring for SQL Server: The On-Premises Path Into the Medallion Model By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 17–21 min Applies to: Microsoft Fabric Mirroring,

Fabric Mirroring for SQL Server: The On-Premises Path Into the Medallion Model Read More »

Nutanix Database Service for SQL Server: What It Automates and Where It Breaks First

Nutanix Database Service for SQL Server: What It Automates and Where It Breaks First Leave a Comment / Articles, Operations / By SQLYARD Nutanix Database Service for SQL Server: What It Automates and Where It Breaks First By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 16–20 min Applies to: Nutanix Database Service

Nutanix Database Service for SQL Server: What It Automates and Where It Breaks First Read More »

Migrating SQL Server from VMware to Nutanix AHV: NUMA, Storage, and the Core-Licensing Trap

Migrating SQL Server from VMware to Nutanix AHV: NUMA, Storage, and the Core-Licensing Trap Leave a Comment / Articles, Operations / By SQLYARD Migrating SQL Server from VMware to Nutanix AHV: NUMA, Storage, and the Core-Licensing Trap By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 16–20 min Applies to: SQL Server on

Migrating SQL Server from VMware to Nutanix AHV: NUMA, Storage, and the Core-Licensing Trap Read More »

Azure HorizonDB Explained: Architecture, Public Preview Limits, and What It Means for SQL Server DBAs

Azure HorizonDB Explained: Architecture, Public Preview Limits, and What It Means for SQL Server DBAs Leave a Comment / Articles, Cloud Data Platforms / By SQLYARD Azure HorizonDB Explained: Architecture, Public Preview Limits, and What It Means for SQL Server DBAs By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 18–22 min Public

Azure HorizonDB Explained: Architecture, Public Preview Limits, and What It Means for SQL Server DBAs Read More »

Databricks vs Microsoft Fabric: The SQL Server DBA Decision Guide

Databricks vs Microsoft Fabric: The SQL Server DBA Decision Guide – SQLYARD Leave a Comment / Articles, Data Engineering, Cloud and Azure / By SQLYARD Databricks vs Microsoft Fabric: The SQL Server DBA Decision Guide By SQLYARD · SQLYARD.com · Updated July 2026 · Estimated read: 22–28 min Microsoft Fabric GA November 2023 · Databricks

Databricks vs Microsoft Fabric: The SQL Server DBA Decision Guide Read More »

SQL Server CPU Pressure on VMware: When Low CPU Ready Means the Problem Is Yours

SQL Server CPU Pressure on VMware: When Low CPU Ready Means the Problem Is Yours – SQLYARD Leave a Comment / Articles, Performance Tuning, Operations / By SQLYARD SQL Server CPU Pressure on VMware: When Low CPU Ready Means the Problem Is Yours By SQLYARD · SQLYARD.com · Updated July 2026 · Estimated read: 20–25

SQL Server CPU Pressure on VMware: When Low CPU Ready Means the Problem Is Yours Read More »

How I Use Kiro to Analyze My SQL Server Morning Health Reports

How I Use Kiro to Analyze My SQL Server Morning Health Reports – SQLYARD Leave a Comment / Articles, Cloud and Azure, Operations / By SQLYARD How I Use Kiro to Analyze My SQL Server Morning Health Reports By SQLYARD · SQLYARD.com · Updated July 2026 · Estimated read: 25–30 min Every DBA has a

How I Use Kiro to Analyze My SQL Server Morning Health Reports Read More »

Microsoft AI-901 Azure AI Fundamentals Study Guide

Microsoft AI-901 Azure AI Fundamentals Study Guide – SQLYARD Leave a Comment / Articles, Certification, Cloud and Azure / By SQLYARD Microsoft AI-901 Azure AI Fundamentals Study Guide By SQLYARD · SQLYARD.com · Updated July 2026 · Estimated read: 20–25 min Exam AI-901 · Updated April 15, 2026 · Microsoft Certified: Azure AI Fundamentals Verified

Microsoft AI-901 Azure AI Fundamentals Study Guide Read More »

Connecting Django to SQL Server: The Official mssql-django Backend Explained

Connecting Django to SQL Server: The Official mssql-django Backend Explained – SQLYARD Leave a Comment / Articles, Cloud and Azure / By SQLYARD Connecting Django to SQL Server: The Official mssql-django Backend Explained By SQLYARD · SQLYARD.com · Updated June 2026 · Estimated read: 16–20 min Django 3.2 through 6.0 · Python 3.8 through 3.14

Connecting Django to SQL Server: The Official mssql-django Backend Explained Read More »

Getting Started with Data Clustering in Microsoft Fabric Data Warehouse

Getting Started with Data Clustering in Microsoft Fabric Data Warehouse – SQLYARD Leave a Comment / Articles, Azure, High Availability / By SQLYARD Getting Started with Data Clustering in Microsoft Fabric Data Warehouse Preview By David Yard · SQLYARD.com · April 2026 · Estimated read: 15–18 min Preview Feature: Data Clustering in Microsoft Fabric Data

Getting Started with Data Clustering in Microsoft Fabric Data Warehouse Read More »

Azure SQL Database Failover Groups with Multiple Secondaries

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 »

Azure SQL Managed Instance Next-Gen: Real IOPS Control at Last

Azure SQL Managed Instance Next-Gen General Purpose: Real IOPS Control at Last – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD Azure SQL Managed Instance Next-Gen General Purpose: Real IOPS Control at Last By David Yard · SQLYARD.com · April 2026 · Estimated read: 15–18 min Table of Contents Introduction What Actually Changed:

Azure SQL Managed Instance Next-Gen: Real IOPS Control at Last Read More »

SQL Server 2025: Cloud and Hybrid Integration with Azure Arc and Microsoft Fabric

SQL Server 2025: Cloud and Hybrid Integration with Azure Arc and Microsoft Fabric – SQLYARD Leave a Comment / Articles, Azure / By SQLYARD SQL Server 2025: Cloud and Hybrid Integration with Azure Arc and Microsoft Fabric By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Table of Contents The Ground-to-Cloud-to-Fabric

SQL Server 2025: Cloud and Hybrid Integration with Azure Arc and Microsoft Fabric Read More »

Part 11 — Data Quality, Testing, Validation, and Observability

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 9 — Designing the Semantic Layer and Metrics Layer

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 »