Today at PASS the SQL Server team has publicly announced the first Community Technology Preview of the next version of SQL Server code named Denali. You can download it here:

I have been playing around with Denali for a couple of weeks now and created a couple of posts. Below is a list of the posts, click on each link to get some more information about Denali

First look at SQL Server Management Studio Denali

Screenshots of the new look and feel of BIDS in Denali

Find what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters

[Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object][4]

A first look at sequences in SQL Server Denali

Don’t install Denali BIDS side by side with a 2008 instance

Debugging In SQL Server Denali

Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging

These posts were all written without documentation available, it was mostly guess work but since documentation will be available with the public release of the CTP I will go into more detail the next couple of weeks

[4]: Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object