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

New Features in SQL Server 2016 for Developers
LinkedIn Learning
Scaling Your SQL Server Application
LinkedIn Learning
SQL Server 2014 In-Memory OLTP Management
PASS Data Community Summit via YouTube
AlwaysOn in Microsoft SQL Server 2014
PASS Data Community Summit via YouTube
SQL Server 2014 - In-Memory OLTP End-to-End - Preparing for Migration
PASS Data Community Summit via YouTube