SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data

Explore a comprehensive overview of SQL Server 2016's hero features in action through a full lifecycle of financial data. Dive into record-breaking performance enhancements, improved Always On Availability Groups, and the benefits of In-Memory OLTP. Examine traditional operational/analytics architecture and learn about leveraging Columnstore and AG for improved performance. Discover how to protect data at rest and in motion, both on-premises and in the cloud. Gain insights into Stretch Database technology, which allows secure stretching of cold tables to Azure with remote query processing. Follow along with a practical airline ticket reservation driver example to see these features in action. Presented by Marko Hotti and moderated by Kenneth Urena, this hour-long session offers valuable knowledge for database professionals looking to harness the power of SQL Server 2016.

Syllabus

Intro
Technical Assistance
Record-breaking performance
Enhanced Always On Availability Groups
In-Memory OLTP Benefits
Traditional operational/analytics architecture
Solution Pattern: Leveraging Columnstore + AG for performance and
How it works Help protect data at rest and in motion, on-premises and in the cloud
Stretch Database
Stretch SQL Server into Azure Securely stretch cold tables to Azure with remote query processing
Airline Ticket Reservation Driver