SQL RELAY 2013r2 - Cardiff

Cardiff Bay Creative Centre

Wed 13th Nov 2013


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

It 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!. Register for the Cloud OS tracks.


Cardiff Bay Creative Centre

Mount Stuart Square

Cardiff Bay

CF10 5FJ


There will be three tracks of content; SQL Server, Hands-on labs, and CloudOS. You will be able to switch between the tracks at any time during the day.

FromToSQL Server Track 
08:45 09:15 Registration
09:15 10:00 Welcome & Keynote
10:00 10:55 Eric Lawson Star Schema Database Primer
11:00 11:15 Break
11:15 12:10 Denny Cherry I've got a SQL database, now what?
12:10 13:10 Lunch
13:10 13:40 Sponsor slot
13:45 14:00 Break
14:00 14:55 Gavin Payne Designing quality SQL Server solutions
15:00 15:15 Break
15:15 16:10 James Rowland-Jones Parallelism in PDW
16:15 16:30 Break
16:30 17:25 Scott Klein Microsoft SQL Server In-Memory OLTP Deep Dive
17:30 18:00 Prize draw & close
FromToLab Sessions 
10:00 12:10 Rob Sewell Introduction to PowerShell
13:10 15:15 Steve Powell BIML Schwiml

 With more than 10 sessions to choose from, and presented by world-class speakers, what more could you ask for?!

Register your FREE place now!.  Register for the Cloud OS tracks!

Attendee Information

Parking: None onsite, but there is a carpark at the end of the road

Address: Cardiff Bay Creative Centre, Aberdare House, Mount Stuart Square, Cardiff Bay, CF10 5FJ

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 providing a light lunch, plus tea & coffee at a couple of breaks. We will be catering for vegetarian food, according to your food preferences during registration. 



Star Schema database primer

A session covering the the core principles of the star schema database model, as required for decision support solutions and as the bedrock for Analysis Services cubes and the new Tabular model

In this session we cover

  • development of the RDBMS
  • technical comparison of databases
  • features of the star schema database
  • where do you get one
  • how do you best exploit it
  • next steps

Introduction to PowerShell

In this extended lab session, we’ll take you through the basics of PowerShell so you can get to grips with it.  Full of practical exercises you’ll be taught all about the coding environment, variables, pipelines, and useful commands.  By the end of the session, you can walk away with the knowledge needed to take PowerShell in whatever direction you fancy.

BIML Schwiml

Not many people have heard of BIML, even less have used it, and they are all missing a trick. We'll get started building a simple extract that demonstrates how to automate the dull repetition out of ETL/SSIS projects with the free BIML tools that come with BIDS Helper. Then we'll outline how you can build a meta data driven ETL solution that's flexible, reliable and will save you an enormous amount of time and energy when implementing a new ETL solution. 

Designing quality SQL Server solutions

This updated session looks at how meeting a solution’s functional requirements is only half of the story and meeting its non-functional requirements is what ensures operational success after deployment.  These requirements, also known as quality attributes, cover areas such as availability, manageability, scalability and security, and compliment your business requirements.  This session looks at SQL Server 2012’s features with demos to show how whether you’re a database developer, system or database administrator, or technical architect they can help you meet these quality requirements.

Parallelism in PDW

PDW is a scale out data warehouse engine – powered by SQL Server 2012. However, many people think of PDW’s scalability in terms of storage capacity; under-estimating other benefits. We are going to challenge that view in this session. We will learn all about PDW’s Parallel Architecture: Understand how PDW creates your database, distributes your data & processes your queries; making the most of the resources inside the appliance. Deliver MAXDOP all the time, every time with PDW.

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

I've got a SQL database, now what?

So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it.  I've got some of the answers here in this session for you. 

During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing. While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.

During this session Microsoft MVP and Certified Master Denny Cherry will give you the basic information that is needed to get that new SQL Server that you've just been told that you need to manage running and safe. After this session you will be armed with the basic information needed to know how to properly backup the database so that you can recover it after a failure. You will learn how to properly maintain the database so that it runs at peak performance, while using the least possible space. You will also learn how to look for, and correct database corruption problems.

Speaker Bios

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.

Eric Lawson 

I have over 25 years experience in the database field, beginning with IBM DB2, specialising inTandem NonStop SQL and in the last few years branching out onto SQL Server. My core experience is with business intelligence (BI) solutions & strategy, ERD & database modelling, design & performance tuning, large scale ETL systems infrastructure and data migrations.
Twitter: @ericjlawson

Gavin Payne

Gavin Payne is a principal architect working for Coeo, a UK SQL Server consultancy, and a Microsoft Certified Architect and Microsoft Certified Master.  His role is to lead projects that enhance, optimise, and consolidate mission critical data platforms. 

James Rowland-Jones

JRJ is a Consultant and SQL MVP for The Big Bang Data Company. His passion is to architect and deliver highly scalable database systems that are creative, simple, and elegant in their design. He has worked for some of the world's largest institutions and been responsible for project delivery worldwide. HIs focus is the Microsoft Appliance Architecture namely PDW and Fast Track Data Warehouse. JRJ is a keen advocate for the SQL Server community

Steve Powell 

Steve has been working with SQL server for longer than he likes to admit and developing code for longer still. He works as a BI trouble shooter for a health care oriented technology consultancy. He spends far too much time wrestling with recalcitrant servers and cursing developers who think documentation is something that happens to other people, but its the only way he can fund his sons ongoing Lego addiction.

Andre Kamman

I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers and learning something new every day.