SQL vs. Fabric? Why Not Both! A Practical and Entertaining Guide for All

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!

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.

The Cloud Workshop for the SQL Professional

Are you thinking, exploring, migrating, or have migrated from SQL Server to Azure? Come translate your SQL Server skills to the cloud in an interactive, hands-on workshop. (In-person only)

Welcome to the world of SQL Copilots

Microsoft is building a new experience of an AI companions called Copilot that are transforming how people work, write code, and solve problems faster. In this session come learn the latest innovations in SQL Copilot technology including GitHub Copilots for developing code and assisting with the T-SQL language. In addition you will get the latest look at Copilot technology to assist you in using and managing SQL in Azure. We will have plenty of demos in this session so come in and get ready to learn the new world of AI companions with SQL.

Come see your SQL Perfmon in the cloud

Come learn the latest innovations for monitoring technologies for SQL Server and Azure SQL

The Microsoft Data Leadership Panel

TBD

SQL Server and Windows Server Better together on Azure

Join us to learn how you can reap more technical and business benefits by running Windows Server and SQL Server on Azure. In this session you will get a first look at Windows Server vNext and innovative technologies for SQL Server including new monitoring and AI experiences.

Debugging SQL Server

Have you ever thought about how Microsoft uses the Windows Debugger with SQL Server? In this session I'll show you some advanced scenarios and how we debug SQL Server using a combination of the debugger along with instrumentation in the engine and other tools. This is an extremely deep level session and not for the feint of heart. You will get the best out of this session if you already have a solid understanding of the SQL Server engine.

The SQL Leadership Panel

Bring all your questions about the strategy and future of Microsoft SQL to the leadership team of Microsoft in a panel hosted by Bob Ward, Principal Architect at Microsoft

SQL Server 2022 and the Wheel of Power

Come learn about the latest major release of SQL Server and the "wheel of power" with capabilities across hybrid, built-in query intelligence, core database engine, data virtualization, and T-SQL. This is one of the most power-packed set of new capabilities in a SQL Server major version ever and this session is the one you will want to attend to learn about all of them.

SQL Server 2022 hidden gems

SQL Server 2022 has many new capabilities for the database engine across security, performance, and availability. In this demo-heavy session learn about new enhancements that you may not be familiar with that have real practical value. You will learn how these new features work and understand how they can solve real-world problems.

The Kingdom of AdventureWorks Calls for Aid

The Kingdom of Adventure works has been besieged by Monsters from the Cave of Despair – Can the able Party of Engineers save the Kingdom from the horrors of security attacks, degraded performance, stability and resiliency using the power of the Microsoft Intelligent Data Platform? Come to see how they battle the foe with data and analytics, and what the Campaign holds for our trustworthy band of heroes!

Platform Innovations with SQL Server 2022 + Intel

Get ready for a journey through the cutting-edge platform advancements in SQL Server 2022! In this must-attend session, our Microsoft and Intel subject matter experts will take you on a tour of the latest platform innovations, demonstrating the new capabilities and solutions that are driving the next generation of database administration. Discover how Intel technologies are powering the SQL Server experience and hear about the latest hardware advancements from Intel that are shaping the future of the platform space. We'll dive into the backup compression improvement enabled by SQL Server 2022 and Intel® QuickAssist Technology (QAT). You'll learn how this integration allows for offloading of compute overhead, reduction of CPU usage, improvement of backup completion times, and reduction of storage consumption. We will also discuss the latest Intel hardware and where we are going next with SQL Server and Intel technologies. We will also cover Intel AVX-512 (Advanced Vector Extensions 512-bit) technology designed to accelerate the performance certain computing tasks, allowing the processor to perform multiple operations in parallel. SQL Server 2022 can leverage AVX-512 instructions to improve the performance of certain query operations by offloading compute-intensive operations to the processor. By utilizing AVX-512, SQL Server can take advantage of the improved parallelism and faster performance offered by modern processors, providing customers with faster query execution times and improved overall performance by offloading some of the work from the CPU to the processor. Don't miss your chance to be at the forefront of the platform revolution and discover the latest advancements in SQL Server and Intel technologies!

Introducing SQL Server 2022

SQL Server 2022 is here! In this session, I’ll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability including SQL Server Ledger and Intelligent Query Processing.

How to Build Secure, Scalable, and Highly Available Applications with Azure SQL Database

This session will show you how to develop your code with .Net and C# using the latest Microsoft tools to launch quickly in the cloud while ensuring you meet the requirements of security, performance, and availability of your application. You will learn how to ensure your application is optimized with Azure SQL Database including Serverless and Hyperscale tiers, Azure Active Directory, retry and error handling, connection abstraction, automated indexing, and Intelligent Query Processing.

SQL Server 2022: The hybrid data platform

SQL Server has included capabilities to connect to the cloud for years. SQL Server 2022 moves hybrid to the next level with features to connect you to Azure for disaster recovery, near real-time analytics, and security. Come take a deep dive in this session for all the existing and new hybrid capabilities of SQL Server. See how to easily setup a managed disaster recovery site in the cloud with Azure SQL Managed Instance.

AMA with the Microsoft Engineering team hosted by Bob Ward

Come get your questions answered live on stage by members of the Microsoft engineering team. This will be a fun and interactive session hosted by Bob Ward. We will take questions live from the audience plus those who are connected virtually.

SQL Server 2019: The Modern Data Platform

SQL Server 2019 represents the next evolution of the leading database platform in the industry. In this session, we will cover the complete set of features and capabilities in SQL Server 2019.

Inside SQL Server on Kubernetes

In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. This session assumes a fundamental knowledge of both SQL Server and containers.

SQL Server to Azure SQL: Performance and Availability

Translate your existing SQL Server performance and availability skills and apply them to Azure SQL.

Inside SQL Server 2019

Come learn all the new capabilities of SQL Server 2019 directly from the Microsoft engineering team. This session will provide the strategy behind SQL Server 2019 as well as a deep dive into all the new features and how they can help you modernize your data estate with SQL Server.

Inside SQL Server Containers

Containers are the new virtual machines. They present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work, how SQL Server runs in them, and how they work in environments such as Kubernetes

Inside SQL Server 2019 Polybase

SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.

Experience SQL Server on Linux and Containers

SQL Server 2017 is all about choice. Choice for developers to run on Windows, Linux, or Containers. In this session we will show you the experience of running SQL Server on Linux and Containers including a behind the scenes of how we built it.

Experience SQL Server 2017: The Modern Database Platform

Looking to upgrade your SQL Server? This session will discuss all the new features and capabilities of SQL Server 2017 including SQL Server on Linux, Docker Containers, Graph Database, Python, Adaptive Query Processing, Automatic Tuning, and HADR.

Adaptive query processing in SQL databases

Come learn about the new adaptive query processor in SQL Server 2017 and Azure SQL Database. We will discuss how this feature works, how it can benefit your application and queries, and the future of intelligent query processing.

SQL Server 2016 It Just Runs Faster

Come take a deep dive and behind the scenes look at why SQL Server 2016 "Just Runs Faster" with little or no application changes.

Keep Your Environment Always On with SQL Server 2016

The Microsoft Tiger team will showcase the environments that help you keep your environment Always On

Deploying SQL Server with Microsoft Azure Virtual Machine

Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how

Windows Azure SQL Database Troubleshooting

While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.

Fabric security: everything you need to know!

Learn how Microsoft Fabric makes sure your data is secure. Did you know for example that all data is encrypted by default? Or that you can configure MFA for all your users? Fabric offers many of these possibilities and more out of the box without most of us knowing! In this session you will learn everything to convince your security team

Understanding Zero Trust security

In this session we will look at what Zero Trust principles are. Zero Trust is the modern way to apply security. It assumes a breach, verifies every user, and enforces least privilege, giving users access only to the private applications and resources they need. It no longer secures the perimeter (the network boundaries) which doesn't scale in the modern world. We will see how it applies to your Microsoft services like Microsoft Fabric too.

The Power BI Engine in 20 minutes

In this action-packed session we will investigate how the Power BI engine works. From loading the data through M to its fast vertipaq engine.

The Power BI secret sauce: Security and governance

Learn how to convince your security team that Power BI's security and governance features are secure. It's baked in features that allow your org to upload your upload your data to the cloud and enable self-service in a safe and managable way.

Debugging common DAX and Model performance issues

In this session, we will explore real world DAX and Model performance scenario's. These scenarios range from memory pressure to high CPU load. Watch as we will dive into the model and improve performance by going through concrete examples.

Microsoft Power BI Premium: Building enterprise-grade models

Power BI Premium enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through Microsoft Power BI. The session will focus on performance, scalability, and application lifecycle management (ALM).

Power BI security deep dive

One hot topic with Power BI is security, in this deep dive session we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored andleverage additional Azure services to secure it even more.

Understanding the Power BI data model

In this session we will look at all the important topics that are needed to get your Power BI modelling skills to the next level. We will cover the in memory engine, relationships, DAX filter context, DAX vs M and DirectQuery.

Developing For PowerBI

The Power BI Preview service offers developers a rich API service for anyone to interact with Power BI programmatically and create applications for Power BI. In this session we will introduce you to the Power BI developer story

Building Great Models for Crescent

SQL Server Code Name Denali Reporting Services will include Project Crescent for visualizing, interacting with and presenting data. Project Crescent. Come to this session to see how to make the most of this new tool.

Microsoft Database Innovations: SQL Server, Azure SQL, open-source and beyond

For over 30 years, Microsoft has been leading the charge with innovations in the database spaced based on YOUR feedback and requirements. In this session, learn about the more recent innovations and customers, and how we're aiming to build the best operational database on the planet, anywhere you are. Database services covered include SQL Server, Azure SQL, Cosmos DB, Azure Database for PostgreSQL, MySQL, and MariaDB, and Azure Arc.

AMA with the Microsoft Engineering team hosted by Bob Ward

Come get your questions answered live on stage by members of the Microsoft engineering team. This will be a fun and interactive session hosted by Bob Ward. We will take questions live from the audience plus those who are connected virtually.

SQL Server to Azure SQL: Performance and Availability

Translate your existing SQL Server performance and availability skills and apply them to Azure SQL.

Azure SQL: What to use when

Learn what to use when for various flavors of Azure SQL

SQL Server ML End-to-End

Learn how Machine Learning Services in SQL Server is a powerful end-to-end ML platform for customers, on both Windows and Linux. Come learn about the unique value proposition of doing your entire machine learning pipeline in-database – right from data pre-processing, feature engineering, and model training to deploying ML models and scripts to production in secure and compliant environment without moving data out. 

Leveraging Prebuilt AI Models in SQL Server 2019

In this session, you'll learn about the various prebuilt AI/ML models that are available for your consumption through Microsoft's Cognitive Services. Additionally, you'll see examples of how these prebuilt services can be leveraged with SQL Server 2019.