AWS fundamentals for the accidental SQL Server DBA

With over 200 fully featured services on AWS, it can be challenging for any database administrator trying to ramp up. In this session, learn how to map basic database administrator tasks to the role of a cloud architect. Learn about networking and security and how to implement high availability and disaster recovery for SQL Server. Discover how to use generative AI services like Amazon Q Business and Amazon Q Developer with your deployments and queries. Finally, learn how to choose the right services for your deployment and how to secure and cost-optimize these workloads.

This session helps: *Role Transition & Core Skills* Maps traditional DBA tasks to cloud architect responsibilities Focuses on essential networking and security knowledge Covers SQL Server high availability and disaster recovery implementation on AWS *AI Integration* Demonstrates use of generative AI tools (Amazon Q Business and Q Developer) Applies these AI services to database deployments and queries Note: As of April 2024, these were relatively new AWS services for database management *Optimization & Decision Making* Guides selection of appropriate AWS services for specific database needs Addresses security requirements for database workloads Provides cost optimization strategies for database deployments