Practical AWS expertise for SQL Server and data teams moving, modernising and building on AWS

AWS for the people who run SQL Server

Run SQL Server on RDS and EC2, design high availability and disaster recovery, and modernise to Aurora PostgreSQL where it makes sense. AWS was a Platinum sponsor of SQLBits 2026 and ran a full programme of sessions and workshops for SQL Server teams. 

Practical AWS skills you can put to work

Migration, licensing and cost, HA/DR across AZs and Regions, performance tuning on RDS, lakehouse on Iceberg and AI on your data. Sessions include hands-on workshops, not just slides. 

Meet the AWS specialists

SQLBits 2026 featured AWS Principal and Senior Specialist Solutions Architects who work on Microsoft workloads daily. Bring your estate, your questions and your migration blockers. 

The challenges we’ll help you solve 

If any of these sound familiar, you will find people at SQLBits who have already been there. 

  • Our SQL Server 2016 estate is out of Microsoft support, and RDS is auto-upgrading stragglers to 2019. 
  • SQL Server licensing makes every EC2 or RDS sizing decision a cost decision. 
  • Moving to Aurora PostgreSQL means rewriting T-SQL stored procedures into PL/pgSQL. 
  • Transform covers .NET 6+, so older .NET Framework apps need upgrading first. 
  • The newest migration tooling is limited to a few Regions, often us-east-1. 
  • RDS, RDS Custom or EC2 when we need OS-level control? 
  • Designing HA/DR across AZs and Regions without our familiar Always On habits. 
  • Our DBA team is on-premises trained and now has to learn VPCs, IAM and storage tiers. 
  • Estates span AWS, Azure and on-premises, and governance and monitoring are fragmented. 
  • Performance tuning on RDS means working without full server access. 
  • Our dev and test databases cost production-edition licence money. 
  • How do we commit to database spend without lock-in risk? 

Using AWS to strengthen your company’s AI capability

Retrieval over operational data

Aurora PostgreSQL with pgvector (0.8.0) works as a vector store for Bedrock Knowledge Bases, with hybrid search support. 

An agent platform on your data

AgentCore Gateway wraps existing APIs and MCP servers as agent tools, with identity and observability. 

Protecting sensitive data before AI sees it

Aurora PostgreSQL dynamic data masking was announced at re:Invent 2025. 

An open lakehouse on Iceberg

S3 Tables, with Kinesis streaming delivery to S3 Tables (August 2026). SQLBits 2026 included a session on an Iceberg lakehouse. 

Zero-ETL into the lakehouse

Glue zero-ETL integrations feed S3 Tables and the SageMaker lakehouse. 

Dev and test parity for SQL Server

RDS for SQL Server Developer Edition (December 2025) gives non-production environments enterprise features. 

Active-active global apps

Aurora DSQL multi-Region, with CDC generally available since 8 July 2026 for downstream feeds. 

Where agentic AI can help

Eight places agents are already earning their keep in AWS, and where SQLBits sessions will show you how. 

SQL Server and .NET modernisation to Aurora PostgreSQL

AWS Transform for Windows modernisation assesses, converts schema and T-SQL procedures to PL/pgSQL, updates application code and deploys. It supports .NET 6+ and is currently us-east-1 only. 

Offline conversion from DDL files

AWS Transform offline schema transformation (GA, 3 Aug 2026) converts SQL Server DDL with no live database connection, and fixes can be made in the IDE through the AWS Transform MCP server. 

Schema and code conversion for heterogeneous migrations

DMS Schema Conversion with generative AI converts Oracle, SQL Server, MySQL, PostgreSQL and Sybase sources to Aurora or RDS PostgreSQL, extended to nine more regions in March 2026 at no extra charge. 

Incident investigation

AWS DevOps Agent (GA, 31 Mar 2026) correlates telemetry, code and deployment data across AWS, Azure and on-premises. 

AI-assisted database development.

The Aurora PostgreSQL power for Kiro (December 2025) bundles an MCP server with best-practice guidance, so an agent can create clusters, manage schemas and run queries from the IDE. 

Distributed SQL development and diagnosis

Aurora DSQL has an MCP server, Kiro powers and agent skills, plus DSQL Assist (July 2026). 

Spec-driven coding and ops agents

Kiro reached GA in November 2025, with a CLI for agent-driven development. 

Building your own DBA agents

Amazon Bedrock AgentCore (GA, 13 Oct 2025) provides runtime, gateway for MCP, identity and observability. SQLBits 2026 sessions used it with the Strands SDK. 

Key Speakers

Bob Ward, Principal Architect, Microsoft

Bob Ward needs no introduction. A bona fide SQL Server GOAT, Bob is a Principal Architect on Microsoft’s Azure Data team, shaping SQL from ground to cloud to Fabric. In 32 years at Microsoft, he’s worked on every version of SQL Server, from OS/2 1.1 to SQL Server 2025, as well as Azure SQL and SQL database in Fabric.

A world-renowned speaker and bestselling technical author, Bob shares his expertise on SQL Server, Azure SQL, AI and Fabric at leading events including SQLBits, Microsoft Build and Ignite. He’s also the face of the popular Azure SQL for Beginners series.

Brent Ozar, Brent Ozar Unlimited

Brent Ozar makes SQL Server go faster, and makes learning it a whole lot more fun. A world-renowned SQL Server expert, performance tuning specialist and speaker, Brent has spent decades helping database professionals solve their toughest performance problems. He’s the founder of Brent Ozar Unlimited, creator of the hugely popular First Responder Kit and a much-loved educator known for making complex technical topics accessible, practical and entertaining. Through his training, blog posts, videos and open-source tools, Brent has helped SQL Server professionals around the world build faster, more reliable databases.

Subscribe - Brent Ozar Unlimited®

Anna Hoffman, Principal Group Product Manager, Microsoft

Anna Hoffman is helping shape the future of Microsoft SQL. A Principal Group Product Manager on Microsoft’s SQL engineering team, Anna works across the tools and experiences that power SQL Server, Azure SQL and SQL database in Microsoft Fabric. She’s also the host of Data Exposed, bringing the latest developments, product insights and expert perspectives directly to the SQL community. Whether she’s exploring new capabilities or talking to the engineers behind them, Anna connects the people building Microsoft’s data technologies with the people putting them to work.

Anna Hoffman - Data, Artificial Intelligence & Advanced Analytics Summit

Kevin Kline, International speaker, data management expert, and author

Kevin Kline is a noted database expert and software industry veteran. A 20-year Microsoft Data Platform MVP and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server (PASS.ORG), as well as the author of popular books including the bestseller “SQL in a Nutshell”. Kevin is a top-rated speaker at conferences worldwide and has a monthly column at Database Trends & Applications magazine (DBTA.com). His product designs for database tools have won numerous awards.

Check out some of our recent AWS sessions

20 Years of the Cloud: What Changed, What Didn’t, and What’s Next
Brent Ozar leads a panel of experienced data professionals reflecting on 20 years of the cloud. With no vendor marketing, they discuss what actually changed, which problems never went away, and what they expect to face in the next 20 years based on real-world experience.
 
Autonomous DBOps: Agentic AI for Maintaining SQL Server Databases
We will demonstrate about a self-healing database systems using AI agents powered by AWS Strands SDK. Learn to create autonomous agents that diagnose performance bottlenecks, generate optimizations, and implement fixes—transforming reactive database operations into proactive, intelligent automation.
 
Beyond Caching: Building Low-Latency Data Layers for Modern Apps with Open Source In-Memory Database
Improving database performance using in-memory caching Open-source innovation: Valkey, a high performance key-value datastore How Valkey solves challenges for AI developers
 
Breaking the Monolith: Surviving Database Decomposition Without Losing Your Data (or Your Mind)
Learn how to strategically decompose monolithic databases as you move to microservices — covering distributed workflows, event sourcing, CQRS, domain-driven design, and compensation strategies to migrate confidently without sacrificing data integrity or stability.
 
Cost Effective In-Memory Analytics at Scale: Using DuckDB as Application-Layer Offload
Use DuckDB to embed analytics in your application process for in-memory, scalable, low-latency, high-concurrency, low-cost queries without data warehouse complexity. Working code, live demos, performance measurements, and how to address limitations.
 
DBA Horror Stories and Practical Advice for Surviving Your Worst Day
Hear real production horror stories from Ben Miller, Kellyn Gorman, Rob Volk, and Eric Peterson. Learn to identify red flags and build a good defensive strategy. You may not experience the same incident, but one day, you will recognize the moment.
 
From Query Plans to Prompts: How AI Understands SQL Server Internals
How does AI “read” SQL Server execution plans? This session dives into how AI interprets query plans, costs, and operators, where it helps, where it fails, and how DBAs can use it safely for performance tuning.
 
Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.
It began as a small security research project on a local SQL Server, one vulnerability quickly led much further. That initial finding enabled privilege escalation across multiple managed platforms, including Azure SQL Database, GCP CloudSQL for SQL Server, Amazon RDS, and Alibaba ApsaraDB. In this presentation, I'll demonstrate how an attacker can escalate from a low-privileged user to sysadmin in cloud-managed SQL Server environments. I'll also explain why these flaws existed, how to defend against similar attack paths, and how each cloud provider responded.
 
Hosting SQL Server on AWS - What is the right choice for my workload?
How to choose the right AWS SQL Server Service for your workload when you are considering migrating to AWS. This session covers all core hosting options, core features available and what you need to consider in terms of making informed choices.
 

Take a tour of SQLBits 2025

Bring your AWS questions to the people who can answer them. Book your SQLBits 2027 pass today.