YoVDO

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

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Data Analysis Courses Cloud Computing Courses Data Protection Courses Database Administration Courses In-Memory OLTP Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube
Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube
Transform Your Data Estate
PASS Data Community Summit via YouTube
Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube
SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube