A step-by-step walkthrough for modernizing a SQL Server-based application without a full rewrite. Covers five incremental stages: migrating from System.Data.SqlClient to Microsoft.Data.SqlClient, upgrading to SQL Server 2025 (with its new vector data type and binary JSON), replacing CRUD APIs with Data API Builder (REST, GraphQL, and MCP endpoints), managing schema via SQL database projects in CI/CD, and enabling AI agents to securely query data through SQL MCP server. Live demos show full-text/BM25 search replaced by vector semantic search, hybrid multi-database routing through a single API surface, and GitHub Copilot using the MCP endpoint to query products.

30m watch time
38 Impressions