Geeks With Blogs
Random Musing Putting it together one piece at a time... Business Intelligence
How to get Oracle Drivers to work on an x64 Box for SSIS
Just a couple of weeks ago, I was tearing my hair out trying to meet a really tight timeline and at the same time trying to solve a technical issue which in my opinion is a total waste of time. If anyone of you had ever tried to make SSIS and Oracle work on a 64 bit machine, I am sure you know what I was referring to. Fortunately we have people like Steve McHugh and Greg Galloway, who both wrote some excellent how-to articles addressing this issue. I've now grown so dependent on these articles (especially ......

Posted On Tuesday, January 22, 2008 9:37 AM

Designing for Slowly Changing Dimension and Rapid Changing Dimensions
SCD (Slow Changing Dimension) has been a very common scenario for data warehouses and there are many established and proven techniques that can be used to solve the problems. This includes the usage of SCD Type II (Insert only) or SCD Type I (Update only) methodology. When we start to look at designing a system that caters for real time information, it's very common that we will meet the same problems, with the exception that the dimension doesn't change slowly, but rapidly. Moreover, they normally ......

Posted On Monday, September 3, 2007 9:34 AM

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

Changing ASP.Net 2.0 User-Login Control's Database
For the next few months, I will be publishing a series of short and basic tutorials on development of a skeleton system comprising of the following technologies Ajax using ASP.Net Atlas ASP.Net 2.0 webparts and usage of some other user controls Windows Workflow Foundation Windows Communication Foundation Cross technology between WCF and WF Reporting Services Business Intelligence using SQLServer 2005 including database design, SSIS and AS Application to application integration through BizTalk 2006 ......

Posted On Friday, January 26, 2007 1:53 PM

A recent SSIS project which involved data retrieval from Firebird SQL to SQLServer 2005 prompted me this post on the differences between ODBC and OLEDB. At this time of writing, there's very little information on how SSIS can import information from a Firebird SQL database in the internet, at least too little for me. Before finally deciding on using OLEDB adaptors to connect to Firebird for direct data import, there were some other considerations, like consuming Webservices with a Firebird .Net Provider ......

Posted On Thursday, December 14, 2006 4:04 AM

Copyright © Nestor | Powered by: