What's new in R2 for the DBA

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 Jasper Smith at SQLBits V
Tags SSIS , DBA , BI
  • Downloads
    Samples available Slides 512 KB
  • SpeakerBIO
    Jasper is a member of the Database Services team at Nationwide Building Society focussed on High Availability, Scalability, Performance Tuning and Monitoring. He has been a SQL Server MVP since 2003 and runs www.sqldbatips.com with a focus on providing free tools for the SQL Server community including ExpressMaint, SQL 2005 Service Manager and Reporting Services Scripter.
  • Video
    The video is not available to view online.