Category: Business Intelligence

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

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

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

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

SSIS Tips and Tricks Q&A 1

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

SSIS 2012 Deadlock When Running SSIS from SQL Agent Job 7

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

Remove Local Administrators SSAS Admin Access 2

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