Browse by Tags

SSIS: Deploying OLAP cubes using C# script tasks and AMO

As part of the continuing series on Building dynamic OLAP data marts on-the-fly , this blog entry will focus on how to automate the deployment of OLAP cubes using SQL Server Integration Services (SSIS) and Analysis Services Management Objects (AMO). OLAP cube deployment is usually done using the Analysis...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Mon, Feb 7 2011
Building dynamic OLAP data marts on-the-fly

At the forthcoming SQLBits conference , I will be presenting a session on how to dynamically build an OLAP data mart on-the-fly. This blog entry is intended to clarify exactly what I mean by an OLAP data mart, why you may need to build them on-the-fly and finally outline the steps needed to build them...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Sun, Feb 6 2011
MCITP BI News; some news for MCTS BI and SQL Server 2008

Anticipated recources for the premier Microsoft Business Intelligence certification (MCITP BI) for SQL Server 2005 are fading from Microsoft. I recently was made aware from Amazon that a book I pre-ordered titled "MCITP Self-Paced Training Kit (Exam 70-446): Designing and Developing a Business Intelligence...

Posted to greenmtnsun (Weblog) by greenmtnsun on Wed, Oct 17 2007

Page 1 of 1 (3 items)

SQL Server Blogs