Geeks With Blogs
Random Musing Putting it together one piece at a time... August 2007 Entries
Implementation of Real Time Business Intelligence
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 ......

Posted On Thursday, August 30, 2007 4:58 PM

Real Time BI with SCD Type II?
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 ......

Posted On Wednesday, August 29, 2007 7:29 AM

T-SQL – 1 million records in 1 second
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 ......

Posted On Thursday, August 23, 2007 10:44 AM

Blogging from Word 2007
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 ' blog)/services/metablogapi.... There you go, start blogging away. Cheers ......

Posted On Monday, August 20, 2007 12:57 PM

Copyright © Nestor | Powered by: