Speaker

Bradley Schacht

Bradley Schacht

Principal Program Manager, Microsoft Fabric CAT

Saint Augustine, Florida, United States

Actions

Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Jacksonville, FL. Bradley is a former consultant, trainer, and has authored 5 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. Bradley gives back to the community through speaking at events such as the PASS Summit, SQL Saturdays, Code Camps, and user groups across the country including locally at the Jacksonville SQL Server User Group (JSSUG). He is a contributor on SQLServerCentral.com and blogs on his personal site, BradleySchacht.com.

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Server
  • Azure Synapse
  • Microsoft Power BI

Microsoft Fabric: Data Warehouse vs. Lakehouse

Microsoft Fabric is a new data analytics offering from Microsoft that combines Power BI, ETL, data warehousing, data lakes, Spark, and more into a single connected platform. The challenge with so many options is choosing the right tool for the job. In this session, you will learn about the similarities and differences between Fabric Data Warehouse and Fabric Lakehouse so you can make an informed decision about architecting your next analytics solution. We will talk about data loading, data engineering/cleansing, reporting, and integration with the broader Microsoft platform.

Microsoft Fabric: An Introduction to Mirroring Azure SQL DB

What ever Analytics architecture you have it starts with ingesting data. Perhaps forklifting data is the team you would use. It equates to loading data. We have to get Data from our OLTP, Online Transaction Processing, database to our medalian architecture or data warehouse or lakehouse? Well not any more.

In Microsoft Fabric we introduce the concept of mirroring a database, real-time replicating the database into Microsoft Fabric. No longer to you need to create pipelines, figure out the secret to incremental loading data, you turn this on and Microsoft Fabric loads the data for you. In this session we will cover the basics from set up to configuration, and then look at how the service works end to end!

Microsoft Fabric Data Warehouse Deep Dive

With the introduction of Microsoft Fabric comes a new, more efficient query engine based on the Polaris distributed SQL engine. We will dive deep into the internals of Fabric data warehouse's logging, storage, compute, and query layers. You will see the impact statistics and table definition have on an execution plan, look at the way nodes are dynamically allocated and dropped for maximum query performance, and see how we deliver top performance over files stored in the opensource Delta format. At the end of this session, you will walk away with best practices for designing your data warehouse tables properly from the beginning, know how to keep it performing great, and have a better understanding of what the SQL engine is doing in the background when running in high concurrency scenarios. Best of all, the information you will learn will also apply to querying Fabric's lakehouse using the SQL analytics endpoint.

Introducing Microsoft Fabric: The All-in-One Analytics Solution

The world is awash with data and it is up to data professionals to make sense of it all. In May 2023 Microsoft announced the next generation of analytics: Microsoft Fabric!

Fabric is a complete end-to-end analytics platform bringing together Azure Data Factory, Azure Synapse, and Power BI in a single location and more deeply integrated than ever. It’s built on a SaaS platform which helps deliver innovation more quickly and allowing users to get up and running in seconds. At the core Fabric provides a lake-centric and open data hub using the popular Delta format with built-in security, governance, and compliance throughout. At the edge, Fabric delivers flexibility for data scientists, data warehouse developers, and Power BI users to build and analyze using their unique skill sets.

During this session we will discuss the guiding principles and architecture behind Fabric and show a lot of demos! Whether you’re a data engineer, data scientist, data warehouse developer, or an existing Power BI user, Fabric has something for everyone. You won’t want to miss this session!

Building a Data Warehouse on Microsoft Fabric

In a world of mesh, data lakes, and lakehouses the data warehouse is still the centerpiece of many analytical solutions. In this session we walk through building a data warehouse in Microsoft Fabric from the ground up. To start, we will explain the basic architecture of the platform, so you understand how Fabric Data Warehouse is different from the other Microsoft SQL offerings. Next, we will create a workspace to get started then dive into data loading methods, transforming data with T-SQL, querying data, building reports directly in the browser using Power BI's Direct Lake mode, and applying security roles to the warehouse.

By the end of this session, you will be armed with all the information necessary to build your first data warehouse in Microsoft Fabric!

SQL Saturday South FL 2024 Sessionize Event

June 2024 Fort Lauderdale, Florida, United States

Bradley Schacht

Principal Program Manager, Microsoft Fabric CAT

Saint Augustine, Florida, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top