CategoryBusiness Intelligence

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

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...

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

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...

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

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...

SSIS Tips and Tricks Q&A

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...

Free SSIS Tips and Tricks Webinar

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...

Data Mining with Excel Q&A

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...

Hide the Ribbon in Power View

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...

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job

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...

Remove Local Administrators SSAS Admin Access

Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services (SSAS) administrator group at the server level. This is a pretty easy process; log in, add or remove admins as necessary in the security section. However, by default any user who is a member of the local administrator group on the server will also be an administrator on the...

Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.

If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message: We’ve all been there. A build error. I tend to get this because I like to forget commas when modifying calculations in the MDX section of the cube editor. It’s a fun little game I like to play to keep myself on my toes…question mark?? Anyway, what follows this message box is...

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. 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