Strategy
The Agenda
Agenda HomeSQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Theme
Theme
Wednesday 09:00
Analytics
Take an aerial view of your data with a deep dive into spatial analytics in Power BI
Analytics
First Class MLOps with Databricks
Analytics
An End-to-End Analytics Battle – Azure Synapse verses Microsoft Fabric
Analytics
Real-time Analytics & Machine Learning Models with Microsoft Fabric
Delivery
Deploy Power BI as Code
Operations
SQL Server Managed Instance: Migration and Security Best Practices
Operations
Table Partitioning Deep Dive
Operations
Your Performance Tuning Check List Extended session
Non-Technical
Make my report pop - using psychology, physiology, and design to create dazzling reports
Analytics
Introduction to Microsoft Fabric
Operations
What You Should Know About Always On Availability Groups
Operations
PostgreSQL for SQL Server Professionals
Wednesday 11:10
Non-Technical
Pilot's Guide to Self-Care: Navigating Mental Health in the Corporate Sky
Analytics
Flying High Amongst the Clouds with Fabric Warehouses
Analytics
Soaring Through Data: An Intro to Python for Data Analysis
Strategy
Power BI and Fabric Governance – Going from the skies to the ground!
Delivery
Enhancing Power BI with Conversational AI Integration
Delivery
A Picture is Worth 1000 Words: The Visual Learner's Introduction to DAX
Analytics
From the runway to the skies - Hands-On Real-Time Analytics
Strategy
When to Wave Off Landing Data in PaaS Services
Operations
Getting Started with Troubleshooting Query Performance
Operations
Simplified SQL modernization journey with Azure SQL Migration Tools: A deep dive
Data Leadership
Database of the future is here - Azure SQL Hyperscale deep dive
Delivery
SQL DB: a developer's catalyst
Non-Technical
Ask the Expert - Group A (Wed 11:10 to 13:00)
Wednesday 13:50
Analytics
Bridging Data Islands: Crafting a Semantic Search Oasis with Generative AI
Operations
Now Where Did THAT Estimate Come From?
Analytics
An Engineers Guide To Realtime Data Handling And Analytics
Analytics
Low flying planes and Realtime Data Analytics
Operations
Analysing and Resolving Deadlocks.
Delivery
Advanced data security implementation for Power BI
Delivery
Advanced dimensional modelling
Operations
Writing T-SQL code for the engine, not for you
Non-Technical
Communication Skills for the Technology Pro
Delivery
Live Power Platform and Fabric Build
Strategy
The importance of People Analytics in decision-making human resource management.
Operations
Modernize your SQL Data by starting cloud journey with SQL Server enabled by Azure Arc.
Non-Technical
Ask the Expert - Group B (Wed: 13:50 to 15:40)
Wednesday 16:00
Analytics
From zero to Kusto hero at 30.000 ft
Operations
Delta and Databricks vs SQL Server
Delivery
Creating a true self-service report | without exporting to Excel
Analytics
Flying into the Future: Using AI To Help Do Your Data Job
Delivery
Point-in-time analysis in Power BI and Fabric
Operations
Thwarting Disaster for SQL Server on Azure VM
Operations
Understanding Extended Events
Non-Technical
How to Deliver Strategic Goals
Operations
Mastering Azure SQL PaaS: A 100-Minute Journey from Novice to Expert
Non-Technical
I Saw Three Ships a Sailing: Mentorship, Sponsorship & Allyship
Analytics
Microsoft Fabric Power BI DirectLake Deep Dive
Operations
Azure SQL Managed Instance Deep Dive by Microsoft Product Group
Thursday 09:00
Additional
SQLBits 2024 Opening Keynote
Thursday 10:10
Delivery
Roche's Maxim of Data Transformation - By Example
Delivery
Mastering Power BI Design with User-Centric Frameworks
Strategy
Data Mesh vs Data Fabric - in Microsoft Fabric
Analytics
One dataset and three use cases with Microsoft Fabric
Strategy
Microsoft Fabric. Adoption, adoption, adoption: What gets measured, gets done
Strategy
More than 'just' a Data Catalogue - Boarding the Tour through the Microsoft Purview Universe
Delivery
What's new in Power Query in Power BI, Fabric and Excel?
Operations
Flying High with Data Engineering in Microsoft Fabric
Operations
Fly at Mach-speed with Azure SQL Managed Instance
Operations
A Deep Dive into DevOps Practices with Azure SQL
Operations
Hidden Gems in SQL Server 2022 Database Engine
Non-Technical
Ask the Expert - Group B (Thu 10:10 to 11:00)
Thursday 11:30
Analytics
Crafting Flight Simulations: The Art of Synthetic Data Generation
Delivery
Rapid Power BI Development with ChatGPT, Tips & Tricks
Analytics
Getting started with SparkML in Microsoft Fabric
Operations
Let me show you why data types still matter
Strategy
You Can't Govern Data You Don't Understand
Delivery
Pagination made easy
Operations
Intro to Azure Data Studio
Non-Technical
Put your own mask on first - mental health and wellbeing for your business
Non-Technical
Asking questions to get meaningful answers
Analytics
Flight of Insights: Navigating Data Turbulence with SQL Modelling and Visualisation
Analytics
Speeding Data Product Delivery from Model to Marketplace
Non-Technical
Meet the PG: SQL Leadership
Thursday 12:00
Operations
Streamlining Power BI with PowerShell
Analytics
New ways to optimize shared datasets in the Power BI Service
Strategy
Do Low Code projects need Change Management? Appsolutely!
Strategy
Behind the Hype - Architecture Trends in Data
Delivery
Data Modelling Showdown: Unravelling the Mysteries of Different Data Modelling Approaches
Delivery
A deep dive into Direct Lake
Delivery
Git off my lawn: Mastering Power BI Deployments with Git Integration
Analytics
Analytics Architectures on Microsoft Fabric
Operations
Discover what's new in Azure SQL Managed Instance through an exciting Demo Party!
Operations
What You've Been Missing in SSMS
Non-Technical
Meet the PG: Power BI with Patrick, Adam and Mohammad
Delivery
DAX Visual Calculations: What You Need to Know
Operations
Your Performance Tuning Check List
Thursday 13:40
Delivery
20 Power BI tips in 20 minutes
Non-Technical
Celebrating Diversity and Inclusion: Black History, Workplace Challenges, and Change
Strategy
Value of DevOps Release Process in Data Teams
Strategy
How To Actually Make Decisions When Architecting a Data Platform
Analytics
Fast and Efficent Text Analysis using Azure's Language Cognitive Service
Non-Technical
From Skopje to Seattle: My Journey in Tech
Operations
Relational or Non-Relational? Choosing the Best Database for the Task
Delivery
Power BI - Creating a M-agical Date Table
Non-Technical
How I Deal with Depression
Operations
Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
Operations
Managing the Challenge of Monitoring Growing, Multi-platform Database Estates
Operations
Flying High with Highly Available SQL Server Deployments
Non-Technical
Ask the Expert - Group A (Thurs 13:40 to 14:00)
Thursday 14:10
Operations
Soaring to New Heights with Accelerated Database Recovery
Operations
Here’s the execution plan … now what?
Delivery
Aggregations in Power BI
Delivery
Exploratory vs explanatory, when do you build which dashboard and how?
Operations
Time Series with SQL Server 2022
Non-Technical
How to be awesome at getting your next job
Analytics
Data Quality Revolution : The Fabric-OpenAI Approach
Strategy
Automating Power BI Governance: How dynamic security groups can solve 95% of your sharing needs
Strategy
Stand Fast - How Governance Can Save You a Fortune
Analytics
What's new on the Power BI Roadmap
Operations
Zero to Hero with SQL Server on Linux - DBA & Developers
Operations
DevOps Discovery: Navigating the Database Landscape
Non-Technical
Ask the Expert - Group A (Thu 14:10 to 15:00)
Thursday 15:20
Non-Technical
Using your existing knowledge, skills and experience to 'make it' in the Tech World.
Delivery
The Fundamentals of DAX Contexts
Strategy
What to look out for when migrating your data to the cloud; is it REALLY the right choice?
Analytics
Bring your contextual data to life with Microsoft Graph and Power Platform
Strategy
A Step-by-Step Guide to Building a Data-Driven Culture in Your Business Using Power BI
Analytics
Common Data Science Mistakes
Operations
Indexing Internals for Developers & DBAs
Analytics
Contextualizing timeseries data with graphs
Operations
Come see your SQL Perfmon in the cloud
Operations
Building AI ready applications
Security and Governance
Data Testing with HEDDA.IO
Non-Technical
Meet the PG: PostgresSQL in Azure
Operations
You're a Power BI Admin? Let's get your threads aligned for Fabric!
Thursday 16:20
Non-Technical
Desk Pilots: Navigating a Healthy Flight Plan for Your Posture and Well-being
Strategy
Mastering Fabric: Workspace Governance and Organization
Operations
Azure Infrastructure - What Not to Do
Delivery
How to handle Blanks and Nulls in Power BI
Non-Technical
Winging It: My Neurodivergent Non-Technical Journey into Data
Delivery
Take off with Tabular Editor
Strategy
When a platform isn’t enough: Building an experimentation culture
Delivery
Connect Excel to Power BI data with Live Connected Tables
Analytics
Copilot Studio: Guiding Your Chatbot Takeoff with AI Aviation!
Non-Technical
Meet the PG: Data Platform Security
Data Leadership
Empowering Women in Data: Navigating Challenges, Seizing Opportunities
Thursday 16:50
Operations
Flight Plan for Data Security: Safeguarding your Dataset with Dynamic Object-Level Security
Delivery
Avoiding Turbulent Skies: Power BI Security Strategies for a Smooth Flight
Non-Technical
Nose-Dive Narratives: Slide Karaoke 2024
Delivery
Lessons learned: Governance and Adoption for Power BI
Analytics
How to get started with MLOps in Azure Databricks
Strategy
Find your PII reports and make your data safer
Operations
Navigating Microsoft Fabric - Choosing the Right Workload for Your Needs
Data Leadership
Accelerate your Oracle & Mainframe Modernization journey to Azure SQL
Operations
Harnessing Data Science and AI in Fabric
Operations
Defending the Cloud: Securing Your Microsoft Data Workloads
Non-Technical
Ask the Expert - Group B (Thu 16:50 to 17:40)
Analytics
Generative AI: Concepts, Tools, and Applications for Data Professionals
Thursday 18:00
Non-Technical
User Group Leaders Get Together
Analytics
Data Toboggan - Ask the Fabric Experts
Analytics
London Fabric User Group - SQL Bits Special - Ask Me Anything Panel
Friday 09:00
Non-Technical
Mental Health Monologues
Strategy
An Evolution of Data Architectures - Lambda, Kappa, Delta, Mesh & Fabric
Analytics
Zero to Lakehouse in Microsoft Fabric
Operations
Disaster Recovery Strategies for SQL Server
Operations
Building Tomorrow's Warehouse Today: Modern Data Warehouse Modelling Insights
Analytics
Models in Flight: Elevating semantic modelling with Spaceparts Co and Tabular Editor 3
Data Leadership
Workflows of Highly Functional App & Data Engineering Teams
Operations
What's new in SQL Tools
Analytics
Your first flight with Data Factory in Microsoft Fabric
Operations
Modern models of managing database fleets in Azure PaaS.
Non-Technical
Ask the Expert - Group B (Fri: 9:00 to 9:50)
Operations
Mastering TempDB
Delivery
The Untruthful Art - Five Ways of Misrepresenting Data
Friday 10:10
Delivery
Get a Load of this - Realistic Load Testing for Power BI, explained!
Operations
How to Conduct a Transact-SQL Code Review
Delivery
The Hitchhiker's Guide to navigating Power BI
Analytics
Scanning the skies above SQLBits - Realtime streaming of flight data with Microsoft Fabric
Operations
ACID in SQL Server: what it is, how it works, and how to live more adventurously.
Strategy
Data Leadership: Navigating Security, Governance, and Ethical Decision-Making in the Digitial Skies
Analytics
Turbo charge your Data Science workflow with Microsoft Fabric
Security and Governance
Fabric security: everything you need to know!
Analytics
Optimising DAX fusion - Power BI
Data Leadership
The Microsoft Data Leadership Panel
Data Leadership
Lessons Learned: Insights from 30 Years in Cloud and AI/ML Integration
Non-Technical
Ask the Expert - Group B (Fri - 10:10 to 11:00)
Operations
Writing T-SQL code for the engine, not for you "more demos" by popular demand
Friday 11:30
Operations
How to automate your data actions through Data Activator
Delivery
Power BI meets UX Design: The Design Process
Non-Technical
Would your business pass pre-flight information security checks?
Delivery
How to reduce costs & build new analytics capabilities in Power BI with Power Automate
Operations
Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
Analytics
Navigating the Skies of Data: A Flight Through Feature Stores
Delivery
Using ALLEXCEPT or ALL/VALUES?
Non-Technical
Setting yourself up for success when submitting to present
Operations
Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
Operations
Shift-Left: A DevOps and Database Story
Analytics
How will AI transform your data platform?
Non-Technical
Meet The PG : SQL Server in hybrid and multicloud environments
Data Leadership
Data Modelling is not a one man job!
Friday 12:00
Operations
Managing replication with dbatools
Delivery
Mastering Rapid Power BI Development with ChatGPT: A Deep Dive
Delivery
Upgrade to First Class with Calculation Groups for Power BI
Delivery
Power BI dataflows: building your own refresh orchestration
Strategy
Navigating Data Governance in the Age of Generative AI
Delivery
Powering Up Your Power BI Development Workflow with Microsoft Fabric Notebooks
Non-Technical
Saying no is OK
Security and Governance
Prepare for Fabric with Power BI Governance, Auditing and DR
Analytics
Analytics at the speed of Direct Lake
Analytics
Scale your business in real-time using ML in Microsoft Fabric Real-time Analytics
Analytics
Fabric Product Group - Ask us Anything
Analytics
Data tiering using data Virtualization in SQL
Non-Technical
Meet The PG: All things Azure SQL DB
Friday 13:40
Non-Technical
Gender 101
Strategy
The Swiss Cheese Security Pattern
Operations
An introduction to Extended Events
Strategy
End-to-end data validation strategies in Microsoft Fabric
Operations
Dealing with Very Large Tables in SQL Server
Additional
Fabric Power Hour
Delivery
JSON - a first class citizen in Azure SQL DB
Security and Governance
Navigating Modern Authentication in SQL
Operations
More for less: Cost optimizing your Azure SQL databases
Operations
Advancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance
Operations
Making the SQL Query Processor Work for you
Operations
The New Database Landscape - Revealing Shifts and Charting the Next Horizon
Non-Technical
Ask the Expert - Group A (Fri, 13:40 to 14:30)
Friday 14:50
Operations
A Beginners guide to Query Store
Delivery
Level-Up Power BI Dashboard Storytelling with DataViz Tools
Analytics
Data Linkage Options: MDM vs Splink (PySpark)
Operations
Microsoft Copilot Demystified: A 20-Minute Introduction
Non-Technical
Boosting Your Blog's Visibility: Strategies to Drive More Traffic and Engagement
Strategy
Microsoft Fabric and Data Mesh - a perfect fit?
Delivery
Treat your reports as communication tools
Non-Technical
Fueling Your Future: Embracing the Rewards of Data Platform Community Involvement
Operations
Introducing your Databricks Flight Assistant
Analytics
Azure SQL MI & Fabric Fusion: A speed-session
Operations
Getting Started Quickly with DB DevOps
Operations
Mastering the Hybrid Environment: Essential Strategies for DBAs
Non-Technical
Meet the PG : SQL Server on Linux/Containers
Friday 15:20
Non-Technical
Burnout: A personal journey to the bottom and back up again
Strategy
Govern your data in Fabric
Delivery
Understanding window functions in DAX
Delivery
Prepare for Takeoff: Navigating Power BI Developer Mode - Is the Journey Worth the Flight?
Operations
Unlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
Strategy
Data Mesh - a hot air balloon?
Analytics
Exploring the Microsoft Semantic Link for improved data science
Operations
Infra as code, control it from the tower.
Non-Technical
The future of accessibility - lessons from research
Analytics
GitHub Copilot for SQL Development: Integrating the Power of AI into Database Development
Analytics
Driving alerts and actions on your data
Operations
SQL Server and Windows Server Better together on Azure
Non-Technical
Meet the PG: Developers
Friday 16:20
Analytics
Unlocking Azure OpenAI: A 20-Minute Introduction
Strategy
Be more responsible around AI - Less Bias, More Ethics
Delivery
Field Parameters or Personalize Visuals – Choosing the Right Aircraft for Your Self-Service Journey
Operations
Top 10 transactional database mistakes, and how to avoid them
Operations
Data Lakehouse Vs Data warehouse in Fabric, which is right for you
Operations
Snowflake concepts & architecture
Strategy
The Future of Data Analytics: Adapting to the Shifting Technology Landscape
Data Leadership
Augmenting Power BI Adoption with Center of Excellence team
Delivery
Effortless Low-Code Data Testing
Data Leadership
Challenge to Triumph: Exploring Real-World High Availability in SQL Server Environments
Non-Technical
Ask the Expert - Group A (Fri, 16:20 to 16:40)
Data Leadership
Should I become a manager in IT
Operations
Relational or Non-Relational? Choosing the Best Database for the Task
Friday 16:50
Delivery
Demystifying Power BI Variables: A Comprehensive Guide to Understanding DAX and M Variables
Operations
When to stop tuning a query
Delivery
Let End Users Drive: Empowering User Control in Power BI Reports
Strategy
From DevOps for data to DataOps
Non-Technical
Safe Landings: Self-care In A High Intensity Technological World
Operations
Better ETL with Managed Airflow in ADF
Analytics
Navigating the Skies of Open AI: Perfect Your Grounding for a Smooth Landing
Analytics
Decide on the fly: Real-Time Analytics in Microsoft Fabric
Operations
Stabilizing Performance with Query Store
Operations
Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
Analytics
Extendable by Design: Building Generative AI Apps with Postgres and Vector Storage and Azure AI
Non-Technical
A Data Engineer, Scientist and Analyst Walk Into a Bar
Saturday 09:00
Non-Technical
Accessibility is for everyone, including you!
Strategy
From SSIS to Synapse to Fabric - A Data Architects Case Study
Analytics
The Next Frontier: Azure OpenAI Models and the Arrival of GPT-4
Strategy
Air Traffic Control (Data Governance) with Databricks Unity Catalog, tips, tricks and best practices
Analytics
The data runway: Soaring to New Heights with Fabric Data Activator
Delivery
Power BI and Big Tables
Operations
Azure SQL DB Data Portability : Mirroring, CDC, Export/Import and DataSync
Operations
HADR on SQL Server on Azure VMs: Everything you Need to Know
Security and Governance
Confidential development with Always Encrypted using enclaves
Operations
SQL Server Containers & Kubernetes - Going to Production!
Operations
Best Practices in PostgreSQL Tuning: Navigating Key Performance Bottlenecks in the Cloud
Non-Technical
Ask the Expert - Group A (Sat, 9:00 to 9:50)
Saturday 10:10
Non-Technical
Social Engineering: Hacking People
Non-Technical
Anyone can be an alphabet soup ally
Operations
SQL Server 2022 Performance Enhancements
Strategy
Building a High Performing Impact Center of Excellence (COE) in Microsoft Fabric
Non-Technical
Knee-Deep In Tech Live @ SQL Bits
Operations
Did you know that you should version control your solution – even the smallest ones?
Delivery
Star Schema ALL the things! But why?
Operations
Assessing and Optimize Enterprise SQL Server Environments
Delivery
Fabric Direct Lake Deep Dive
Operations
Deep {sky}diving into Data Factory in Microsoft Fabric
Operations
Perfecting business continuity for Azure SQL DB
Security and Governance
Get Rid of Your Data Quality Problems
Non-Technical
Meet the PG: SQL tools
Saturday 11:30
Delivery
Power BI Quiz Extravaganza
Analytics
Website Analytics in My Pocket Using Microsoft Fabric
Non-Technical
How to Run Code Clubs for Neurodiverse Children
Non-Technical
The Critical Role of Creativity in Technical Professions
Operations
Elevating SQL Server Performance with Query Store Hints
Delivery
Unlocking Synergy: PowerBI and PowerApps Collaboration for Data-Driven Decision-Making
Operations
Understanding Zero Trust security
Operations
SQL Horror Stories
Operations
Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 1st Leg
Analytics
The SQLBits Website ChatBot with Copilot Studio: How I built the chatbot for this events website)
Non-Technical
Meet the PG: Azure SQL Managed Instance
Data Leadership
Should I become a manager in IT
Non-Technical
We Are All in Sales
Saturday 12:00
Additional
Keynote by the community - Impactful Journeys in the Data Platform Community and inspiration for you
Saturday 13:40
Analytics
Unraveling the Web of Relationships: Understanding Graph Data
Delivery
An Introduction to Calculation Groups in Power BI Desktop
Analytics
Timespan Fact Tables
Delivery
Let's define Entities and attributes for tabular models in 20 minutes.
Operations
Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory
Strategy
Power BI Culture: Governance as a gateway to adoption, not a barrier.
Non-Technical
What we’ve learned running a YouTube channel (so far)
Operations
Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg
Delivery
Effortless Low-Code Data Testing
Non-Technical
Meet the PG: SQL Migration
Saturday 14:10
Strategy
What does Microsoft Fabric mean for a Finance/Business Analyst?
Delivery
Best practices for developing Power BI reports
Strategy
Do those numbers look right? How to ensure quality, and avoid inaccuracies in your data insights.
Delivery
Power BI meets UX Design: Creating accessible, intuitive and visually appealing reports
Operations
Maximizing Database Performance With Isolation Levels
Analytics
Calculation Groups & C# - The Perfect Couple
Operations
From substitutions to public keys - an introduction to cryptography
Operations
Business continuity of on-prem SQL Servers using Azure services through Arc
Operations
SQL Server on Azure VM - Configuring for Price-Performance
Analytics
The What and the Why of Microsoft Fabric Real-time Analytics
Non-Technical
Meet the PG: Data Integration
Operations
Load Testing Fabric - What is our hold capacity?
Saturday 15:20
Delivery
Power Query in 20 Minutes - How it Works
Strategy
The Decentralized Data Access Revolution
Analytics
A Deep Dive into Analytics Delivery Behind one of the Largest North American Banking Acquisition..
Non-Technical
Navigating Tech Job Interviews: Asking the Right Questions About Work Culture
Saturday 16:00
Delivery
Visualizing Data for Non-Data Experts: Making Reports Accessible to All
Analytics
Slaying the Dataverse dragon with copilot
Strategy
Sensitivity labels - what do they look like
Operations
Python in Fabric for Data Engineers: all you need to know
Non-Technical
Thriving with ADHD in Tech: Unleashing the Data Analyst Superpowers Within
Delivery
Introducing Explore - a new way to explore data right within Power BI.
Operations
Operational insights in your hybrid-cloud multi-cloud SQL inventory outside azure using Arc SQL Serv
Analytics
How to design and build AI applications with vector search using Azure OpenAI & Azure Cosmos DB
Analytics
A Deep Dive into Microsoft Fabric Data Warehouse
Operations
SQL Modernization Journey with Tools, Assets & Migration Best Practices
Non-Technical