Azure real-time analytics: (look mum, no warehouse!)

Get started with Hybrid transaction/analytical processing (HTAP) in Azure. This talk will explore real time analytics in Azure without traditional ETL processes and data warehouses. What kind of use cases can you implement with an HTAP model, and what does this mean for the traditional data warehouses? Join this session with Prem to find out more about this exciting possibility.

00:00 – Introduction

02:19 Agenda

03:47 Transactional databases OLTP

05:05 reporting databases – OLAP

07:36 Real time analytic – use cases

09:36 Hybrid Transaction/ Analytical Processing (HTAP)

14:16 HTAP in Azure SQL

30:36 HTAP in Azure SQL – Demo

37:50 HTAP in Cosmos

49:51 The big question – Do we still need a data warehouse?

|| Subscribe for more content from SSW TV ||

|| Press like and leave a comment below to let us know how we’re doing ||

Twitter ↴ https://twitter.com/ssw_tv

Facebook ↴ https://www.facebook.com/SSW.page

See more videos at http://tv.ssw.com

For more information about SSW’s web application consulting services, please visit https://www.ssw.com.au/ssw/Consulting…

Created by SSW TV | Videos By Developers, For Developers

About the speakers

About the speakers

Prem Radhakrishnan

Prem is a Solution Architect at SSW and brings over 12 years of enterprise software development and management experience to the SSW Team.

Related videos

Related videos

How to record a done video in SSW | Sylvia Huang | SSW Rules

Sylvia Huang from SSW shares her SSW Cultural Exchange experience from Hangzhou, China to Australia

4 Essential Sales Tips for Engineers | Adam Cogan

Not a salesman? No problem. Adam Cogan shares 4 practical tips to help engineers navigate sales meetings with confidence. Learn how to stop “selling” and start solving, how to talk numbers without the awkwardness, and why being transparent about your process wins more clients.

Do you explain why you’ve deleted or updated an appointment? | Adam Cogan | SSW Rules

Ever wonder why a meeting was moved or cancelled? Adam Cogan explains the “Secret Ingredient” to professional scheduling: always include a version history and reason for change at the top of your appointments. Improve clarity, keep a record of changes, and hold participants accountable with this simple SSW Rule.

Chat first before changing others’ code | Adam Cogan

Changing someone else’s code? Don’t just dive in! Adam explains why it’s important to check the source history and talk to the original developer before making changes. A quick chat can save headaches and keep everyone on the same page. Perfect advice for devs working in teams!

SSW TimePro – Create a new tenant | Jeoffrey Fischer

Learn how to provision a new tenant in TimePro and sync it with an external Dynamics 365 CRM system.

How to Report Bugs in Seconds | Brady Stroud

Tired of tedious bug reporting? Watch how Brady uses YakShaver.ai to turn a quick screen recording into a professional PBI instantly.

White space – Tips for recording demo | Adam Cogan

Awkward pauses can ruin an otherwise good presentation. In this video, Adam shares a simple tip to handle white space during demos and recordings. By telling your audience what’s about to happen, you avoid silence, cut out useless fillers, and sound more confident. Perfect for product demos, meetings, or presentations on any stage.

Don’t throw things over the fence until you’ve done what you can | Adam Cogan

“Throwing it over the fence” means passing your work or problem to others. This short video delivers one clear message: before you hand something off, do what you can yourself. It’s a simple reminder about responsibility, effort, and ownership in work, teamwork, and daily life.

Why No One Can Agree on the “New” Button? | Adam Cogan

Struggling to juggle a hotfix while mid-feature without losing your flow?

SSW Strasbourg Office in Europe | Walkthrough with Jean

Hear from SSW Senior Software Engineer Jake Bayliss about the importance of providing context, showcasing your work and asking for questions & direction from Product Owners.