SQL RELAY 2013r2 - Cardiff
Wednesday 13th November 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.
Cardiff Bay Creative Centre
Mount Stuart Square
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.
|From||To||SQL Server Track|
|09:15||10:00||Welcome & Keynote|
|10:00||10:55||Eric Lawson||Star Schema Database Primer|
|11:15||12:10||Denny Cherry||I've got a SQL database, now what?|
|14:00||14:55||Gavin Payne||Designing quality SQL Server solutions|
|15:15||16:10||James Rowland-Jones||Parallelism in PDW|
|16:30||17:25||Scott Klein||Microsoft SQL Server In-Memory OLTP Deep Dive|
|17:30||18:00||Prize draw & close|
|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?!
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.
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.
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.