Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
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.
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 are where you can get hands on experience from what you have learned from lectures. You get to work in real time in virtual machines at your pace.