SQLYARD

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

Leave a Comment / Articles, Cloud and Azure, High Availability, Performance Tuning /

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

Leave a Comment / Articles, Cloud and Azure, High Availability /

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

Leave a Comment / Articles, Cloud and Azure, High Availability /

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

Leave a Comment / Articles, Cloud and Azure, High Availability /

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 »

Dynamic SQL in SQL Server: sp_executesql, SQL Injection, and What Changed in SQL Server 2025

Leave a Comment / Articles, Performance Tuning /

Dynamic SQL in SQL Server: sp_executesql, SQL Injection, and What Changed in SQL Server 2025 Leave a Comment / Articles, Performance Tuning / By SQLYARD Dynamic SQL in SQL Server: sp_executesql, SQL Injection, and What Changed in SQL Server 2025 By SQLYARD · SQLYARD.com · Updated September 2026 · Estimated read: 14–18 min Applies to:

Dynamic SQL in SQL Server: sp_executesql, SQL Injection, and What Changed in SQL Server 2025 Read More »

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

Leave a Comment / Articles, Cloud and Azure, High Availability /

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

Leave a Comment / Articles, Cloud and Azure, High Availability /

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

Leave a Comment / Cloud and Azure /

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 »

Surrogate Key vs. Natural Key in SQL Server: The Complete Guide

Leave a Comment / Articles, Operations, Performance Tuning /

Surrogate Key vs. Natural Key in SQL Server: The Complete Guide Leave a Comment / Articles, Performance Tuning, Operations / By SQLYARD Surrogate Key vs. Natural Key in SQL Server: The Complete Guide By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 22–26 min SQL Server 2012 and later · IDENTITY_CACHE guidance applies

Surrogate Key vs. Natural Key in SQL Server: The Complete Guide Read More »

Microsoft Copilot Studio for SQL Server DBA Work: The Complete Guide

Leave a Comment / AI for Data, Articles, Operations, Scripts and Tools /

Microsoft Copilot Studio for SQL Server DBA Work: The Complete Guide Leave a Comment / Articles, AI for Data, Operations, Scripts and Tools / By SQLYARD Microsoft Copilot Studio for SQL Server DBA Work: The Complete Guide By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 26–30 min Microsoft Copilot Studio, current as

Microsoft Copilot Studio for SQL Server DBA Work: The Complete Guide Read More »

The Complete PostgreSQL Morning Health Check Guide — From Native Views to a Formatted Report

Leave a Comment / Articles, Operations, Scripts and Tools /

The Complete PostgreSQL Morning Health Check Guide — From Native Views to a Formatted Report Leave a Comment / Articles, Operations, Scripts and Tools / By SQLYARD The Complete PostgreSQL Morning Health Check Guide — From Native Views to a Formatted Report By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 30–35 min

The Complete PostgreSQL Morning Health Check Guide — From Native Views to a Formatted Report Read More »

SQL Server JOINs: The Complete Guide — Syntax, Physical Operators, and a Migration-Safety Workshop

Leave a Comment / Articles, Operations, Performance Tuning /

SQL Server JOINs: The Complete Guide — Syntax, Physical Operators, and a Migration-Safety Workshop Leave a Comment / Articles, Performance Tuning, Operations / By SQLYARD SQL Server JOINs: The Complete Guide — Syntax, Physical Operators, and a Migration-Safety Workshop By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 26–30 min SQL Server 2016

SQL Server JOINs: The Complete Guide — Syntax, Physical Operators, and a Migration-Safety Workshop Read More »

Stale Statistics and Fragmentation Thresholds — A Production Case Study in Query Plan Instability

Leave a Comment / Articles, Operations, Performance Tuning /

Stale Statistics and Fragmentation Thresholds — A Production Case Study in Query Plan Instability Leave a Comment / Articles, Performance Tuning, Operations / By SQLYARD Stale Statistics and Fragmentation Thresholds — A Production Case Study in Query Plan Instability By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 20–24 min SQL Server 2022

Stale Statistics and Fragmentation Thresholds — A Production Case Study in Query Plan Instability Read More »

SSRS Subscriptions and Schedules: The Complete Inventory, Troubleshooting, and Health-Check Workshop

Leave a Comment / Articles, Operations, Scripts and Tools /

SSRS Subscriptions and Schedules: The Complete Inventory, Troubleshooting, and Health-Check Workshop Leave a Comment / Articles, Scripts and Tools, Operations / By SQLYARD SSRS Subscriptions and Schedules: The Complete Inventory, Troubleshooting, and Health-Check Workshop By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 14–18 min SQL Server Reporting Services (Native Mode) · Power

SSRS Subscriptions and Schedules: The Complete Inventory, Troubleshooting, and Health-Check Workshop Read More »

SQL Server Plan Guides: The Last Resort That Works When Nothing Else Can

Leave a Comment / Articles, Performance Tuning /

SQL Server Plan Guides: The Last Resort That Works When Nothing Else Can – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SQL Server Plan Guides: The Last Resort That Works When Nothing Else Can By SQLYARD · SQLYARD.com · Updated July 2026 · Estimated read: 22–28 min SQL Server 2016 and

SQL Server Plan Guides: The Last Resort That Works When Nothing Else Can Read More »

More Memory, Same Bottleneck — A Full-Day SQL Server Case Study on an AWS EC2 Upgrade

Leave a Comment / Articles, Operations, Performance Tuning /

More Memory, Same Bottleneck — A Full-Day SQL Server Case Study on an AWS EC2 Upgrade Leave a Comment / Articles, Performance Tuning, Cloud and Azure / By SQLYARD More Memory, Same Bottleneck — A Full-Day SQL Server Case Study on an AWS EC2 Upgrade By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated

More Memory, Same Bottleneck — A Full-Day SQL Server Case Study on an AWS EC2 Upgrade Read More »

12 Things SQL Server DBAs Need to Know Before Supporting PostgreSQL

Leave a Comment / Articles, Operations /

12 Things SQL Server DBAs Need to Know Before Supporting PostgreSQL – SQLYARD Leave a Comment / Articles, Operations, Data Engineering / By SQLYARD 12 Things SQL Server DBAs Need to Know Before Supporting PostgreSQL By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 20–25 min PostgreSQL 16 and Later · SQL Server

12 Things SQL Server DBAs Need to Know Before Supporting PostgreSQL Read More »

SQL Server Intelligent Query Processing: The Complete Guide to Self-Learning Features in 2022 and 2025

Leave a Comment / Articles, Performance Tuning /

SQL Server Intelligent Query Processing: The Complete Guide to Self-Learning Features in 2022 and 2025 – SQLYARD Leave a Comment / Articles, Performance Tuning / By SQLYARD SQL Server Intelligent Query Processing: The Complete Guide to Self-Learning Features in 2022 and 2025 By SQLYARD · SQLYARD.com · Updated August 2026 · Estimated read: 25–30 min

SQL Server Intelligent Query Processing: The Complete Guide to Self-Learning Features in 2022 and 2025 Read More »

The PostgreSQL Migration Trap: Heaps, 3.22 Billion Forwarded Fetches, and How to Fix It in SQL Server

Leave a Comment / Articles, Operations, Performance Tuning /

The PostgreSQL Migration Trap: Heaps, 3.22 Billion Forwarded Fetches, and How to Fix It in SQL Server – SQLYARD Leave a Comment / Articles, Performance Tuning, Operations / By SQLYARD The PostgreSQL Migration Trap: Heaps, 3.22 Billion Forwarded Fetches, and How to Fix It in SQL Server By SQLYARD · SQLYARD.com · Updated August 2026

The PostgreSQL Migration Trap: Heaps, 3.22 Billion Forwarded Fetches, and How to Fix It in SQL Server Read More »

Databricks vs Microsoft Fabric: The SQL Server DBA Decision Guide

Leave a Comment / Cloud and Azure /

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 »

Contact us
Contact us