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...
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...
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...
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...
Click to purchase a seat in the Pragmatic Works Los Angeles BI Boot Camp. Microsoft has a wide range of offerings in the business intelligence space and it can take a lot of work to figure out how they all fit together. The Pragmatic Works BI Boot Camp will walk you through a week of hands on activities that show exactly how each piece of the BI stack works. I will be teaching the class for all 5...
If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to see me! I’ll be speaking at the newly merged Space Coast SQL/.Net User Group on Power Query. This topic is easy for anyone in SQL, business intelligence, .Net or even every day users to understand. I’ll show you some awesome things you can do with Power Query and how to mash data...
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be through a series of unions in T-SQL, but that’s just ugly and means lots of passes at the data potentially. You could use a T-SQL unpivot, which isn’t bad and usually my preferred method. The problem is you may not always have the option to use T-SQL. What if your source is a flat...
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing 3 additional posts that go into a little more detail and contain screenshots of how to monitor each BI tool with some step by step instructions. Be on the lookout for those coming out over the next week. I have the first one written and scheduled to...
Updated 10-16-2014 at 11:20 AM Eastern Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone that attended. If you were unable to join or would like to see the recording you can find the link here. The Q&A can be found...
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone that attended. If you were unable to join or would like to see the recording you can find the link here. The Q&A can be found below. Q: Does disabling...
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).