Microsoft Workloads on AWS
Join AWS at PASS Data Community Summit 2024
AWS is excited to announce our participation as a Platinum sponsor at the PASS Data Community Summit 2024, continuing our commitment to empower organizations with our data and AI services. Our mission is to help businesses migrate, optimize, and modernize Microsoft SQL Server workloads while accelerating innovation, offering unrivaled reliability, security, and cost efficiency—all within the world’s most comprehensive and broadly adopted cloud.
This year’s PASS Data Community Summit promises to be an exciting opportunity for data professionals, as the need to migrate and run mission-critical SQL Server workloads in the cloud becomes increasingly important. According to a recent IDC Infobrief, AWS is the top cloud provider of choice for SQL Server workloads, with more than 52% of Microsoft SQL Server users selecting AWS—more than the next six cloud providers combined.
At AWS, we are dedicated to helping customers unlock the full potential of their data. Whether you’re migrating existing workloads, building new applications, or exploring advance AI capabilities, AWS provides the tools and expertise to help you meet your goals. Join us in Seattle for breakout sessions, in-depth technical sessions, hands-on demos, and real-world success stories from companies that have transformed their data strategies with AWS. If you haven’t registered yet, use the discount code AWS150CP to get $150 off your PASS Summit ticket.
Elevate your data expertise with AWS
As part of our commitment to the PASS Data Community Summit, we are excited to offer a wide range of educational sessions to empower your data journey, covering various topics, such as SQL Server, PostgreSQL, generative AI, cost optimization, and database management best practices. AWS customers such as Mindbody and Lytx will come on stage to share their experience and best practices for migrating and modernizing SQL Server workloads in the cloud. Here’s a sneak peek of our sessions:
Mindbody’s SQL Server cloud migration journey and beyond (Session 2298)
Join us for an insightful session as we delve into Mindbody’s journey of migrating their SQL Server workloads to the AWS cloud. This session will cover key aspects of the migration process, including SQL Server licensing considerations, cost optimization, and best practices for operating SQL Server in a cloud environment. We’ll explore the technical challenges and solutions Mindbody encountered during the migration, sharing valuable lessons learned along the way. Additionally, we’ll discuss the steps Mindbody is taking to modernize its SQL Server workloads beyond a simple lift-and-shift approach, focusing on optimizing performance, enhancing scalability, and leveraging AWS services.
Transforming SQL Server to Aurora PostgreSQL: Lytx’s modernization journey (Session 2351)
Join this session to explore how Lytx modernized its SQL Server workloads by transitioning to Amazon Aurora PostgreSQL, achieving greater scalability and enhanced disaster recovery capabilities across multiple regions. Delve into the modernization process and learn how Lytx improved infrastructure agility, reduced maintenance efforts, and empowered innovation using open-source technology. Discover how this shift optimized operational efficiency, significantly reduced costs, and opened doors to future growth and innovation within their architecture.
Reduce cost for SQL Server workloads on AWS using Optimize CPUs feature (Session 2311)
SQL Server cost optimization remains a top priority for AWS users. That’s because database workloads typically depend on high memory and IOPS and less on vCPUs. In this session, learn how to reduce the cost of running SQL Server on Amazon EC2 while increasing the price performance by using the Optimize CPUs feature on Amazon EC2. This session shares insights obtained through extensive testing including rigorous load testing with HammerDB simulations. Learn best practices you can use to maximize savings without sacrificing performance.
Generative AI for SQL Server (Session 2312)
Explore the transformative power of Generative AI for SQL Server in this session. Learn how Amazon Bedrock powers automated code generation, streamlining development processes. Discover advanced AI-driven monitoring and observability to optimize database performance. We’ll also cover how to implement a generative AI use case using Amazon RDS for SQL Server as both an operational data store and a vector data store, enabling advanced similarity searches. Tailored for database administrators and developers, this session offers practical insights into integrating AI to elevate SQL Server operations and capabilities.
Conquer SQL Server database administration using Amazon RDS (Session 1411)
Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. In this session, learn how to achieve top-notch database administration with Amazon RDS for SQL Server. Next, we will explore designing an automated and highly-available database environment, including disaster recovery, automated, and monitoring on Amazon RDS for SQL Server. You will also learn how to achieve common DBA tasks with RDS SQL Server such as backup, restore, CheckDB and auditing.
Break free from your database monolith with microservice architectures (Session 1412)
Monolithic SQL Server databases can become inefficient and unscalable over time due to technical debt. Decoupling these databases is complex, requiring careful migration, schema separation, and dependency management. This session explores strategies for overcoming these challenges and demonstrates how to decouple a monolithic database and migrate it to a microservices architecture using services like Amazon RDS for PostgreSQL and Amazon DynamoDB.
Applying software development principles for data processing with Spark (Session 1665)
This session covers applying software development principles to data processing with Apache Spark and Scala. You’ll learn best practices like code maintainability, readability, and testability in Spark workflows. Practical examples will demonstrate efficient and scalable data processing applications. Ideal for data engineers and software developers, this session is valuable whether you’re new to Scala for Spark or experienced, offering deeper insights into building high-quality applications.
Building an Amazon Q chatbot for your PostgreSQL and SQL Server data (Session 1432)
Learn how to utilize Generative AI on top of your data residing in SQL Server and PostgreSQL databases, and build a chatbot on top of the data with Amazon Q without coding skills. Understand how you can integrate and continuously update new data so business users can query, derive trends and request information without contacting the database administrators and writing complex SQL queries.
Breakfast with AWS experts on Thursday, November 7
Join AWS for breakfast on Thursday, November 7, from 6:45 AM to 8:00 AM in Ballroom 2 & 3. Discover why AWS is the right choice for your SQL Server workloads, and explore the various migration and modernization options.
Why organizations run their SQL Server workloads on AWS (Session 2333)
AWS has been investing in being the best place to run Microsoft workloads since 2008—longer than any other major cloud provider. The goal is to provide organizations with the most operational experience, at greater scale, of any cloud. During this breakfast session, the AWS team will share insights and real-world examples of why organizations continue to choose AWS to run their mission-critical SQL Server workloads. When experience matters, customers choose AWS.
In-booth theater sessions and swag
When you visit our booth at the Summit, prepare to be inspired by 15 in-booth theater sessions, featuring AWS data experts and partners. These sessions offer a unique opportunity to gain insights, ask questions, and interact with your peers who are shaping the future of data. Plus, there’s more to look forward to – in-booth session attendees have the chance to win a copy of the book, Data Engineering with AWS – Second Edition.
And don’t forget to drop by and collect some swag! From T-shirts to stickers and pens, we have plenty of goodies to make your Summit experience even more memorable.
Book a meeting with AWS experts
If you’re interested in having in-depth conversations to kickstart your cloud journey and map out a plan for your data strategy, book a meeting with AWS experts by emailing microsoft@amazon.com with ‘PASS’ in the subject line.
Join us in Seattle for sessions, demos, and technical conversations. We can’t wait to see you there!
AWS has significantly more services, and more features within those services, than any other cloud provider, making it faster, easier, and more cost effective to move your existing applications to the cloud and build nearly anything you can imagine. Give your Microsoft applications the infrastructure they need to drive the business outcomes you want. Visit our .NET on AWS and AWS Database blogs for additional guidance and options for your Microsoft workloads. Contact us to start your migration and modernization journey today.