SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data
Offered By: PASS Data Community Summit via YouTube
Course Description
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
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX