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.
Course info
Rating
(81)
Level
Intermediate
Updated
Jul 8, 2016
Duration
2h 36m
Table of contents
Description
Course info
Rating
(81)
Level
Intermediate
Updated
Jul 8, 2016
Duration
2h 36m
Description

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.

About the author
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.

Section Introduction Transcripts
Section Introduction Transcripts

Improving the Performance of Your Database
Hi again. I'm Ana Voicu from sqlbythebook. com, and I'm recording the second module of the course, Applying SQL Server 2016 Features to Real-world Data Problems, for Pluralsight. In this module, you will learn how to make use of SQL Server 2016 to improve your database's performance. Over the next minutes, we will take a look at the following features: Query Store, a new feature used to monitor and optimize query plans with full history of query execution, Live Query Statistics, Native JSON, helpful for parsing and storing JSON data formats as relational data, and also the other way around for exporting relational data to a JSON format, and Temporal Tables used to easily track historical data with minimal changes to an already existing table. These are all new additions to SQL Server, and each of them can help us a lot when working with our databases. As I mentioned before, we are going to approach the new features of SQL Server 2016 by analyzing in depth the problems that Happy Scoopers have on their database, and trying to implement a solution for them. A backup of the database and all the scripts used in the demos can be found in the materials of this course.

Heading Towards the Cloud
Hi, I'm Ana Voicu from sqlbythebook. com, and I'm recording the course, Applying SQL Server 2016 Features to Real-world Data Problems, for Pluralsight. You are watching module 5, Heading Towards the Cloud, where I will show you the improvements SQL Server 2016 brought to the table for making it easier to have a database application in the cloud, taking into account characteristics like scalability and flexibility. I will provide a high-level overview of the possibilities of deploying a SQL Server database in a private, hybrid, or public cloud. An important point in Microsoft SQL Server's roadmap was a better and easier integration with external data sources. Microsoft Cloud Services is getting more and more attention these days, and customers have started to use the cloud's capabilities to integrate large quantities of data taken from many different sources. Because of this, the cloud services are being constantly improved at a very fast pace. In SQL Server, the cloud integration was a center focus of development, starting with SQL Server 2012, and getting better and better with each version. SQL Server 2016 comes with the following functionalities and improvements, Stretch Databases, enhanced backups to the cloud, easier migration to the cloud, enhanced availability with cloud replicas, consistency in working with SQL Server on-premise, SQL Server on Azure Virtual Machines, and Azure SQL Database. Check out the next sections of this module to see in more detail what SQL Server brings in terms of Hyperscale Cloud.