SQL RELAY 2013r2 - Birmingham

Highbury Hall

Thurs 14th Nov 2013


SQL Relay will again be heading to Birmingham, for the second time in 2013!

It will be held in the magnificent Highbury Hall in Moseley, Birmingham, and will feature top quality SQL Server content from nationally and internationally renowned speakers including experts from Microsoft.

Registration is open now - register your place now!.


4 Yew Tree Road
B13 8QG


There will be two tracks of content; SQL Server and CloudOS. You will be able to switch between the tracks during the day, subject to available space in the rooms.

FromToSQL Server Track
09:00 09:25 Registration
09:25 09:30 Welcome & Introduction




Keynote and Q&A



Stuart Moore

Automating Backups, Restores and Verifications with PowerShell

11:05 11:25 Break



Denny Cherry

SQL Server table partitioning from the ground up

12:30 13:00 Sponsor Session: X-IO
13:00 13:50 Lunch



Dave Ballantyne

Estimation and Statistics: the basics of query optimisation

14:50 15:10 Break



Craig Ottley-Thistlethwaite

A Continuous Integration approach to SSDT (sqlproj)



Scott Klein

Microsoft SQL Server In-Memory OLTP Deep Dive



Prizes and Close


With so many awesome sessions, presented by world-class speakers, what more could you ask for?!

Register your FREE place now!.


Attendee Information

: There is some free parking at the venue, there is also free on-street parking in the area.

Address: Highbury Hall, 4 Yew Tree Road, Moseley, Birmingham, B13 8QG

Registration: Please register your place using the link above. Nearer the event we will email you 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 a light packed 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.





Automating Backups, Restores and Verifications with PowerShell

SQL Server makes it simple to automate backups with jobs and maintenance plans, but doesn't provide a simple method to schedule test restores to prove the backups have worked and are trustworthy.
Using PowerShell we can write simple scripts that allow us to automate test restores from our SQL backups, and then check that the restored database is valid, consistent and usable. This session will introduce you to the basics of restoring simple databases with PowerShell scripts, and then extending this to cope with more complex situations including data file relocation, point in time restores and running DBCC checks against the restored database


SQL Server table partitioning from the ground up

In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008.  We will look at how to create partitioned tables and indexes as well as the internals of the table.  We will also look at how to move data from one partition to another and from one table to another with minimal to no impact to the users.

Using these techniques we will be able to improve query performance and reduce downtime when loading and pruning data.


Estimation and Statistics: The basis of query optimisation

At the heart of SQL Server is the cost based optimizer.  Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken.  How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t.  It estimates!  How does it estimate ? That is statistics.

This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have
influence over these choices.


A CI approach to SSDT (sqlproj).
With SQL Server Data Tools providing a declarative model for building and deploy SQL Server databases, how do you integrated this into a CI environment? I'll show you how you can utilise MSBuild to automate your build and deployment process. This session is focused on using other tools to enable Continuous Integration and less on the development side of SSDT.


Microsoft SQL Server In-Memory OLTP Deep Dive

In this session, we’ll look at how In-memory OLTP is integrated into SQL Server and the architectural pillars of memory optimization, concurrency and native compilation. We’ll look at how In-memory tables and stored procedures are natively compiled and how ACID is achieved without locking and latching. We’ll also look at memory provisioning, high availability, and the overall manageability and supportability of In-Memory OLTP.


Speaker Bios


Dave Ballantyne

Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years, the past 15 of which has been specialising within SQLServer environment. He is a regular speaker at UK events such as SQL Bits and user groups.  He also is founder of the SQLLunch User Group.

Denny Cherry

Denny Cherry is the owner, founder and principal consultant for Denny Cherry and Associates Consulting.  Denny has over a decade of experience in the IT field.  Denny started working first with SQL Server, then he branched out into VMware’s vSphere and Microsoft’s Hyper-V platforms.  Shortly after begin worth hyper-visor platforms Denny begin working with Enterprise class storage.

Over the last several years Denny has focused on system architecture, performance tuning, and data replication.

Denny has an impressive set of credentials including being a current Microsoft MVP (Most Valuable Professional) Award winner, and he has been since 2008.  Denny also holds the VMware vExpert award from VMware and the EMC Elect award from EMC.  Denny holds certifications for SQL Server from the MCDBA for SQL Server 2000 up through the Microsoft Certified Master for SQL Server 2008.  Additionally Denny is also a Microsoft Certified Trainer.

Stuart Moore

Stuart has been working with SQL Server since 1998 and version 7, splitting the years between roles as a DBA and a Developer.

Craig Ottley-Thistlethwaite

Craig has worked on small databases to multi-terabyte data warehouses. Primarily focused on performance optimization and has an unhealthy obsession with the internals of the database and Integration Services engine. Craig has a sound knowledge of SQLXML from creating schemas to shredding the most complex xml blobs. Besides SQL Server Craig is also proficient in .NET/VBA & Java Development.

Scott Klein