Browse by Tags

All Tags » SQL Server 2008 (RSS)
07 February 2011 18:07

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...
Posted by DrJohn | 1 comment(s)
Filed under: , , , ,
06 February 2011 08:32

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...
Posted by DrJohn | 3 comment(s)
Filed under: , , ,
14 February 2010 09:01

Microsoft Access: an elegant solution to Data Warehouse metadata

Before you send me flame mail telling me I must be off my rocker, I am not proposing Microsoft Access store any data! We all know that its JET-based database engine has severe limitations in terms of speed and scalability. No, what I am proposing is that...
Posted by DrJohn | 2 comment(s)
Filed under:
28 March 2009 23:05

SSAS: Kerberos kills ‘large’ MDX queries on Windows Server 2008

Kerberos kills MDX queries on Windows Server 2008 / SQL Server 2008 implementations...
Posted by DrJohn | 9 comment(s)
Filed under: ,