> 1 TB in < 30 min
Last year, with the introduction of SQL Server 2008, Microsoft broke the existing ETL World Record, doing a load of data using SSIS. Over 1 TB of data was loaded from flat files in less than 30 minutes.
At the time the team promised a white paper on the subject, which is now available on MSDN. It’s quite an interesting read (even for people like me, who don’t normally work with DWHs of that size).
Missing parameter in db2iseries.prm file
In BusinessObjects Enterprise XI 3.0 I ran into what seems like a bug. I am talking specifically about using Designer in combination with an AS/400. After having migrated content from a 6.5 environment I had problems with viewing column or table values of newly added tables. After some investigation it seemed to happen only to libraries, tables and columns with characters like @ and #. Read more
Latest All Up BI VPC (7.1)
I was recently made aware that there’s a newer version of the Microsoft All Up VPC than the one I’m running. Apparently it’s been out for some time now, but I thought I’d mention it. What is it you might wonder? It’s a (in my opinion) very cool VHD that, once mounted and set up, contains literally everything Microsoft has to offer in the field of Business Intelligence. The image runs Windows Server 2003 en contains, among others, SQL Server 2005, Microsoft Office SharePoint Server 2007, PerformancePoint Server 2007 SP1, ProClarity Analytics Server 6.3, Office 2007, ProClarity Desktop Professional 6.3 and lots and lots of demos. Unfortunately there image hasn’t been upgraded to Windows Server 2008 and/or SQL Server 2008 and is missing some Service Packs, but I’m sure this will come in the next version (whenever that is). Read more
Crystal Reports Service Packs and their corresponding versions
In addition to a post I wrote a while back I discovered something similar for Crystal Reports on the SAP network. It provides a list of Crystal Reports version numbers and their corresponding service packs, which will enable you to find out if you’re on the latest and greatest Service Pack for your (and mine) favourite reporting tool. This list only applies to versions XI, XI R2, and 2008 (via).
SSIS Custom component and its performance
Something I’ve also been wondering about and now know the answer to. It’s a shame I have no knowledge of C++.
A nice demonstration video of CAFE
SSAS 2008 Performance Guide
A useful white paper if you ask me.
Does the DWH hunt continue?
Apparently there is some speculation going on that SAP may be going after a data warehousing vendor like Netezza or Teradata.
I was wrong
I vented my frustration in this post about the fact that I could not install the Web Intelligence Rich Client. It seems, after having investigated the error (STU00244) and upgrading to Crystal Reports 2008 SP0 (which was what it was all about) I can now indeed install the Rich Client. I do apologize. The only thing is, why couldn’t the error message have said this straight away?
Consolidation in the Business Intelligence market space
I find this summary of the consolidation that has been going on in the last year or so very interesting. Good read if you’re working in the BI sphere.