SQL RELAY 2013 - Glasgow

Monday 17th June 2013

SQL Relay will be coming to Cineworld, Renfrew Street, on Monday 17th June, featuring top quality SQL Server content from nationally and internationally renowned speakers.
Registration is open now at the UK SQL Server User Group website.



Provisional Schedule
08:30 09:00 Registration
09:00 09:05 Welcome & Introduction
09:05 09:50 Anthony Saxby (Microsoft)
Michael Sullivan (Microsoft)
Keynote and Q&A
09:55 10:55 Tobiasz Koprowski (MVP) 2 AM. A Disaster just began...
10:55 11:10 Break
11:10 12:10 Andrew Whettam ColumnStore Indexes with Table Partitioning
12:10 13:10 Lunch - And solid state storage session by Ashminder Ubhi from Violin (12:30-13:00)
13:10 13:40 Andrew Fryer (Microsoft) Managing Databases in Cloud OS
13:45 14:45 Kevin Kline (MVP) SQL Server Internals and Architecture
14:50 15:50 Satya Jayante (MVP) SQL Server HA 2008 R2 & 2012: Overview & Solutions
15:50 16:10 Break
16:10 17:10 Scott Klein (Microsoft) HA & DR using SQL Server in Windows Azure Virtual Machines
17:10 17:15 Prize draw & close

With such an awesome lineup of World-class speakers, what more could you ask for‌!
Head over to the UK SQL Server User Group website to register your FREE place now.

Tobiasz Koprowski - 2AM, A Disaster Just Began...
Once upon a time, somewhere in a dark, lonely data center room an SQL Server stopped talking. Nothing about it in monitoring system, except - connection lost. Ping, Telnet, Remote Login doesn't work. In the same time somewhere in the City one of the millions mobiles can't stop ringing and ringing. It's Your phone and You are DBA. It's 2AM and Disaster just began... In this session I want to discuss about best practices for surviving disaster, based on my experience in few years in data center. We will talk about more aspects which You probably know, and some about You have never think before THIS day - The Disaster Day.

Andrew Whettam – ColumnStore Indexes with Table Partitioning
This session will look at ColumStore Indexes (introduced in SQL Server 2012) and Table Partitioning. Expect examples to be in evidence as we review each of the two technologies separately before combining them and examining how they can be used together to good effect. The benefits and pitfalls of each will be discussed as will the new xVelocity (VertiPaq) engine, since ColumnStore Indexes rely on this technology, also new in SQL Server 2012.

Kevin Kline – SQL Server Internals and Architecture
Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

  • What’s different about 32- and 64-bit systems‌
  • What are the various areas of memory inside of SQL Server‌
  • How are queries handled behind the scenes‌
  • What does SQL Server do with procedural code, like functions, procedures, and triggers‌
  • What happens during checkpoints‌ Lazywrites‌
  • How are IOs handled with regards to transaction logs and database‌
  • What happens when transaction logs and databases grow or shrinks‌

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!

Andrew Fryer - Managing Databases in Cloud OS

A database is only as good as the operating system (OS) it runs on. With the latest release of Windows Server and Azure , Microsoft has launched what it calls the Cloud OS. So what exactly is that and what does this mean for the DBA? Having established that we’ll then look at exactly what this means for SQL Server running on your own servers in terms of virtualisation, HA, DR management and performance.


Satya Jayante - SQL Server HA 2008 R2 & 2012: Overview & Solutions

As an architect or DBA it is important to develop the right HADR strategy and corresponding solution which meets the availability requirement and at the same time provide the cost benefit for your organization. Come to this session to learn about how you can develop the right HADR solution for your environment. In this session, we will overview different solution alternatives and explain the key metrics to use for making the decision as well as discuss best practices using 2008 R2 and 2012 technologies.


Scott Klein - HA & DR using SQL Server in Windows Azure Virtual Machines

Windows Azure Virtual Machines is designed to support a broad range of SQL Server workloads, yet it is up to the database administrator to ensure that your database system possesses the performance, high-availability and disaster recovery capabilities that that your service-level agreement requires. This demo-heavy session will discuss how to provide the necessary high-availability to SQL Server in a Windows Azure VM as well as how to use SQL Server instances in a Windows Azure VM for disaster recovery of on-premises SQL Server instances. We’ll discuss the scenarios, how to implement them, and considerations for each scenario including how these scenarios can lower the cost of HA and DR database systems. This session will also look at techniques, guidelines, and recommendations for optimizing SQL Server performance in a Windows Azure virtual machine.


Speaker Bios
Anthony Saxby & Michael Sullivan
Microsoft UK, SQL Server Product Manager


Andrew Fryer

Andrew Fryer is a Technical Evangelist at Microsoft UK Ltd, specialising in data centre and database management & BI. When not blogging and making screencasts in the office he can be found presenting at various IT Professional events across the UK including TechDays OnLine & IT Camps, IPExpo , SpiceWorld VMUG etc.


Scott Klein

Scott Klein is a US based Microsoft Technical Evangelist focusing on Windows Azure SQL Database and related cloud-ready data services. His entire career has been built around SQL Server. Prior to Microsoft he was a SQL Server MVP for several years, then followed that up by being one of the first 4 SQL Azure MVPs. Scott is the author of over ½ dozen books by both WROX and APress, including Pro SQL Database for Windows Azure. He can be found talking about WASD at events large and small across the US, and the rest of the world, wherever he can get people to listen.

Kevin Kline (MVP)
Kevin Kline is a renowned database expert and software industry veteran. A long-time Microsoft SQL Server MVP and noted leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide. He tweets at @kekline and blogs at http://KevinEKline.com.

Tobiasz Koprowski (MVP)
Community leader focused on SQL Server, SharePoint, security, collaboration, and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, Freelancer, consultant. Conducts audit projects, consulting and implementation in Poland and across Europe. Technical Team Leader in GITCA. Member of such Microsoft Terminology Community, Subject matter Expert, Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. Since 1st July 2010 MVP for SQL Server. Former President of the Polish SQL Server USer Group. Creator of SQLDAY Conference and CEO 2009-2011. Speaker at group meetings and conferences (such SQL Day, SQL Saturday, SQL Bits, SQL Connections, InfoTRAMS, CarreerCon, SharePoint Community Launch, Time for SharePoint, SQL Server Community Launch, IT Academic Day, Code Camp). Co-Author SQL Server MVP Deep Dives Volume II and author of few articles on Microsoft TechNET, IT Portals and magazines.Owner of several blogs: IT Pro, aimed at the SQL and SharePoint, a blog about licensing, and three private blogs. In his spare time journalist and music critic, photographer and concert promoter collaborating with ArtRock.pl and Verband Junger-Journalist Berlin Brandenburgen