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.
In this session we will cover 3 new enhancements to the 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 an application in connection strings rather than servers making migration of database applications across your SQL Server infrastructure much easier. Unicode compression in R2 enhances the native data compression capabilities introduced in SQL 2008 for Unicode data using SCSU (Simple Compression Scheme for Unicode Data)