Mastering Modern SQL Server Management: Tips for Administration with AI

Dynamic three-part presentation exploring the evolution of SQL Server administration as more systems shift from on-premise to the cloud.

Part 1: What’s New in SQL 2025 and SSMS 21
Art will kick things off by demonstrating the updated installation process for SQL Server Management Studio 21 and Microsoft SQL Server 2025, highlighting the integration of Copilot into SSMS and how it enhances day-to-day operations.
Part 2: Real-World Cloud Administration Challenges
As the installation proceeds, David will take the reins to discuss the challenges DBAs face when managing cloud-hosted databases particularly in the Microsoft Dynamics 365 and Power Platform ecosystems. He will also review the essential tools and best practices used by experienced cloud admins.
Part 3: Hands-On with Copilot and Azure AI Foundry
Demonstrate how to configure Copilot in SSMS 21 using Azure AI Foundry. This segment includes sample prompt engineering within SSMS plus, and if time allows a little fun with Foundry to showcase its creative potential.
Don’t miss this insightful session designed to equip database professionals with the knowledge and tools to thrive in an AI-driven, cloud-first world.