Engage in an exclusive session with Microsoft's Engineering Team, led by Rie Irish, to explore the intricacies of databases and data warehousing at Microsoft. Gain insider knowledge about SQL Server, Azure SQL Database, Azure SQL Data Warehouse, and other Azure data services directly from Engineering PMs. Discover the product development process, the team's dedication and passion, and their collaboration with MVPs and the community. Delve into topics such as Synapse, SQL Server's future, Query Store, Azure Arc, and database configurations. Explore pricing models, performance optimization, cumulative updates, and the evolution from SQL Server 2000 to modern data warehousing solutions. Participate in a Q&A session covering contained databases, container integration, and SQL replication. Note that no NDA material will be discussed during this 1 hour 15 minute talk from the PASS Data Community Summit.
Overview
Syllabus
Introduction
What is synapse
Whats next for SQL Server
How did you get that to work
How did you start presenting on Query Store
How did you find a bug in Query Store
The benefits of being an MVP
Azure Arc
Master and MSDB
Questions
Contained Databases
Container Integration
Pricing
Pricing Models
Performance
cardinality estimator
database scope configuration
email me
we have a very similar situation
onpremise solution
Cumulative updates
Engineering systems
Release schedule
Observations
Software has bugs
Modern Data Warehouse
SQL Server 2000
SQL Replication
Taught by
PASS Data Community Summit
