Deepak Sharma

Discover how AWS Kiro and Model Context Protocol (MCP) servers are transforming SQL Server management. Learn how AI-powered automation and natural language commands can simplify routine tasks, optimise queries, analyse schemas, and improve performance helping database professionals work faster, smarter, and more efficiently.

AWS has introduced Kiro, an AI-powered assistant, and Model Context Protocol (MCP) servers to transform how SQL Server professionals manage critical database systems. These open-source tools enable AI-assisted development through local CLI integration, allowing professionals to automate workflows, optimize query performance, and troubleshoot complex issues more efficiently. By leveraging AWS's scalable infrastructure with intelligent automation, Kiro and MCP help database professionals accelerate application development from prototype to production while maintaining enterprise-grade reliability.

Learn advanced techniques to monitor and optimize Amazon RDS SQL Server performance. Discover how to use CloudWatch Database Insights and query execution plans to identify bottlenecks, troubleshoot inefficient queries, and resolve critical performance gaps. Explore best practices for migrations, upgrades, and uncommon performance issues to keep your RDS instances running at peak efficiency.

This session reveals advanced monitoring techniques that uncover hidden performance issues and drive effective tuning strategies. You'll learn how to use Database Insights, and query execution plans to pinpoint resource contention, inefficient queries, and critical performance gaps following with migration and upgrade strategies/best practices.