Data Lakehouse with Azure Synapse Analytics

2022

TL; DR

You will be amazed of how many options we have for data exploration in Synapse, you will see new ways to architect data analytics by combining multiple data sources ad hoc. We will build a common report from data stored in ADL and in Cosmos DB, and we will show it in PBI. All in Synapse! You will see the concept of Data Lakehouse in action!

Session Details

Data lakehouse is a relatively new concept of querying data directly and in the same way no matter if the data is in data lake or in relational data warehouse. Lets see how we could implement it in Synapse! You will be amazed of how many options we have for data exploration in Synapse, you will see new ways to architect data analytics by combining multiple data sources ad hoc. We will build a common report from data stored in ADL and in Cosmos DB, and we will show it in PBI. All in Synapse! You will see the concept of Data Lakehouse in action! And of course we will discuss when to use what, because this is the key to build a good solution!

3 things you'll get out of this session

Margarita Naumova's other proposed sessions for 2026

From Load to Logic: Designing for Performance in Microsoft Fabric Warehouses - 2026

A Deep Dive into Table Partitioning – Part 1: Mechanics and Performance - 2026

A Deep Dive into Table Partitioning – Part 2: Design, Maintenance, and Troubleshooting - 2026

Large Tables, Big Problems: Indexing, Partitioning, and Archiving at Scale - 2026

SQL Server 2025 and Microsoft Fabric: Integration Patterns and Trade-offs - 2026

SQL Server 2025 Optimized Locking and ADR: Practical Internals for Real Systems - 2026

Warehouse loading – tips and tricks for better performance - 2026

Margarita Naumova's previous sessions

Keeping historical data in tables forever – mission (im)possible!

Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.

Modern database design (anti)patterns

We must realize that patterns which were valid 10 years ago are less likely to work now, like cursor logic, xml usage, or storing all in db v/s using NoSQL. From global industry trends to specific database patterns, this session is a combination of best practices, good and bad patterns, tips, and tricks which I give to customers in my work as a consultant.

SQL Server Table partitioning – DOs and DON’Ts

When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?

Identify opportunities for In-Memory OLTP

The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.