Morris will take the SQLRelay audience on a journey across SQL Server 2012 new innovations that span traditional boxed software, appliances, and cloud. Morris will address some of the tough issues facing IT and dev organizations today; mission critical SLAs that are simply expected, the explosion of data volumes with the need to enable end-user insight, and the evolution into the cloud world. Both IT and developers attendees will see technologies from SQL Server that help solve today’s growing challenges.

This presentation gives you the inside track on optimizing and testing SQL
performance on Intel Servers. We will look at Operating System and SQL Server
configuration to get the best possible performance and scalability from Intel
servers. We will also give an insight into the next generation of platforms to
show how to get the maximum from CPU features such as Turbo-Boost and
Hyper-Threading, Scalable Memory and Solid-State Disk features to take your SQL
Server environments to the next level of performance. We will also consider both
OLTP and Query based testing to measure and compare SQL Server configurations in
your own environment.

11:00

Break

11:20

Andrew FryerTechnical Evangelist, Microsoft

SQL Server 2012 Overview

Short overview of the new stuff then a drill down into further detail through demos.

12:20

Finish - Networking and your local group wrap up

PM - Deep Dive

12:30

Registration Opens

13:00

Chris Webb
SQL Server MVP
Technitrain

What's new in SQL Server Analysis Services 2012?

The 2012 sees Analysis Services splitting into two: the Multidimensional model, which is basically the Analysis Services of cubes and dimensions that we're all familiar with, and the new Tabular model which is very similar to PowerPivot. This session will cover what's new in Analysis Services 2012 Multidimensional, provide a brief overview of the Tabular model, discuss their relative strengths and weaknesses and help you decide which one is appropriate for your project.

14:00

Break

14:15

Tony Rogerson
SQL Server MVP, Freelance SQL Server Specialist

Always On - SANless High Availability

Through using Availability Groups we no longer rely on shared storage to provide
a usable and fully redundant copy of your Production databases. This session
will talk through the move away from SAN to SANless within the DR space and will
also give a level 400 talk on Availability Groups within SQL Server 2012.

15:15

Break

15:30

Martin Bell
SQL Server MVP

SQL 2012 Distributed Replay

SQL Server Distributed Replay is a tool which can help remove the risk and
uncertainty of hardware consolidation and changes. Available as part of the SQL
Server installation, it goes beyond the capabilities of SQL Profiler to help
simulate a more realistic load.