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.
Read more →
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.
Read more →
Based on CTP6 (Feb 08' build): Drop me a line and let me know your thoughts and experience with the new Data Collector subsystem!
Its nice to get a few minutes to post a blog, things have been busy (which is good) .
Read more →
Hi Guys,
I've pushed two solid posts on DTS to SSIS 2005 or 2008 on Scalability Expert's App Compat blog as of late. We have done some good work in the SQL2008 space and the blog contains some of our results, thoughts, etc.
Read more →
The time has come, Gartner just ranked MSFT as the #1 BI stack, end-to-end! As a very recent MCITP: in BI where do I go now? Wait for SQL Server 2008?
Read more →
I wanted to take a post and thank everyone who has helped me with getting this blog up and also those who are visiting it frequently. So I would like to thank the following individuals for helping me:
Read more →
Microsoft SQL Server 2008 introduces several enhancements & changes to how we group and aggregate relational result sets in TSQL. What follows is a simplistic listing and overview of the grouping/aggregate changes we are seeing in Microsoft SQL Server 2008 CTP5: 1.
Read more →
Fellow (and new ones here on sqlteam.com) 'SQL Geeks', apparently Mr. Henderson passed away this past Sunday. The blog stating this is located here http://blogs.msdn.com/sqlrem/archive/2008/01/28/ken-henderson-we-will-always-remember-you.aspx?CommentPosted=true#commentmessage
When I wrote my first (and only to this date) lead author book it was on a non-BI topic, SQLCLR.
Read more →
UPDATE #3 Another question I have received in the feedback portion of this blog post could be summarized as follows: "How does SQLCDC handle new columns being added to a source table being monitored/captured by SQLCDC?
Read more →