Sunday, September 19, 2010

Super fast Data Warehouse dimensions loading with SSIS and Change Tracking

The Challenge: Updating Type 1 dimensions as fast as possible. Source tables can be quite large and retrieving only changes and new data will reduce the time it takes to update your dimensions dramatically.

Friday, September 17, 2010

About this Blog and myself

Hello everyone,

My name is Luis Figueroa and I am an IT professional specialized on Microsoft SQL Server and BI. I am really passionate about architecting solutions that leverage the MS SQL Database Relational Engine and SQL server BI components to produce high performance solutions that deliver near real time data to businesses.

I am also an active member of the SQL Server community that enjoys learning and sharing knowledge  with others. I am the president for the Microsoft Business Intelligence User Group of South Florida and the Director of Sponsorship for the South Florida SQL Server User Group. I often speak at SQL Saturday events mostly in Florida and attend anywhere I can.

So as you would expect that is what this blog is going to be about. SQL Server / BI and the awesome SQL Server community. You can find me in LinkedIn and Twitter so if you have a passion for SQL Server or you are a Business Intelligence professional I would love to network with you. I am also always available to answer any questions whenever I can be of help.

I look forward to hearing from you,

Luis Figueroa