The first Community Technology Preview (CTP) of Microsoft SQL Server 2008 R2 is now available to you from TechNet. To get it, you’ll fill out an online form that will redirect you to the Microsoft Download Center. You’ll find Enterprise and Expression editions of SQL Server 2008 R2 in 32-bit, 64-bit, and ia64.
SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help your customers scale with confidence and improve IT and developer efficiency with new and enhanced tools for application and multi-server management, master data services and complex event processing. The new Self Service BI capabilities will empower end users to access, integrate, analyze and share information using business intelligence tools they already know – Microsoft® Office.
The Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP) includes Application and Multi-server Management to help organizations manage database environments efficiently at scale with increased visibility and control across the application lifecycle.
Report Builder 3.0 includes support for geospatial visualization (mapping, routing, custom shapes) which can help produce new insights and discoveries well beyond what can be achieved with standard tables and charts when geospatial data is combined with business information.
Microsoft SQL Server StreamInsight will also be made available for Community Technology Preview in the coming weeks. This new complex event processing technology will help businesses derive better insights by correlating event streams from multiple sources with near-zero latency.
Key features in this CTP release include:
- A new Control Point Explorer for central multi-instance and application utilization management.
- Built-in wizards to help you quickly set up and enroll instances and Data-Tier Application components into central management.
- Dashboard viewpoints for quick insight into application and instance utilization.
- Report Builder 3.0 with new support for geospatial visualization.
- StreamInsight core technology engine.
The Fall 2009 CTP will include the remaining SQL Server 2008 R2 features including Master Data Services and Self Service Business Intelligence capabilities delivered in SQL Server Reporting Services and Project “Gemini”.
SQL Server 2008 R2 is slated for release in the first half of calendar year 2010.
Bruce D. Kyle
ISV Architect Evangelist | Microsoft Corporation