“Juneau” is the code name given to the new SQL Server development environment which is based on Visual Studio shell. It is officially named “SQL Server Developer Tools” (SSDT) which is expected to provide a wide range of functionalities that are currently not available with SQL Server Management Studio (SSMS).

The current version of SQL Server Denali is CTP1 which does not include Juneau. It is expected to be available with the next CTP release (CTP2). See What is new in SQL Server Denali for a detailed list of features available in the next SQL Server Version (SQL11).

One of the interesting features that will be available in Juneau is more support for SQL Azure Development. A few other features that I found interesting are:

• Supports connected and offline database development
• Integrated application and database development
• Entity Framework Integration
• WPF based Text Editor

SSMS is my primary (and favorite) development environment and I am not sure whether I would ever like to switch to a different tool. I hope Juneau will not replace SSMS.