January 2008 Blog Posts

SQL Server 2008: GroupBy Enhancements

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.       New GROUPING SETS Operator 2.       ROLLUP & CUBE Operator Syntax Changes 3.       New GROUPING_ID() Function   GROUP BY Operator Addition: GROUPING SETS The first and most noted change in how we can perform relational grouping is the GROUPING SETS operator addition to the GROUP BY clause. This new operator allows you to perform several grouping set in one query. The older equivalent of this functionality is...

Ken Henderson's Passing

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. I personally have a background in all facets of MS SQL (to some degree). ANYWAY, the point is, my publishing company pretty much said that Ken's 'guru' books was the target of what we wanted. At the end of the day, I nor could anyone else come close to the quality of content Ken's Guru Guide's...

SQL Server 2008: Change Data Capture (CDC)

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?" I'll first address the inverse of this question. How does SQLCDC handle columns that are removed from a source table? The awnser is that SQLCDC does the best it can by not altering the source table's corresponding Change Table schema so as to not break any downstream consuming applications/services. And thus any columns dropped from the source table remain in the change table with NULLs being inserted...

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski