RAG, MCP, embeddings, vector search, Foundry, AI agents, schema quality for AI
Microsoft Foundry for SQL Server Professionals: Hub, Projects, Connections, and the DBA’s Role – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD Microsoft Foundry for SQL Server Professionals: Hub, Projects, Connections, and the DBA’s Role By SQLYARD · SQLYARD.com · June 2026 · Estimated read: 25–30 min Microsoft Foundry is showing […]
Your Data Is Your AI Engineer: Why Schema Quality Determines AI ROI for SQL Server Teams – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD Your Data Is Your AI Engineer: Why Schema Quality Determines AI ROI for SQL Server Teams By SQLYARD · SQLYARD.com · June 2026 · Estimated read:
Your Data Is Your AI Engineer: Why Schema Quality Determines AI ROI for SQL Server Teams Read More »
LLM, RAG, AI Agents, and MCP: The Plain English Guide for SQL Server Professionals – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD LLM, RAG, AI Agents, and MCP: The Plain English Guide for SQL Server Professionals By SQLYARD · SQLYARD.com · June 2026 · Estimated read: 15–18 min Four terms
LLM, RAG, AI Agents, and MCP: The Plain English Guide for SQL Server Professionals Read More »
Your Column Names Now Determine How Smart Your AI Is: Metadata Quality in the AI Era – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD Your Column Names Now Determine How Smart Your AI Is: Metadata Quality in the AI Era By SQLYARD · SQLYARD.com · May 2026 · Estimated read:
Your Column Names Now Determine How Smart Your AI Is: Metadata Quality in the AI Era Read More »
How AI Connects to Your Company Data: LLM, MCP, SQL Server, and the Knowledge Base Explained – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD How AI Connects to Your Company Data: LLM, MCP, SQL Server, and the Knowledge Base Explained By SQLYARD · SQLYARD.com · May 2026 · Estimated read:
From Rows to Reasoning: Designing SQL Server Databases for AI Apps and Agents – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD From Rows to Reasoning: Designing SQL Server Databases for AI Apps and Agents By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 35–40 min The way applications consume
From Rows to Reasoning: Designing SQL Server Databases for AI Apps and Agents Read More »
MCP and SQL Server: What Every DBA Needs to Know About the Protocol Connecting AI to Your Database – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD MCP and SQL Server: What Every DBA Needs to Know About the Protocol Connecting AI to Your Database By SQLYARD · SQLYARD.com · May
AI Strategy Curriculum for Senior DBAs and Data Architects – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD AI Strategy Curriculum for Senior DBAs and Data Architects By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 10–12 min Most AI strategy content is written for C-suite generalists who have never
AI Strategy Curriculum for Senior DBAs and Data Architects Read More »
What Every Senior DBA Needs to Know About LLMs, RAG, Agents, and MCP in 2026 – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD What Every Senior DBA Needs to Know About LLMs, RAG, Agents, and MCP in 2026 By SQLYARD · SQLYARD.com · May 2026 · Estimated read: 40–50 min
What Every Senior DBA Needs to Know About LLMs, RAG, Agents, and MCP in 2026 Read More »
AI and Analytics for Data Teams: What It Is, What’s Available, and How to Get Started – SQLYARD Leave a Comment / Articles, AI, Analytics / By SQLYARD AI and Analytics for Data Teams: What It Is, What’s Available, and How to Get Started By David Yard · SQLYARD.com · April 2026 · Estimated read:
AI and Analytics for Data Teams: What It Is, What’s Available, and How to Get Started Read More »
Building a Complete SQL Server Health Monitoring System with AI – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD Building a Complete SQL Server Health Monitoring System with AI By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Table of Contents Why SQL Server Monitoring Matters Core
SQL Server Health Monitoring with AI: DMVs, Alerts, and Automated Collection Read More »
Taking the AI Data Layer to Production: Integration, Scaling, and Observability – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD Taking the AI Data Layer to Production: Integration, Scaling, and Observability By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Part 5 of the SQL AI Architecture
SQL Server AI Layer Part 5: Production Deployment, Integration, and Monitoring Read More »
Full Implementation: Metadata-Driven Retrieval, Scoring, and Execution Pipeline – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD Full Implementation: Metadata-Driven Retrieval, Scoring, and Execution Pipeline By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Part 4 of the SQL AI Architecture Series · Part 1: Control ·
SQL Server AI Layer Part 4: Metadata-Driven Retrieval, Scoring, and Execution Pipeline Read More »
Leave a Comment / AI for Data, Articles / By SQLYARD Building an AI Layer on Top of SQL Server: The Complete Guide – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD Building an AI Layer on Top of SQL Server: The Complete Guide By David Yard · SQLYARD.com · April
SQL Server AI Layer Part 1: Building a Controlled AI Layer on Top of SQL Server Read More »
Rethinking SQL Server and PostgreSQL Access, Performance, and Optimization – SQLYARD Leave a Comment / AI for Data, Articles / By SQLYARD Rethinking SQL Server and PostgreSQL Access, Performance, and Optimization By David Yard · SQLYARD.com · April 2026 · Estimated read: 15–18 min Table of Contents Introduction What Is an AI Data Layer? Traditional
SQL Server and the AI Center of Excellence: Governance, Architecture, and Query Optimization – SQLYARD Leave a Comment / AI for Data, Articles / By SQLYARD SQL Server and the AI Center of Excellence: Governance, Architecture, and Query Optimization By David Yard · SQLYARD.com · April 2026 · Estimated read: 18–22 min Table of Contents
SQL Server AI Center of Excellence: 2026 Implementation Guide for DBAs and Azure Teams Read More »
SQL Server Indexing Strategy for Large Databases: AI-Assisted Optimization Guide – SQLYARD Leave a Comment / Articles, AI for Data / By SQLYARD SQL Server Indexing Strategy for Large Databases: AI-Assisted Optimization Guide By David Yard · SQLYARD.com · April 2026 · Estimated read: 20–25 min Table of Contents AI-Assisted Indexing Workflow How SQL Server
