SQL RELAY 2013r2 - Southampton
Tuesday 12th November 2013
SQL Relay will again be heading to Southampton, 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!.
Wells Place Centre
|From||To||SQL Server Track|
|09:00||09:15||Welcome & Introduction|
Keynote and Q&A
|09:55||10:55||James Rowland-Jones||Parallelism in PDW|
|11:15||12:15||Dave Morrison||Query Plans Deep Dive|
|13:50||14:50||Denny Cherry||SQL Server Table Partitioning from the ground up|
|14:55||15:55||Chris Webb||Introduction to Power BI|
|16:15||17:15||John Martin||Introduction to SQL Server|
|17:15||17:30||Prize draw & close|
Address: Wells Place Centre, Wells Place, Eastleigh, Hampshire, SO50 5LJ
Parking: Public parking is available at the Swan Shopping Centre a short distance away.
Public Transport: Wells Place is approximately 1 mile from Eastleigh Train Station
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.
Introduction to Power BI - Chris Webb
Power BI is Microsoft’s hyped new self-service BI suite, consisting of a range of Excel addins (Power Pivot, Power Query, Power View and Power Map) and cloud-based dashboarding, data discovery and collaboration functionality integrated with Office 365. This session will explain how all the parts of Power BI fit together and show how it can be used as an end-to-end solution.
SQL Server Table Partitioning from the ground up - Denny Cherry
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.
Query Plans Deep Dive - Dave Morrison
In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query. We will also take a look at various operators, how they work, why they are chosen and how to avoid them being used in the wrong place / context,. Attendees of this session will walk away with a greater understanding of query plans and the operators, which will enable them to both better interpret their query plans and also write more efficient SQL code
Parallelism in PDW - James Rowland-Jones
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.
Introduction to SQL Server
SQL Server, its a database right? Well yes, kind of - In this session we will look at SQL Server, starting with some of the installation and configuration options moving through setting up SQL Agent to help let you know if there are problems. Finally we will look at indexing, missing, unused and fragmentation
Chris Webb is an independent consultant and trainer specializing in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of three books: "Expert Cube Development with SQL Server 2008 Analysis Services," "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase," and "SQL Server Analysis Services 2012: The BISM Tabular Model." He blogs about Microsoft BI at http://cwebbbi.wordpress.com/ and his Twitter handle is @Technitrain
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.
Dave Morrison is BI consultant for Itelligence. Having worked in the IT industry for around 14 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
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
John is a SQL Sever developer & DBA, working with SQL Server since 2007 in a range of environments ranging from defense to manufacturing & retail. All of which have had stringent security requirements for their data systems that include not only regulatory compliance but also availability and recoverability requirements