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...
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services. We covered some of the differences between the two project types at a high level then built one of each to give everyone an idea of how difficult and how fast each could be developed. If you attended I want to say thank you. It’s always appreciated when people...
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience is always a lot of fun to interact with before presenting. If you were unable to join the session here is a link to the recording that you can watch for...
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).