Not your Father's SQL Server: Developer Innovations in Data Storage
summary
SQL Server 2025 and Azure SQL bring concrete developer features: Data API Builder (akms/dab) auto-generates REST/GraphQL endpoints from a JSON config and reduces boilerplate, while vector type plus a built-in vector search and support for embeddings via sp_invoke_external_rest_endpoint enable semantic search. Hyperscale separates compute from storage and allows ~30 readonly replicas for CQRS. JSON becomes a binary data type with a 2GB limit, graph tables use hidden $node/$edge IDs and MATCH for shortest paths, and change tracking/CDC/event streams export changes to Event Hubs. Tooling migrates ADS features into the MSSQL VS Code extension.
AI-written summary · about
chapters (15)
- 0:00SQL Server innovations intro
- 3:12SQL Server 2025 updates
- 6:00Data API Builder
- 9:08Hyperscale benefits
- 10:52Code-first vs DB-first
- 17:51MSSQL AI extension
- 22:05Multimodal data support
- 26:16Vector data and AI embeddings
- 33:38Graph database queries
- 38:54JSON binary type
- 43:04Change tracking enhancements
- 48:17Change event streaming
- 50:22Regex and fuzzy search
- 57:02Developer tooling evolution
- 1:00:11SQL Server 2025 summary
related talks
56mExciting new features in SQL Server for developers
43mIncrease developer velocity with Azure SQL Database from data to API
01h 01mLatest Innovations for SQL and Operational Databases for Developers
49mFrom the Classroom to the Boardroom – Azure SQL DB through Demos
40mThe SQL Leadership Panel
48mThe Kingdom of AdventureWorks Calls for Aid
01h 15mChoose Azure SQL Database and Learn What Every Developer Should Know
51mSQL Server 2022 and the Wheel of Power