While there have many takes and talks about Business Intelligence 2.0, which is really BI working in a SOA environment, the technology behind Business Intelligence hasn't seems to mature to the state where we can really have real time performance without sacrificing some traditional BI systems characteristics. SQL Server 2005 did a great job in getting us closer to Real Time Business Intelligence through the introduction of Proactive Caching as well as SSIS's dimensional destination. However, things ......
Is this even possible? I've been trying to design a BI system on SQL Server 2005 with strict constraints to maintain a 'single version of truth'. One of the hardest things in this system is to provide Real Time data views with historical audit. To make things more exciting, many of the dimensions are slowly changing dimensions. Proactive Caching in SSAS seems to address the issue of Real Time BI in a good sense. We're actually able to get pretty good performance on a ROLAP engine thanks to this neat ......
I thought this is worth noting. This is the way to generate 1 million records within 1 second in SQL Server 2005. I'll have the code pasted here so that I can have a reference the next time I need to use it. As Namwar Rizvi said, this code is proposed in SQL Server 2005 TSQL Querying by Microsoft press. --Declare a variable to hold the--count of rows to be generated Declare @p_NumberOfRows Bigint --We need 1 million rows Select @p_NumberOfRows=100000; With Base As(Select 1 as nUnion AllSelect n+1 ......
It has been a while since I last posted. Thanks to all the changes that's happening in my life. New job, new role, new technology and a new laptop. Anyway, so I heard that Word 2007 supports blog publication, which is a really neat feature. I got it set up with the following few steps Select publish to Blog Select 'others' for blog type Select MetaWebLog Type in 'http://geekswithblogs.net/... blog)/services/metablogapi.... There you go, start blogging away. Cheers ......