Implementing Real-Time Operational Analytics in Azure SQL Database
Lab
Intermediate
1 h 10 m
2017-09-19
Lab Overview
In this lab, you will explore real-time operational analytics using Azure SQL Database. You will evaluate the performance improvements you will get when you add updateable non-clustered columnstore indexes on top of standard tables as well as memory-optimized tables.

Related Learning Path(s):
Azure SQL Database and SQL DW
Objectives
  • Implement Real-Time Operational Analytics in Azure SQL Database
  • Understand the use cases for In-Memory Analytics in Azure SQL Database
Pre-Requisites
  • Previous experience with SQL Server or Azure SQL Database
Exercises

In this exercise, you will create non-clustered columnstore indexes to improve performance of an analytic workload against an OLTP table. This is also known as Hybrid transactional/analytical processing (HTAP).

In this exercise, you will create non-clustered columnstore indexes on top of memory-optimized tables.
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More