No new commands, no new data types, no new stored procedure goodies. T-SQL Enhancements – got nothin’ for you here.It’s the result of Microsoft’s acquisition of DATAllegro. Scale-Out Servers – if you need to scale a data warehouse beyond a single server, you’ll want to keep an eye on Project Madison.

You can learn more about it in this screenshot-packed review of what’s new in Project Gemini and this pivot table tutorial for Project Gemini. Excel 2010 will act as a client for SSAS. Business Intelligence – there’s a ton of new functionality for self-service BI in SQL Server Analysis Services 2008 R2.If you’ve heard the terms Utility Control Point, Utility Explorer, or SQL Server Utility, I’ve got your answers in that series. I blogged about it in a 3-part series starting with this article about How SQL 2008 R2 is Like Virtualization for Databases. There’s some infrastructure introductions to support Data-Tier Applications in the future, but they’re not too useful as of the August CTP. What’s new, and what are the new features in SQL Server 2008 vs SQL Server 2008 R2?įrom a very high level, here’s the new features in R2 that weren’t in 2008: If you don’t have SA, then you’ll need to decide whether the new features in SQL Server 2008 R2 vs SQL Server 2008 will be worth the cost of upgrading, because you won’t get SQL 2008 R2 for free. If you’ve got Software Assurance for your SQL Server 2008 licensing, then you get all R2 updates included for free. SQL Server 2008 R2 Utility Explorer What’s the cost to upgrade to SQL 2008 R2? Despite it being released in the year 2010, it will not be called SQL Server 2010. SQL Server 2008 R2 will be released in May 2010.

What will be the SQL Server 2008 R2 release date? Got questions about the new features in Microsoft SQL Server 2008 R2? Can’t wait for R2’s release date? Here’s the answers I’ve been giving out most often to database administrators wondering about the changes in SQL Server 2008 R2 vs SQL Server 2008.

Download sql server 2008 r2 update