How to Create Operational Analytics with Window Functions in Azure SQL - Part 3 | Data Exposed

Published Mar 05 2021 09:00 AM 1,195 Views
Microsoft
%3CLINGO-SUB%20id%3D%22lingo-sub-2188132%22%20slang%3D%22en-US%22%3EHow%20to%20Create%20Operational%20Analytics%20with%20Window%20Functions%20in%20Azure%20SQL%20-%20Part%203%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2188132%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ERunning%20complex%20aggregations%20and%20analytical%20functions%20on%20real-time%20operational%20databases%20is%20a%20powerful%20capability%20in%20Azure%20SQL.%20In%20the%20last%20part%20of%20this%20three-part%20series%20with%20Silvano%20Coriani%2C%20we%20will%20see%20how%20Window%20Functions%20can%20be%20a%20great%20tool%20to%20express%20analytical%20calculations%20on%20real-time%20data%20sets.%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%2Fh0Ik8VWxI4Q%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%3EMore%20episodes%20in%20this%20Operational%20Analytics%20Series%3A%3C%2FEM%3E%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FL0pnYWctrY4%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EHow%20Azure%20SQL%20Enables%20Real-time%20Operational%20Analytics%20(HTAP)%20-%20Part%201%3C%2FA%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FdKhsHVqG8XU%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSPAN%3EHow%20to%20Optimize%20Existing%20Databases%20%26amp%3B%20Applications%20with%20Operational%20Analytics%20in%20Azure%20SQL%20-%20Part%202%3C%2FSPAN%3E%3C%2FA%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%25C2%25A0%25C2%25A0%25C2%25A0%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%25C2%25A0%25C2%25A0%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%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2188132%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%3E%3CSPAN%3E%20Learn%20how%20to%20create%20operational%20analytics%20with%20Window%20Functions%20in%20Azure%20SQL.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2188132%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:
‎Mar 05 2021 07:27 AM
Updated by: