Applying SQL Server 2016 Features to Real-world Data Problems
Explore the newest features and performance improvements of SQL Server 2016, quickly after its release on the market. This course will teach you about some amazing new functionality that will help enhance the performance of your solution.
What you'll learn
Along with the release of SQL Server 2016 comes some amazing new functionality that will help enhance the performance of your solution, improve security, integrate and analyze data from all types of sources, and scale your solution to the cloud. In this course, Applying SQL Server 2016 Features to Real-world Data Problems, you'll be able to apply these functionalities to any real-world data problem you may have. First, you'll learn about improving the performance database solution by using in-memory OLTP enhancements, query data store, temporal database, and JSON support. Next, you'll learn how to enhance security at a database level using AlwaysEncrypted, dynamic data masking, and row level security. Finally you'll learn how to head towards the cloud and how HappyScoopers can easily adapt their existent solution to use the powers of the cloud. By the end of this course, you'll have a strong foundational understanding on how to apply the amazing new features of SQL Server 2016 to solve your own real world problems.
Table of contents
- Introduction 1m
- Query Store - General Information 3m
- Query Store - Usage Scenarios 3m
- How Does Query Store Work? 3m
- Demo: Using Query Store for Performance Troubleshooting 6m
- Live Query Statistics 2m
- Demo: Live Query Statistics 3m
- Built-in JSON Support 1m
- Demo: Built-in JSON Support 6m
- Temporal Tables - General Information 2m
- Temporal Tables - Under the Hood 3m
- Demo: Keeping History with Temporal Tables 5m
- Introduction 3m
- Transparent Data Encryption 3m
- Demo: Implementing Transparent Data Encryption 6m
- Transparent Data Encryption Limitations and Enhancements 3m
- Dynamic Data Masking 4m
- Demo: Dynamic Data Masking 5m
- Row-Level Security 6m
- Demo: Row-Level Security 4m
- Always Encrypted Overview 3m
- How Does Always Encrypted Work? 4m
- Demo: Always Encrypted 6m
About the author
Ana Voicu is a software developer passionate about databases, Business Intelligence, and data science. She works on developing enterprise level Business Intelligence solutions for various types of industries, with a focus on performance optimization, pattern recognition, efficient analysis of the business processes, and interactive visualizations. What Ana loves most is overcoming challenges related to database performance, mostly related to data warehouse solutions. Ana discovered a while ago t... more