Future proof your career by getting a head start on what you need to know about the next version of SQL Server Denali
Agenda
Introducing SQL Server Denali
- Whistle-stop tour of all new features
- What editions are available and how to
upgrade
Inside AlwaysOn and why it will change how you think about High Availability
- Exactly how this evolution of database mirroring works and where you should deploy it
- Why off-site Disaster Recovery with flexible failover options will be much easier
- How Contained Databases help to complete the picture
Core engine changes you need to know about
- When to use column store indexes and how they affect the optimizer
- How changes to the memory architecture may change how you configure SQL Server
Enhancing your troubleshooting toolkit with Extended Events
- How and when to use Extended Events
- Using new features in the tools to make managing events easier
- How to use the new Exentded Event based replacement for Profiler - XEProfiler
Testing your critical workloads with Distributed Replay (DReplay)
- Capturing a live workload for replay
- Setting up an environment for DReplay
- Replaying a live workload from multiple clients
Christian Bolton is the Technical Director for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Certified Architect, Microsoft Certified Master and MVP for SQL Server. He is also the lead author of Professional SQL Server 2008 Internals and Troubleshooting.