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

Tech News #28 | Prompt Engineering, GitHub Check-ins & Microsoft Teams Sparkles

Discover the fascinating world of prompt engineering and its impact on AI development.

May the 4th Be With You | Home & Office Automation

A long time ago in a galaxy far, far away, technology has advanced to a point where even our homes and offices can be smart. With the power of automation systems from SSW, controlling our lights, climate, entertainment, and security has become as easy as pressing a button on our Control4 remotes or smartphones. Imagine walking into your home or office and the doors unlock, the lights turn on, the air conditioner adjusts to your preferred temperature, and your favorite Star Wars soundtrack plays in the background. With SSW’s smart solutions, the force will be with you, always.

Exploring the Capabilities of ChatGPT | Calum Simpson | User Group

Discover how GPT-4 can revolutionize your workflow, and increase your productivity and efficiency. This is your chance to gain insight into the future of AI and software development. Get ready to learn and explore the exciting possibilities of GPT-4! 🤘

The only ChatGPT cheatsheet you’ll ever need (Developer Edition) | Luke Cook | SSW Rules

As ChatGPT becomes increasingly popular, users are discovering the most effective ways to prompt the AI for different scenarios.

How and when to offer unsolicited feedback | Matt Goldman & Ulysses Maclaren | SSW Rules

With empathy and the right approach, you can provide meaningful support and help others reach their goals. Join us for tips on how to offer feedback with care, so you can empower your team to be their best selves.

The best way to handle requests from your boss | Jonty Gardner | SSW Rules

Managing deadlines can be tricky, let’s find out how to deal with unexpected changes to project priorities.

How to Plan for Database Performance | Bryden Oliver | User Group

Are your applications running at a snail’s pace? 🐌
Have you been wracking your brain trying to identify the source of the bottleneck? 🔍

Tech News #26 | Adam Cogan | User Group

Adam Cogan brings you the most important and recent tech news, including the release of .NET 8 preview, updates on Azure Open AI Service, GitHub, and AWS, and the rebranding of Netlify CMS. He also introduces the new, faster version of Microsoft Teams.

Simply Remote Testing with Dev Tunnels | Daniel Mackay | SSW Rules

Find out how to expose a locally running application over the internet for testing and design feedback.

Content Creation 101 – A Creative’s Guide | Richard Campbell and Adam Cogan | Tech Chat

Storytelling and content creation can be daunting and complex endeavour.