Microsoft is announcing the release to production (RTM) of SQL Server 2008 R2 on April 21.The reality is, the item actually RTM;d a week in the past, about a week ahead of routine, mentioned Tom Casey, General Supervisor of Microsoft Company Intelligence. But the team held off until currently to make the public announcement.SQL Server 2008 R2 is like Windows Server 2008 R2 in that it's a supposedly “minor” R2 version, but includes an awful lot of new features and functionality. In spite of that reality, SQL Server 2008 R2 doesn;t include any upgrades to the core database itself, so it;s still technically a minor R2 release, not a major one, Casey noted.SQL Server 2008 R2 has been just over two years inside the making. A select number of SQL Server customers were consulted for feedback from the earliest development stages to make sure Microsoft was addressing their pain points. And they gave it, stated one of those customers, Ayad Shammout, Lead Technical DBA at CareGroup, who mentioned he advocated for more user-friendly data-import and reporting tools.While the R2 release offers a little something for everyone, “the thing that defined this release, from the beginning, was PowerPivot,” Casey stated.PowerPivot is technology designed to enable the “self-service small business intelligence” scenarios that MIcrosoft has been highlighting as major selling points for the newest versions of its SQL Server and SharePoint Server. The PowerPivot for Excel 2010 add-in for SQL Server 2008 R2, when used in conjunction with SharePoint,
Microsoft Office 2007 Professional, is designed to allow users to slice,
Microsoft Office Enterprise 2007, dice and publish/share data more quickly and easily. (And gives the Softies another in for selling SharePoint to more customers.)But there were lots of other features added to Microsoft;s newest database release that weren;t part of the original “Kilimanjaro” plan,
Microsoft Office 2010 Professional Plus, Casey acknowledged. As a result, new SQL Server 2008 R2 features like Master Data Services and StreamInsight complex event processing, which were ready and able to take advantage of new hardware advances, yet weren;t going to break backward compatibility,
Microsoft Office 2010 Professional Plus, they made the cut, he stated.(Speaking of the Kilimanjaro codename, Casey admitted he is no codename fan, but gave in to popular team demand. SQL Server Partner Product Unit Manager Kamal Hathi, who proposed “Kilimanjaro” — which was in keeping with the SQL Server crew;s “national parks” codename theme — ended up climbing Mount Kilimanjaro and hoisting a homemade “SQL Server 2008 R2″ banner to celebrate.)The free, low-end SQL Server 2008 R2 Express release is available for download today. Most of the versions of SQL Server 2008 R2 will be made available in May. (The high-end Parallel Data Warehouse is the one exception.)MSDN and TechNet subscribers will be able to download R2 Data Center, Enterprise, Standard, Workgroup and Developer (in English only) as of May 3. Volume licensing downloads will be available in 11 languages starting May 3. The trial bits are available as of April 21.Microsoft is planning a “launch” for SQL Server 2008 R2, but officials still won;t say when or where. I;ve been thinking it might launch on or around May 12, given that;s the Office 2010/SharePoint 2010 launch date. But so far,
Microsoft Office Professional 2010, mum;s the word.What;s up next on the database front? SQL Server “Denali” (a k a SQL Server 2011/2012).