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 »
Exporting Data from SQL Server the Right Way: Agent, PowerShell, BCP, and SSIS Explained – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD Exporting Data from SQL Server the Right Way By David Yard · SQLYARD.com · April 2026 · Estimated read: 18–22 min Agent, CmdExec, PowerShell, BCP, and SSIS Explained with Real-World
Exporting Data from SQL Server the Right Way Read More »
SSIS Execution Best Practices: File System vs SSISDB Catalog with Complete Workshop – SQLYARD Leave a Comment / Articles, Scripts / By SQLYARD SSIS Execution Best Practices: File System vs SSISDB Catalog with Complete Workshop By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Compatibility: SSISDB (the SSIS Catalog) has been
SSIS Execution Best Practices: File System vs SSISDB Catalog with Complete Workshop Read More »
A Practical Guide to the Model Context Protocol and Data API Builder Artificial intelligence agents are changing how we access and manipulate data. Instead of writing queries and building custom APIs, AI can now interact with databases through a standard protocol that’s both safe and production ready. At the heart of this shift is the
Unlocking Database Intelligence with SQL MCP Server Read More »
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 »
From Novice to Confident Builder This guide is designed as a skill journey, not just a tutorial. Most SQL articles teach you a few queries and stop. Real data warehouses are built in layers, over time, with increasing discipline and maturity. This guide walks you through that exact path. You will start as a beginner,
A Modern SQL Server Data Warehouse Toolkit Read More »
A practical guide to data virtualization in SQL Server from novice to expert Introduction In 2025, a lot of organizations are still running SQL Server on-prem. Some by choice. Some by regulation. Some because moving 50 TB of data is not a weekend project. The good news is this. You do not need to move
PolyBase in 2025: On-Prem First, Cloud When You Need It Read More »
SQL Server 2025 makes “AI next to the data” practical by adding native vector storage, vector indexing and search, and first class hooks to embedding endpoints like Azure OpenAI through CREATE EXTERNAL MODEL. This lets you build semantic search and Retrieval Augmented Generation (RAG) without standing up a separate vector database. [1] [2] Below is
Build AI Powered Solutions Using SQL Server 2025 (Step by Step) Read More »
Introduction SQL Server 2025 introduces one of the most forward-looking features in its history: the ability to call external REST and GraphQL endpoints directly from T-SQL using the new stored procedure: This fundamentally expands SQL Server from a relational engine into a hybrid data-integration platform capable of: • Calling REST and GraphQL APIs• Triggering Azure
SQL Server 2025: Calling External REST and GraphQL APIs from T-SQL (Part 10) Read More »
If you have spent any time trying to explain Microsoft Fabric costs to leadership, you already know the pain. On paper, Fabric looks simple. You buy capacity. You run workloads. You pay a predictable price. In reality, it rarely stays that clean. Capacities get paused and resumed. SKUs are scaled up for peak workloads. Reservations
Fabric Cost Analysis Explained: Bringing Clarity to Microsoft Fabric Costs Read More »
