What will SQL Server do?
At the time of writing, CTP3 of SQL Server Denali was just released and promises to be an exciting release. That is important for us Dynamics enthusiasts because Dynamics NAV runs on SQL Server and the power of SQL Server and the new possibilities capabilities that SQL Server Denali will bring us will in the end also become an added value for Dynamics NAV and even one day might end up in the Dynamics NAV product itself.
SQL Server Denali will bring some new possibilities capabilities on high availability solutions. The idea is that a database should always be available, even when it's down. In the current and previous SQL Server versions we had database mirroring, log shipping, server clustering, replication, and similar options to achieve this goal. In SQL server Denali high availability will be available more out of the box and should be less complex to implement.
The BIDS environment as we are used to today will also evolve into a new tool. BIDS and SSMS will be...