Browse by Tags

• MS BI Exams
• SSIS
• SSRS

• Blog moved!

  For a number of reasons, I have moved my blog to http://sqlblog.com/blogs/jorg_klein/ Please change your bookmarks ;-) RSS: http://sqlblog.com/blogs/jorg_klein/rss.aspx Many thanks to Tony Rogerson and Simon Sabin for making this blog possible here at... Posted Dec 13 2009, 10:02 PM by jorg with | with 14 comment(s) Filed under: SSAS, SSRS, SSIS, MS BI Exams

• SSAS - Clear SSAS cache with an SSIS package

  Often I see developers on different forums asking how they can clear the SSAS cache. You can achieve this by restarting SSAS, which is done quite often. Restarting is not necessary though, it’s possible to clear the cache of an SSAS database with an XMLA script.... Posted Feb 13 2009, 04:35 PM by jorg with | with no comments Filed under: SSAS

• SSAS - Speed up dimensions using a NULL default cube measure

  Using a NULL default measure can be much faster when querying dimension members without selecting a measure...... Posted Feb 06 2009, 01:07 PM by jorg with | with 3 comment(s) Filed under: SSAS

• Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file

  This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/ This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx Posted Jan 06 2009, 08:02 PM by jorg with | with 5 comment(s) Filed under: SSAS, SSRS, SSIS

• SSAS – MOLAP, ROLAP and HOLAP storage types

  In SSAS 2005 there are 3 basic OLAP storage types. What are the advantages and disadvantages of those types and how do they behave…... Posted Mar 27 2008, 03:33 PM by jorg with | with 2 comment(s) Filed under: SSAS

• SSAS - Visualize Attribute Relationships

  SQL Server 2008 has a new feature that visualizes your attribute relationships in SSIS. This feature is also available for SQL Server 2005 with BIDS Helper…... Posted Nov 16 2007, 01:03 PM by jorg with | with 1 comment(s) Filed under: SSAS