SSRS – Matrix that adds a new column each time 5 rows are filled with data
What if you want a dynamic list of values in a matrix but with a maximum of 5 rows. How
SSRS – Static column headers in a Matrix
How do you create a static column header centered above your dynamic columns? One way to try achieving this is
SSIS – Convert various String date formats to DateTime with the Script Task
The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just
MCITP – I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!
Today I passed the Microsoft IT Professional(MCITP) 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005”
SSAS – MOLAP, ROLAP and HOLAP storage types
A big advantage of a BI solution is the existence of a cube. Data and aggregations are stored in a
SSIS – Non-blocking, Semi-blocking and Fully-blocking components
How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or
SSAS – Visualize Attribute Relationships
Complicated attribute relationships are difficult to oversee in SSAS 2005. Microsoft solved this problem in SQL Server 2008 with a
SSRS – Custom expressions for subtotals in a matrix
If you want custom expressions for your subtotals in a matrix, for example to calculate an average instead of the
MCTS – I passed the 70-445 exam!
Last month I passed the MCTS 70-445 BI exam. This makes me one of the 338(October, 2007) Microsoft Certified Technology
SSRS – Invalid row heights, BUG?
Because I got a few reactions regarding the screenshots below (people thought something was wrong with the screenshots) please note
Jorg Klein's Blog 