Optimize Existing Databases & Apps with Operational Analytics in Azure SQL - Part 2 | Data Exposed

Published 02-25-2021 10:43 AM 687 Views
Microsoft

You don’t necessarily need to change your data models and applications to run operational analytics workloads on Azure SQL. In part two of this three-part series with Silvano Coriani, we will explore Azure SQL capabilities to optimize your databases for mixed workloads on real-time data.

 

Watch on Data Exposed

 

Resources:
Get started with Columnstore for real-time operational analytics
Sample performance with Operational Analytics in WideWorldImporters
T-SQL Window Functions: For data analysis and beyond, 2nd Edition
Real-Time Operational Analytics:
Memory-Optimized Tables and Columnstore Index
DML operations and nonclustered columnstore index (NCCI) in SQL Server 2016
Filtered nonclustered columnstore index (NCCI)

 

View/share our latest episodes on Channel 9 and YouTube!

%3CLINGO-SUB%20id%3D%22lingo-sub-2166472%22%20slang%3D%22en-US%22%3EOptimize%20Existing%20Databases%20%26amp%3B%20Apps%20with%20Operational%20Analytics%20in%20Azure%20SQL%20-%20Part%202%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2166472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EYou%20don%E2%80%99t%20necessarily%20need%20to%20change%20your%20data%20models%20and%20applications%20to%20run%20operational%20analytics%20workloads%20on%20Azure%20SQL.%20In%20part%20two%20of%20this%20three-part%20series%20with%20Silvano%20Coriani%2C%20we%20will%20explore%20Azure%20SQL%20capabilities%20to%20optimize%20your%20databases%20for%20mixed%20workloads%20on%20real-time%20data.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FdKhsHVqG8XU%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CEM%3EResources%3A%3C%2FEM%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Findexes%2Fget-started-with-columnstore-for-real-time-operational-analytics%3FWT.mc_id%3Ddataexposed-c9-niner%26nbsp%3B%26nbsp%3B%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGet%20started%20with%20Columnstore%20for%20real-time%20operational%20analytics%3CBR%20%2F%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Fdatabases%2Fwide-world-importers%2Fsample-scripts%2Foperational-analytics%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESample%20performance%20with%20Operational%20Analytics%20in%20WideWorldImporters%3CBR%20%2F%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoftpressstore.com%2Fstore%2Ft-sql-window-functions-for-data-analysis-and-beyond-9780135861448%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ET-SQL%20Window%20Functions%3A%20For%20data%20analysis%20and%20beyond%2C%202nd%20Edition%3CBR%20%2F%3E%3C%2FA%3EReal-Time%20Operational%20Analytics%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Farchive%2Fblogs%2Fsqlserverstorageengine%2Freal-time-operational-analytics-memory-optimized-table-and-columnstore-index%3FWT.mc_id%3Ddataexposed-c9-niner%26nbsp%3B%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMemory-Optimized%20Tables%20and%20Columnstore%20Index%3CBR%20%2F%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Farchive%2Fblogs%2Fsqlserverstorageengine%2Freal-time-operational-analytics-dml-operations-and-nonclustered-columnstore-index-ncci-in-sql-server-2016%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDML%20operations%20and%20nonclustered%20columnstore%20index%20(NCCI)%20in%20SQL%20Server%202016%3CBR%20%2F%3E%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Farchive%2Fblogs%2Fsqlserverstorageengine%2Freal-time-operational-analytics-filtered-nonclustered-columnstore-index-ncci%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EFiltered%20nonclustered%20columnstore%20index%20(NCCI)%3C%2FA%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChannel%209%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2166472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201130iE9AAF33173512AF8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2FSPAN%3EE%3CSPAN%3Explore%20Azure%20SQL%20c%3C%2FSPAN%3E%3CSPAN%3Eapabilities%20to%20optimize%20your%20databases%20for%20mixed%20workloads%20on%20real-time%20data.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2166472%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Feb 25 2021 10:43 AM
Updated by: