SQLBits 2022

Reporting on 1.4B rows with Serverless SQL Pools

Building a dashboard using Serverless SQL Pools in a performant way

In this session we will be showing you how to build a logical datawarehouse with Serverless SQL Pools & report on this with Power BI.
We will start off with an introduction to Serverless SQL Pools and move on to building a performant logical structure. After this, we will dive into modeling best practices to reduce costs and end with general performance optimizations.
After this session you will be able to start building your own solution based on Parquet files using Serverless SQL Pools.

feedback link https://sqlb.it/?7042

Mark Pryce-Maher's previous sessions

Nose-Dive Narratives: Slide Karaoke 2024

Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!

Fabric Product Group - Ask us Anything

Come and join the Fabric Product Group for one of our fireside chats. Bring your questions because we have all the answers!!

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

A Deep Dive into Microsoft Fabric Data Warehouse

Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.

Synapse Q&A with PG

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.

Lightning Talks

5 minute lightning talks from your favourite speakers

Dedicated SQL Pools : How some stuff 'really' works

Session covering table distributions, partitioning , RSC and materialised views.

Reporting on 1.4B rows with Serverless SQL Pools

Building a dashboard using Serverless SQL Pools in a performant way

Azure Synapse Analytics: Evolving Azure SQL Data Warehouse

In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics.

Modernizing & Migrating Your Data Warehouse w/ Azure Synapse

This session will dive into how to successfully migrate to Azure Synapse, all the way from code conversion to enterprise grade developer tooling, with real customer examples for product and migration experts.

Azure Machine Learning from the ground up

Azure Machine Learning is a fully managed cloud service for predictive analytics. In this 1hour session, we will run through; ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.

Building a SSMS Add-in; The Agony and Ecstasy

We will travel back in time a bit to SQL 2005 to see how SSMS Add-ins worked, then jump forward to the present day were we will go through the process of writing a SSMS Add-in for R2.

Stijn Wynants's other proposed sessions for 2026

OneLake Security: A Deep Dive - 2026

Stijn Wynants's previous sessions

Synapse Q&A with PG

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.

What's New and Cool in Azure Synapse Analytics

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.

Reporting on 1.4B rows with Serverless SQL Pools

Building a dashboard using Serverless SQL Pools in a performant way

Azure DW and Power BI, reporting at the speed of light!

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.