CategoryBusiness Intelligence

December 6, 2013

Presentation Update: New BI Features in SharePoint 2013

By Bradley Schacht
2 Min read
Add comment
06December

It’s time for another free webinar!! Whether you like it or not SharePoint is here to stay! With every release of SQL Server or SharePoint (which follow different release cycles) the feature set for Business Intelligence professionals gets more fragmented and more complicated. If I want to get Feature A what combination of SQL Server and SharePoint do I need? All valid questions. I’ll...

December 5, 2013

Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012

By Bradley Schacht
2 Min read
6 comments
05December

Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data capture and how to consume it with SSIS. CDC is one of the features I wish more of my clients were leveraging. It makes doing incremental loads dramatically more simplified. In this session I’ll show you quickly how to enable CDC then how to use SSIS to consume the data...

December 2, 2013

Webinar Q&A: Practical SSAS: Getting Started with Analysis Services

By Bradley Schacht
3 Min read
Add comment
02December

A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first was a session on how to load a data warehouse with SSIS. The followup session was about getting started with SQL Server Analysis Services (SSAS). You can find the link to the recording here. The Q&A can be found below. Enjoy. Q: Can I run SSAS Tabular and SSAS Multidimensional side by...

December 2, 2013

Webinar Q&A: Practical SSAS: Getting Started with Analysis Services

By Bradley Schacht
3 Min read
Add comment

A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first was a session on how to load a data warehouse with SSIS. The followup session was about getting started with SQL Server Analysis Services (SSAS). You can find the link to the recording here. The Q&A can be found below. Enjoy. Q: Can I run SSAS Tabular and SSAS Multidimensional side by...

December 2, 2013

Webinar Q&A: SSIS Design Patterns for Loading a Data Warehouse

By Bradley Schacht
5 Min read
4 comments

I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the Q&A for my two webinars up the week I did the presentations. So here is part 1 and the SSAS post will be separate. To start with, thank you for joining if you did attend the webinar. All of us at Pragmatic Works that do the webinars really do it because we enjoy giving back to...

October 7, 2013

SSIS Tips and Tricks Q&A

By Bradley Schacht
7 Min read
1 comment
07October

Thank you to everyone who attended my webinar on SSIS Tips and Tricks on October 3, 2013. The link to the recording can be found here. You can also check out all the Pragmatic Works Free Training videos here. I had several people ask about PASS Summit. So here is a link to the Summit page (). It is being held in Charlotte, NC in just a couple of weeks, October 15th to October 18th. There were...

October 1, 2013

Free SSIS Tips and Tricks Webinar

By Bradley Schacht
1 Min read
Add comment
01October

On Thursday of this week I will be presenting a webinar for Pragmatic Works Free Training on the T’s. I hear Rachel is planning on doing leprechaun facts before I present and you won’t want to miss those. My topic this week is going to be SSIS Tips and Tricks. Find all the relevant information after the break! Topic: SSIS Tips and Tricks Instructor: Bradley Schacht...

August 29, 2013

Data Mining with Excel Q&A

By Bradley Schacht
4 Min read
Add comment
29August

Thank you to everyone who attended my free webinar on August 29, 2013 where I talked about using the Data Mining Add-in for Excel. If you were unable to attend you can find the recording here. You can also check out all the Pragmatic Works Free Training videos here. I discussed why data mining is useful to organizations, showed how to download and install the plug-in using Excel 2013 and then how...

June 7, 2013

Hide the Ribbon in Power View

By Bradley Schacht
1 Min read
Add comment
07June

There may come a day when you want to embed a Power View report into a PerformancePoint dashboard or a Web Part page in SharePoint. The first thing you will notice when entering the URL is the ribbon shows up in the web page viewer. The ribbon will be displayed both in PerformancePoint and in the page viewer web part. More often than not the desired result would be to not show the ribbon to...

March 12, 2013

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job

By Bradley Schacht
3 Min read
7 comments
12March

I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with a deadlock message. This seems a bit strange given that it was a deadlock on the step executing the SSIS package, not an error message from within the package. There was no history of a failure in the SSIS execution logs, just the job failure. As you can see, the error only happened a couple...

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