October 2025
Intermediate to advanced
341 pages
7h 15m
English
book
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
by Bob Ward
Overview
Unveil the data platform of the future with SQL Server 2025—guided by one of its key architects.
With built-in AI for application development and advanced analytics powered by Microsoft Fabric, SQL Server 2025 empowers you to innovate—securely and confidently. This book shows you how.
Author Bob Ward, Principal Architect for the Microsoft Azure Data team, shares exclusive insights drawn from over three decades at Microsoft. Having worked on every version of SQL Server since OS/2 1.1, Ward brings unmatched expertise and practical guidance to help you navigate this transformative release.
Ward covers everything from setup and upgrades to advanced features in performance, high availability, and security. He also highlights what makes this the most developer-friendly release in a decade: support for JSON, RegEx, REST APIs, and event streaming.
Most critically, Ward explores SQL Server 2025’s advanced, scalable AI integrations, showing you how to build AI-powered applications deeply integrated with the SQL engine—and elevate your analytics to the next level. But innovation doesn’t come at the cost of safety: this release is built on a foundation of enterprise-grade security, helping you adopt AI safely and responsibly. You control which models to use, how they interact with your data, and where they run—from ground to cloud, or integrated with Microsoft Fabric. With built-in features like Row-Level Security (RLS), Transparent Data Encryption (TDE), Dynamic Data Masking, and SQL Server Auditing, your data remains protected at every layer.
The AI age is here. Make sure your SQL Server databases are ready—and built for secure, scalable innovation.
What You Will Learn
· Grasp the fundamentals of AI to leverage AI with your data, using the industry-proven security and scale of SQL Server
· Utilize AI models of your choice, services, and frameworks to build new AI applications
· Explore new developer features such as JSON, Regular Expressions, REST API, and Change Event Streaming
· Discover SQL Server 2025's powerful new engine capabilities to increase application concurrency
· Examine new high availability features to enhance uptime and diagnose complex HADR configurations
· Use new query processing capabilities to extend the performance of your application
· Connect SQL Server to Azure with Arc for advanced management and security capabilities
· Secure and govern your data using Microsoft Entra
· Achieve near-real-time analytics with the unified data platform Microsoft Fabric
· Integrate AI capabilities with SQL Server for enterprise AI
· Leverage new tools such as SQL Server Management Studio and Copilot experiences to assist your SQL Server journey
Who This Book Is For
The SQL Server community, including DBAs, architects, and developers eager to stay ahead with the latest advancements in SQL Server 2025, and those interested in the intersection of AI and data, particularly how artificial intelligence (AI) can be seamlessly integrated with SQL Server to unlock deeper insights and smarter solutions
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.