SQLYARD

Build AI Powered Solutions Using SQL Server 2025 (Step by Step)

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 »

SQL Server 2025: Calling External REST and GraphQL APIs from T-SQL (Part 10)

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 »

Fabric Cost Analysis Explained: Bringing Clarity to Microsoft Fabric Costs

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 »

SQL Server Pricing and Licensing Guide 2026: Editions, Models, and How to Choose

SQL Server Pricing and Licensing Guide 2026: Editions, Models, and How to Choose – SQLYARD Leave a Comment / Articles / By SQLYARD SQL Server Pricing and Licensing Guide 2026: Editions, Models, and How to Choose By David Yard · SQLYARD.com · April 2026 · Estimated read: 15–18 min Table of Contents Pricing Overview SQL

SQL Server Pricing and Licensing Guide 2026: Editions, Models, and How to Choose Read More »

SQL Server 2025 Fundamentals: A Practical Guide from Basics to Advanced

SQL Server 2025 Fundamentals: A Practical Guide from Basics to Advanced – SQLYARD Leave a Comment / Articles, DBA Checklist / By SQLYARD SQL Server 2025 Fundamentals: A Practical Guide from Basics to Advanced By David Yard · SQLYARD.com · April 2026 · Estimated read: 22–28 min Table of Contents What SQL Server 2025 Fundamentals

SQL Server 2025 Fundamentals: A Practical Guide from Basics to Advanced Read More »

SQL Server 2025: REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE() (Part 9)

Introduction SQL Server 2025 continues expanding its native Regular Expression feature set with two of the most powerful text-processing functions in the release: • REGEXP_MATCHES() – returns a table containing all substrings that match a pattern• REGEXP_SPLIT_TO_TABLE() – splits a string into rows using a RegEx delimiter These functions significantly improve how SQL Server handles

SQL Server 2025: REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE() (Part 9) 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 »

SQL Server 2025: REGEXP_INSTR() and REGEXP_COUNT() (Part 8)

Introduction Continuing SQL Server 2025’s expansion of native regular expression support, today we cover two functions that focus on location and frequency: • REGEXP_INSTR() – returns the starting or ending position of a matched substring• REGEXP_COUNT() – returns the number of times a pattern occurs in a string Together, these functions let you analyze text

SQL Server 2025: REGEXP_INSTR() and REGEXP_COUNT() (Part 8) Read More »