March 2008 Blog Posts
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...
posted @ Sunday, March 23, 2008 10:18 PM |
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...
posted @ Sunday, March 09, 2008 3:20 PM |
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...
posted @ Saturday, March 08, 2008 10:07 AM |