Stijn Wynants

Drawing on deep Microsoft Fabric experience, this session covers the data engineering lifecycle: -ingestion Data Factory and Mirroring, -transforming with Spark and Data Warehouse -orchestrating parallel pipelines -querying data -processing streaming workloads As well as enterprise deployment realities: -OneLake integration -monitoring -capacity visibility -automated deployments Suitable for...

Security is no longer just about locking down data—it’s about enabling safe, scalable, and governed access across your entire analytics platform. In this deep dive session, we’ll uncover how OneLake Security operates under the hood and show you what’s really happening when you secure data in Lakehouses, Semantic Models, and Warehouses within Microsoft Fabric.

Fabric Espresso team is coming to your favorite conference with freshly brewed pot of content! Join us in this hour-long session to learn how to unlock the power of Synapse SQL pools and boost your data warehouse and data lake performance.

Fabric Espresso team is coming to your favorite conference with freshly brewed pot of content! Join us in this hour-long session to learn how to unlock the power of Microsoft Fabric and make your analytics efforts a breeze.

Many companies have invested heavily in building data lakes to store large volumes of structured and unstructured data from various sources into Delta Parquet files. These Delta Parquet files can be used for a wide range of Analytics and Business Intelligence applications.

In this training session you will build a full fletched green field Lakehouse architecture based on best practices! You will be guided by experts in the field to learn about the key components & how to build it in the most dynamic & performant way!

SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.

Azure Synapse Analytics is a unified platform for end-to-end analytics. Join this session to find out about recently announced updates to Azure Synapse and to see the new features in action and learn in which scenarios and how you can use them.

Azure Synapse Analytics has been steadily maturing and growing since it's release, but it's still hard to know where to start! This introductory training session will give you a grounding in all of the Synapse engines so you'll know your Spark Pool from your SQL Pools and be ready to hit the...

Are you ready to unlock the massive power of Synapse SQL Pools? Do you want to see some of the features that are coming and what impact they will have on your workloads? Join us to learn and apply the best strategy when it comes to ingesting and consuming your data with Azure Synapse! The day will be packed with tips and tricks for your Data Warehouse from two folks who work on the largest deployments in the world! In the morning we will ease into Synapse and explaining all key features, from there on we will deep dive into the Polaris engine and how it changes the game. Focus of the morning will be around Dedicated SQL pools and how to get the best performance out of it. We will look at loading patterns and ways to optimize these, table distribution issues, security features, statistics handling, workload management, streaming data and indexing strategies! After lunch we handle the other side of our Synapse Pool environment: Serverless. We will explain how it works, and how to optimize the reading patterns. We will touch upon delta lake and how it fits in, parquet file structure, flat file differences, security features, partitioning strategies, optimized data loading with Spark and many more. After this day you will be able to tackle any issues you face to build a performant, cost efficient and dynamic data warehouse with Azure Synapse SQL Pools.

In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.

This workshop is designed to get hands on experience with a Modern Data Solution. During this day, the participants will be wrangling data inside the Azure Data Platform, going from ingestion to consumption.

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos

When Microsoft Azure SQL Database was introduced, it had only a small subset of the features available in the SQL Server database engine. With the introduction of version V12 a few years ago, Azure SQL Database is now an enterprise-class platform-as-a-service (PaaS) offering. Of course, Microsoft continued to add new features and functionalities into Azure SQL Database. Join our pre-con to learn more about some cool new features that are available now in Azure SQL Database. The main topics we will discuss are: Administration o Hyperscale o Elastic Database Jobs o Backup Retention Periods Business Continuity o Geo-replication & Failover Groups o Virtual Network service endpoints o How to connect to Azure SQL Database and Managed Instance Security o TDE with Bring Your Own Key o Data Discovery and Classification o SQL Vulnerability Assessment Monitoring and performance tuning o Automatic Tuning o Intelligent Insights Managed Instance Migration o Data Migration Service o Azure Data Sync Important! We are not going to start from scratch, so prior knowledge on Azure SQL Database is required. Bring your laptop and your Azure subscription because we’re planning some exercises.