March 2008 Blog Posts

Revisiting my book, "Professional SQL Server 2005 CLR Programming"

With the upcoming arrival of SQL Server 2008, the topic of CLR Integration (SQLCLR) is coming up alot again. Probably the biggest reason to use SQLCLR is to replace existing Extended Stored Procedures (XPs). According to SQL Server 2008 Books Online XPs continue to be a deprecated feature: "This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CLR Integration instead." Alot of folks are pinging me about my last book, "Professional SQL Server 2005 CLR Programming" due to SQL...

Growing up with Microsoft SQL Server

A few days ago I turned 30 years old and my how I thought that day would never come, suppose the alternative is much worse though. I've been fortunate enough to make a good living (though I've struggled in my personal aspects of life mainly due to my love for my career and determination) and those i've worked with usually look to me as one of the best in the product end-to-end. Some even think that I am like the guy off of 'Good Will Hunting', hardly the case, the knowledge I have is a result of those that I surrounded...

Real-Time BI? Yes or No? Which is it...

This is probably one of the hottest topics (and has been) in the BI field. A few years ago while working for a major online mortgage company I lead the implementation and design of a very large scale ETL real-time solution that I designed based upon SOA architecture principals. The designs were translated into SQL 2005 Service Broker functionality and overall gave us the kind of ETL speeds we were looking for (up to hundreds of records processed per second). I was not the lead on the SSAS side (my very good friend and colleague, Dan Meyers was) but I believe...

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski