With Sql 2008 (in the current CTP you have in your hand), thanks to a new extension to the group by clause referred to as 'grouping sets', you now have the ability to use sets of grouping columns in your group by clauses, allowing you to define basically...

This post will cover an initial overview of the data compression feature that will be included in Sql Server 2008, and I'll also cover briefly some information on the Backup Compression feature as well (note that these are 2 totally separate and distinct...

So, I've been getting quite a few pings about providing a list of new features to look for in Katmai (Sql 2008) and/or those that I'll be either blogging about and/or presenting on at the DC area groups I mentioned here: http://blogs.msdn.com/chadboyd...

In Sql 2008 (Katmai), a couple of the 'smaller' features that are currently in the latest CTP include inline variable initialization and compound assignment (something you App Dev folks have had for years). So, the following types of code now work in...

In August, September, and October I'll be presenting on Sql Server 2008 (Katmai) at a variety of groups in the DC/Baltimore area. We'll be demoing lots of the new functionality with Sql 2008, including but not limited to Change Data Capture, MERGE, Table...

So you think you know SQL...Administration Part I The 2nd in the series...this one revolves around Administration and Internals of Sql Server, and is the 1st of 2-4 groups of questions in just Administration and Internals...again, these are seperated...