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

Power Automate Flows with Calum Simpson and Adam Cogan – Long

Power Automate lets power users automate away repeatable manual processes. They can go from zero to hero in under a day!

Sites to Give Your Admin Staff on SharePoint with Warwick Leahy

It’s important for all your SharePoint Sites to be as consistent as possible.

In the days of classic SharePoint, subsites were a popular way of organising your intranet. Modern SharePoint architecture leans toward a flatter hierarchy, where sub-sites are generally not recommended.

Teams and SharePoint Search Bug with Jean Thirion

Not finding stuff you have permissions to is super frustrating. So this one has always confused us…. Do you consider it a bug?

Azure Resource Naming Conventions with Luke Cook

Having inconsistent resource names across projects creates all sorts of pain:
– Struggling to identify resources
– Unsure what to label new resources.
– Risk of duplicating resources

Developing Flexible Authorization Capabilities in ASP.NET Core with Jason Taylor

In this talk, Jason Taylor will demonstrate an approach using permission-based authorization to overcome these limitations by building a flexible approach to managing roles and permissions from within your system. This will improve the maintainability and visibility of access control across your system. Putting the power into the hands of application users and administrators, rather than developers.

SSW 2022 Welcome Back To Office Lunch

On the 4th of February we welcomed everyone back to the office with a fantastic lunch! 🥗

It has been a roller coaster 12 months with restrictions, so it was amazing to see everyone back in the office working side by side again 👏

Tech News: State of JS Survey 2021, AU domains available, GitHub issues changes, .NET 7 preview

Join Adam as he delivers the latest Tech News during our March User Group.

SSW is proud to announce its latest product – The SSW TimeBand!

Our development team spent a few months working really hard on this new product, and Chief Architect Adam Cogan is officially launching it today.

Rules to Better Security with Adam Cogan – The 10 tips CEOs Must Know

Do you know the security best practices for both end-users and SysAdmins?

Join Adam for the 10 tips CEOs must know for both end-users and SysAdmins.

Microservice Solutions with Ocelot on Azure with Patrick Zhao

Learn from Patrick how valuable Ocelot is and see the ins and outs of building an API gateway and protect the services using Azure VNet.