The R2 Duo: Running SQL Server 2008 R2 on Windows Server 2008 R2 Core

Although SQL 2008 R2 is primarily a BI focused release there's still new features to get excited about for traditional DBA's and Developers. In this session we will cover three new enhancements to the core Database Engine.

Application and Multi-Server Management introduces new capabilities for managing, monitoring and exploiting your SQL Server Infrastructure through the new SQL Server Control Point and enhancements to SSMS and Policy Based Management and Data-tier application packages.

SQL Connection Plans allow you to logically refer to a specific instance of SQL Server in connection strings making migration of database applications across your SQL Server infrastructure much easier by having one central point to change connection strings regardless of whether they are referenced by client applications, Integration Services and Reporting services

Unicode compression enhances the native data compression capabilities introduced in SQL 2008 for Unicode data using SCSU (Simple Compression Scheme for Unicode Data), a standard compression scheme for Unicode data.

Presented by Andrew Fryer at SQLBits V
Tags SSIS , BI
  • Downloads
    Slide deck available Slide Deck 4 MB
    Video available WMV Video 218 MB
  • SpeakerBIO
    I am a Technical Evangelist at Microsoft UK specialising in data . I got interested in large databases while at HM Customs in the nineties as part of the move to intelligence led resourcing, but another inititive namely outsourcing meant that career no2 was in the in the private sector working for a number of gold partners, before joining Microsoft 8 years ago. I got into SQL Server in v6 and have used this platform almost exclusively since then for a wide variety of clients from tiny breweries to global banks. Now I am at Microsoft I work on proof of concepts currently around the Cortana Analytics Suite like Machine Learning and Data Lake.
  • Video