Tuesday 9:00 AM - 5:00 PM · Room 320-321
Intro to T-SQL Data Manipulation Language
Jared Kuehn
Sr. Data Engineer @HBS by day, Storyteller by night
From early database management systems to modern data platforms like Microsoft Fabric, SQL has withstood the test of time. This language can be powerful in its navigation of data relationships, calculation of detailed or aggregate values, or adjustment of records stored in tables. All of these capabilities fall under the term Data Manipulation Language (DML). This language can enable many data practitioners, from engineers and citizen developers, to harness their data and bend it to their needs.
Suppose you have not had the opportunity to learn SQL DML and would find use for your work. This introductory course to Microsoft's version of SQL, called Transact SQL or T-SQL, is a great place to start. Join this workshop to learn T-SQL DML from the ground up, starting with the SELECT statement and all of its primary clauses.
Tuesday 9:00 AM - 5:00 PM · Room 342
ETL, KQL, and RTI: Harnessing Data in Motion with Microsoft Fabric
Christopher Schmidt
Principal Program Manager, Microsoft
Matt Gordon
Lead Data Architect at BJSS
Real-time Intelligence in Microsoft Fabric brings us into the next generation of data movement and event-driven architecture. As the arms race of cloud data platforms continues, make sure you know the weapons at your disposal so you and your company are fully equipped for the future - because the future is not far away. While you may be familiar with RTI’s streaming data capabilities, did you know it can be an integral part of your ETL architecture? While you may have heard of KQL, did you know it can do data visualization? While you may have heard of RTI, did you know it can help you monitor your entire data estate?
Join RTI product group members and Microsoft Data Platform MVPs for a full day of learning. Takeaways include:
- Loading a full medallion architecture using RTI components
- Use case by use case breakdown of the components of RTI and how customers are using them today across their data estate
- Data visualization and trend analysis with KQL
- Monitoring your entire data estate using Real-time Intelligence in Microsoft Fabric
Tuesday 9:00 AM - 5:00 PM · Room 343
Data Science Jump Start using Microsoft Fabric
David Patrick
MCT, MVP @ www.DSAINC.com
Data scientists can manage data, notebooks, experiments, and models while easily accessing data from across the organization and collaborating with their fellow data professionals using Microsoft Fabric.
In this module, you'll learn how to understand the data science process in Fabric, train models with notebooks in Fabric and track model training metrics with MLflow and experiments.
Tuesday 9:00 AM - 5:00 PM · Room 344
Design a Well-Architected Fabric Solution: A Medallion First Approach
Reid Havens
Founder | BI Evangelist - Havens Consulting
Steve Campbell
Co-Founder @ Analytic Endeavors, MVP
Transform your data solutions with a streamlined Medallion Architecture using Microsoft Fabric. This session is tailored for professionals familiar with Power BI and basic dataflows, providing a step-by-step guide to implementing Bronze, Silver, and Gold layers for a scalable and maintainable pipeline. Learn how to evolve an unstructured dataflow and semantic model into a comprehensive architecture. Familiarity with Python or SQL is a bonus but not required.
Modules: • Overview of Medallion Architecture: Gain a clear understanding of Warehouses and Lakehouses, their role within Microsoft Fabric, and how they enable Medallion Architecture. • Understanding OneLake: Dive into OneLake and explore its foundational storage structure, including Delta tables and Parquet. Understand key features like columnar storage, Delta optimizations, and performance enhancements through simple, no-code explanations. • Feature Showdown: Compare and contrast key tools in Microsoft Fabric, such as SQL vs. Spark, Notebooks vs. Dataflows vs. Pipelines, and Warehouses vs. Lakehouses, to determine the best fit for your scenarios. • Well-Designed Architecture & Best Practices: Learn about GIT integration, monitoring techniques, and actionable best practices for designing scalable and maintainable data architectures.
Labs: • Build a Lakehouse and create a Medallion Architecture pipeline. • Extract raw data using Pipelines (Bronze). • Clean and transform data with Spark Notebooks (Silver). • Add business logic with T-SQL (Gold). • Create orchestration and monitor pipelines for optimal performance. • Bonus Lab: Create and manage a semantic model and integrate it with GIT for version control.
Tuesday 9:00 AM - 5:00 PM · Room 348
Execution plans explained
Hugo Kornelis
I make SQL Server fast (.com)
You probably have some tricks up your sleeve for dealing with slow queries. Index the columns in the join and where. Rewrite the WHERE clause to enable index usage. Tinker with the join order, or perhaps even break up the query in smaller parts. Those tricks work. Sometimes. Not always. And when they don't, your job suddenly gets frustrating!
Sometimes, you wish you knew WHY a query is slow. So that you can target your changes exactly right, at precisely the root cause of the slowness. And the good news is, there already exists a way to find the root cause of bad performance. You "only" need to learn to work with execution plans
In this full-day workshop, you will learn everything you need. You will learn what execution plans are, and where you can find them. You will learn the basics of how to read execution plans. And you will learn all you need about all of the commonly encountered operators in execution plans: what their function is, how they operate, and what effect that has on performance.
In short: After attending this workshop, you will know how to obtain an execution plan for a slow running query, and you will know how to look at that plan and find the spot where it hurts, so that you know what to do to fix the performance issue.
Regardless of whether you have never seen an execution plan before, or whether you already have experience working with execution plans, this workshop will teach you how to look at an execution plan and then KNOW why your query is slow ... and what you can do to fix that!
Tuesday 1:30 PM - 5:00 PM · Room 340-341
Maximize efficiency in your data-driven projects by leveraging AI and Copilot technologies.
Prabhjot Kaur
Microsoft
Prashant Atri
Microsoft
Tammiraju Prasanth
Technical Director, Quadrant Technologies
In the Total Economic Impact™ of Microsoft Fabric study, the composite organization based on data from four companies using Fabric showed an increase in data engineer and data scientist productivity of up to 50%, plus a 15% increase in business analyst productivity.
In this workshop, we will explore the transformative potential of various copilots, AI services within Microsoft Fabric. It covers live demos and hands on experience on Microsoft Fabric Copilots, AI Skills, Fabric integration with AI and GenAI services.
Participants will thoroughly explore the Copilot maturity framework and learn strategies to overcome adoption challenges, enabling customers to maximize the benefits of Copilots.
Tuesday 1:30 PM - 5:00 PM · Room 347
Query Store and Azure SQL Copilot, who is the fairest in the land?
Jose Manuel Jurado Diaz
Microsoft, Escalation Engineer, Azure SQL Database and Manage Instance
Juan Moreno Romo
Microsoft, Support Escalation Engineer, Azure SQL Server Hybrid
Query store + Azure SQL Copilot, which is the baddest query in my instance.
On-premises or Azure, it doesn't matter, Query Store will help you finding out how your queries are performing.
Get your performance to the next level knowing how to digg into Query Store data. Understand how it works, and how you can use Query Store data to solve performance issues and detect problems before they create a situation.
Do you want to know how to mine Query Store: plans, queries? Learn how to get the best of it in an instance with several databases.
We will also discuss the available options for troubleshooting using Azure SQL Copilot
Based on Microsoft support experience.