SQL Relay 2013 is coming to Birmingham!!
What is SQL Relay?
A full day, single track, technical conference focusing on all aspects of SQL Server.
In 2013, the Relay is visiting 8 cities around the UK, over two weeks from 17th to 27th June
The Birmingham event will be held at The Crescent Theatre, Brindley Place, on Wednesday 19th June
(Directions, public transport and parking details here!)
Who runs SQL Relay?
All SQL Relay events are run by your local user group leaders, working together to put on national conferences with a local focus.
What will the content be?
Have a look at the agenda below - top quality content from top quality speakers, imported from all over the world just for you!
How much does it cost?
All SQL Relay events are free to attend. We're able to put them on thanks to our generous sponsors. When you register, please allow third party contact so that our sponsors can contact you. This will help encourage them to sponsor these events next time!
Last year, the events were full, so don't leave it too late to register! Also remember to tell your friends and colleagues to register.
||Welcome & Introduction
||Anthony Saxby (Microsoft)
Michael Sullivan (Microsoft)
|Keynote and Q&A
||Natural Born Killers: SQL Performance Issues to Avoid
||Scott Klein (Microsoft)
||HA & DR using SQL Server in Windows Azure Virtual Machines
||Andrew Fryer (Microsoft)
||Managing Databases in Cloud OS
||Kevin Kline (MVP)
||SQL Server Internals and Architecture
||Grant Fritchey (MVP)
||Tune Queries by fixing bad parameter sniffing
||Tobiasz Koprowski (MVP)
||2AM: A disaster just began...
||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.
Parking: Park in Brindley Place multi-storey cark park, B1 2JF, just around the corner from the venue. Parking details & costs here
Address: The event is being held at the Crescent Theatre, Sheepcote Street, Birmingham B16 8AE, around the corner from the Brindley Place car park and the Hilton hotel. Details here
Registration: You should have been emailed a link to a ticket. You will need to print & cut this out and bring it with you to gain entry to the event.
Competitions: Your ticket will also contain competition entry vouchers, which you can put in sponsors' bowls during the day to win some great prizes! Please make sure you cut these out prior to getting to the venue or there will be a big queue for the scissors!
Food: We'll be prividing pizza, tea & coffee for lunch, plus tea & coffee at a couple of breaks. There will be a licenced bar open for you to purchase other drinks during breaks and lunch. We will be catering for vegetarian food, according to your food preferences during registration.
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.
Grant Fritchey - Tune Queries by fixing bad parameter sniffing
Parameter sniffing is a misunderstood issue on SQL Server. Most of the time, parameter sniffing is helping performance on your servers. But sometimes, circumstances change, and what was helping you is now hurting you - badly. In this session, you'll gain an understanding of what exactly parameter sniffing is and why it's usually so helpful. Then, we'll explore how parameter sniffing can go wrong and look at seven different ways you can deal with it when it does. You'll take away a wealth of knowledge that will help you identify and resolve bad parameter sniffing in your own environment.Andrew Fryer - Managing Databases in Cloud OS
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.
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
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
Richard Douglas - Natural Born Killers: SQL Performance Issues to Avoid
Join Richard to learn simple tricks to write better code, scripts, and tables. Plus, you’ll gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.Plus, you’ll learn how to take corrective action when:
- The optimizer isn’t using all available processors
- The database engine fails to report all the resources a query has used
- The optimizer uses the wrong plan
- Database tables cause memory issues
Anthony Saxby & Michael Sullivan
Microsoft UK, SQL Server Product Manager
Microsoft UK, Technical Evangelist, @DeepFat
Grant Fritchey (MVP)
Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant volunteers for the Professional Association of SQL Server Users (PASS). He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server 2008 Query Performance Tuning Distilled (Apress). He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG). He earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.
Kevin Kline (MVP)
Kevin Kline is a renowned database expert and software industry veteran currently serving is the Director of Engineering Services at SQL Sentry, a leading vendor of database and business intelligence tools. A Microsoft SQL Server MVP since 2004, Kevin was a founding board member and former president of PASS. He has written or co-written tweleve books including the best-selling SQL in a Nutshell. Kevin contributes monthly columns to SQL Server Pro and DBTA magazines. Kevin is a noted trainer and thought leader on IT leadership skills, database management technology and practices, and SQL Server performance tuning and optimization. Kevin is a top-rated speaker at conferences worldwide. He is on Twitter, Facebook, and LinkedIn at @kekline and blogs at http://KevinEKline.com.
Richard Douglas is a Systems Consultant for Dell where he specialises in SQL Server providing solutions and system health checks to organisations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site www.SQLServerPedia.com which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences.
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