Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

PASS Data Community Summit via YouTube

Overview

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

Taught by

PASS Data Community Summit

Reviews

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.