SQLBits 2024

From Beginner to Certified: A Fabric Analytics Engineer Workshop

In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam.

In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam. Attendees for this session will learn about planning, implementing, and managing a data analytics environment; preparing and serving data; implementing and managing semantic models; and exploring, querying, and analyzing data.

We’ll explain how to identify the requirements for a data analytics solution, such as the components, features, performance, and capacity SKUs; how to manage the analytics development lifecycle; how to create objects in a lakehouse or warehouse by using a data pipeline, dataflow, or notebook; how to transform your data and optimize performance; design, build and optimize enterprise scale sematic models and finally explore and analyze your data using SQL. This workshop will prepare you for completing the Fabric Analytics Engineer Cloud Skills challenge and receive a 50% off voucher for the certification exam.

Mark Pryce-Maher's previous sessions

From Beginner to Certified: A Fabric Analytics Engineer Workshop

In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam.

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!

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.

Bradley Ball's previous sessions

From Beginner to Certified: A Fabric Analytics Engineer Workshop

In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam.

Indexing Internals for Developers & DBAs

This is a dive into how indexes work within SQL Server. The goal of this session is for attendees to gain a greater understanding of how Indexes work and how to use them to gain performance.

What we’ve learned running a YouTube channel (so far)

This session is suitable for anyone who is interested in starting or growing their own YouTube channel, or who wants to learn more about the YouTube ecosystem.

Soft Skills eat Technical Skills for Breakfast

Over the years I’ve faced some very difficult situations. Talking down angry customers, de-escalating tense situations, and focusing on the right outcomes. There are a few key books that cover these concepts. In 20 minutes I will tell you what they are, why they are important, and how they saved me more than a few times.

The Most Powerful Azure Service You’ve Never Heard Of

Join Patrick Leblanc from the Power BI CAT team, Josh Luedeman, and Bradley Ball from the Azure FastTrack PG as we talk about the most powerful Azure Service you’ve never heard of. If only you knew the name of the service. Come to this session, and you’ll never forget it!

Migration to Azure Customer Experiences & Best Practices

How to create a roadmap to migrate to Azure, best practices, and using Azure Migrate to start, & customer stories

Inside the Query Optimizer

In this session discuss the query optimizer, the individual phases of optimization, and how understanding these items can impact our queries in a positive way

BI DBA Performance Tuning

Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well