Quad Cities Data Professionals - October 15, 2025 Meeting

5:30 Networking
6:00 Presentation

Performance Tuning SQL Server for the Cloud

When your SQL database is in a cloud service, you're paying for performance. How can you maximize performance while minimizing costs? Join me in this session to learn about SQL Server's performance options that can be used to reduce CPU usage and storage, which will reduce costs and make your database faster! I'll show you how to use features such as rowstore and columnstore indexes, in-memory OLTP, and read scale-out to minimize query run times and optimize resource use. DMVs, Query Store, and intelligent query processing will be covered so you know how to look for expensive queries and let the database engine make your queries faster automatically. You'll be ready to get the most performance for the least amount of money from SQL in the cloud.

Jes Chapman

Jes Chapman is a Data & AI Cloud Solution Architect at Microsoft. With a dynamic background spanning software engineering to product management, and enriched by years as a SQL consultant and field engineer for SQL Server, Jes brings a wealth of expertise from the heart of Microsoft. A former five-time Microsoft Data Platform MVP, she's contributed to technical books and taught from stages worldwide with her passion for teaching. When not immersed in the cloud, you'll find Jes conquering trails, hiking through nature's wonders, or experimenting in the kitchen.