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.
I am a technical evangelsit at Microsoft specialising in the data (data centre , data management and data science). 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 my last ten years have been in the private sector working for a number of gold partners, before joining Microsoft last July. 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.