Building SQL databases in Fabric for Dashboards and Datamarts w/ Joey D'Antoni

Meeting IN-PERSON
Monday, February 10, 2025
Networking begins at 6:15PM
Speaker will begin 6:30-6:45, based on attendance

Location:
Improving Atlanta Offices
11675 Rainwater Dr #100
Alpharetta, GA 30009

### Building SQL databases in Fabric for Dashboards and Datamarts: Design, Indexing, and Compression

SQL database in Fabric can be an excellent solution for your datamart or to support your dashboard. However, to keep those dashboards and reports running smoothly, you must optimize your database design and indexing strategies. In this session, you will learn about the best practices for designing and building a star schema database in SQL database and how to structure your database. You will understand how to use columnstore indexes, and data compression and when to use heaps to make data ingest go faster. Whether you are an old DBA or a new data engineer, you will learn a lot in this demo-filled session.

# Speaker

# Joey D'Antoni, Microsoft MVP

Principal Cloud Architect
Joseph D'Antoni is a Principal Cloud Architect, a Microsoft Data Platform MVP, and VMware vExpert with over 20 years of experience working in both Fortune 500 and smaller firms. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit and Microsoft Fabric Conference. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He lives in Malvern, PA and holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016"