SQL Server 2025 adds native VECTOR search with DiskANN indexing, GitHub Copilot in SSMS, and Fabric Mirroring for on-prem estates. A practical, fact-checked walkthrough with working T-SQL.
Fabric Real-Time Intelligence with Eventhouse and KQL databases is now GA. Here is when to use it vs Azure Data Explorer vs Event Hubs + Stream Analytics.
OneLake security went GA with folder-level RBAC, shortcuts-aware governance, and REST APIs for CI/CD. This is the critical piece that makes Fabric viable for enterprises with sensitive data.