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.
Links
Area of Expertise
Topics
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
Bradley Schacht
Principal Program Manager, Microsoft Fabric CAT
Saint Augustine, Florida, United States
Links
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