CategorySyndication

Using sempy to get SQL query CU cost from the Fabric Capacity Metrics app

Download the notebook used in this post from my GitHub account here: Get SQL query CUs from Capacity Metrics.ipynb A frequent inquiry from customers goes something like this: “I ran a query on the [data warehouse or SQL analytics endpoint] and now I want to know how much that query cost me.” On the surface that seems easy enough. Afterall, the Capacity Metrics app tracks the usage for...

List Parameters for a Python Function

As someone who is newer to the world of Python I have a lot of questions. I mean a LOT. I know my way around SQL really well, but when I come to write some PySpark code I often need to dissect things to better understand what is going on and how to use different functions. Which leads me to today’s question…how do I get a list of all the parameters for a Python function? In...

Building The Big Demo

In the coming weeks I’m going to start building out a brand new demo environment and I’m going to blog the whole thing…probably…and I plan to blog the whole thing! As you may (or may not) know, I work on the Fabric product team at Microsoft. I am a principal program manager on the Fabric CAT (Customer Advisory Team) team. I always feel strange saying CAT team because then...

Upcoming Presentation – Jacksonville SQL Server User Group

I’m excited to announce that I will be speaking at the February meeting of the Jacksonville SQL Server User Group (JSSUG). It’s always fun to spend some time with local SQL community. I’ll be presenting a session recapping all the exciting features added to Microsoft Fabric in 2023 and previewing what’s ahead for 2024. If you’re local, come on out and join us for an evening of learning...

The Year Ahead: 2024

My favorite time of year is now behind us: Christmas. The weather cools down (I live in Florida, so that’s a little iffy), the neighborhood lights up with decorations, people are a little more friendly, church services are more full than normal, Nichole and I get to watch cheesy holiday movies, and we get to work through all our favorite traditions with our boys. As the Christmas season...

What is Microsoft Fabric

This year at the annual Build developer conference, Microsoft announced the public preview of Microsoft Fabric, an all-in-one analytics platform that will drive the future of analytics. To say that this release is huge would be an understatement. On the surface Fabric looks like an iteration on the work that was done when Azure Synapse Analytics was launched a few years ago. The reality is that...

Upcoming Presentation – Boston Business Intelligence User Group

I’m excited to announce that I will be speaking at the July meeting of the virtual Boston Business Intelligence User Group. I’ll be presenting an introductory session on Microsoft Fabric. The session is hosted online so everyone is welcome to join for an evening of learning and networking. The event is free, but please register at the link below to help the organizers with logistics...

Upcoming Presentation – Toronto Data Professionals Community

I’m excited to announce that I will be speaking at the June meeting of the virtual Toronto Data Professionals Community. I’ll be presenting an introductory session on Microsoft Fabric. The session is hosted online so everyone is welcome to join for an evening of learning and networking. The event is free, but please register at the link below to help the organizers with logistics and...

Upcoming Presentation – Jacksonville SQL Server User Group

I’m excited to announce that I will be speaking at the July meeting of the Jacksonville SQL Server User Group (JSSUG). It’s always fun to spend some time with local SQL community. I’ll be presenting an introductory session on Microsoft Fabric. If you’re local, come on out and join us for an evening of learning, networking, and of course food. The event is free, but please...

What is a DWU?

You’re new to Azure Synapse Analytics but you know you want to build a data warehouse. What do you do? After a quick search of the internet, you discover you need a Synapse dedicated SQL pool. Log into Azure, click a few buttons, deploy a Synapse workspace, and it’s time to get started with the dedicated SQL pool but there is one problem…you have no idea what a DWU is. The...

Bradley Schacht

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. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me