SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration - Couverture souple

Ward, Bob

Couverture souple

ISBN 13 : 9798868818462

Editeur : Apress, 2025

Synopsis

Dive into SQL Server 2025 and uncover its groundbreaking features―guided by one of its key architects. The 2025 release brings SQL Server firmly into the AI age, and this book ensures that you're ready for the leap, walking you through built-in AI for application development, AI-enhanced data analytics with Microsoft Fabric integration―and much more.

At every step of the way, you’ll gain exclusive insights from author Bob Ward, a Principal Architect for the Microsoft Azure Data team, who has worked on every version of SQL Server since OS/2 1.1. With more than 31 years at Microsoft, Ward brings unparalleled expertise and practical knowledge, leaving you and your database in excellent hands.

Ward covers the fundamentals of setup, upgrades, and configuration, and covers advanced features in security, performance, and high availability. He also highlights what makes this the most significant SQL Server release for developers in a decade: support for JSON, RegEx, REST APIs, and event streaming.

Most critically, Ward explores SQl Server 2025’s advanced, secure, and scalable AI integration. After a practical introduction to AI fundamentals to help you integrate artificial intelligence with your data, you’ll learn how to build AI-powered applications deeply integrated with the SQL engine―and elevate your analytics to the next level.

The AI age is here. Be sure your SQL Server databases are ready.

 

What You Will Learn

·         Understand why SQL Server 2025 is a unique new release

·         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 21 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

A propos du livre

À propos de l'auteur

Bob Ward is a Principal Architect for the Microsoft Azure Data team, overseeing the development of Microsoft SQL from ground to cloud to fabric. With more than 31 years at Microsoft, Bob has contributed to every version of SQL Server, from OS/2 1.1 to SQL Server 2022, including Azure SQL and SQL database in Fabric. A renowned speaker on SQL Server, Azure SQL, AI, and Microsoft Fabric, Bob frequently presents on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, Fabric Community Conference, and VS Live. You can learn from Bob through his popular series at aka.ms/azuresql4beginners. Follow him on Twitter @bobwardms or connect on LinkedIn at linkedin.com/in/bobwardms. Bob is the author of several Apress books, including Pro SQL Server on Linux, SQL Server 2019 Revealed, Azure SQL Revealed, SQL Server 2022 Revealed, and Azure SQL Revealed, 2nd Edition.

Détails de l'édition

• Éditeur: Apress
• Date d'édition: 2025
• Langue: anglais
• ISBN 13: 9798868818462
• Reliure: Broché
• Nombre de pages: 348
• Coordonnées du fabricant: ProductSafety@springernature.com; ProductSafety@springernature.com; ; Poststr. 9; Darmstadt; 64293; Allemagne