[EN] SQL Relay Autumn Tour – Day Eight

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Eight day in London. Last day of two weeks tour. Nope, not two weeks: week tour – week break – week tour. Reiny morning, canceled my plan for walk, so by Picadilly Line I jump from my hostel to Buckingham Palace area, then walked and almost as a first (except Anthony Saxby) SQL Relay affected person came to Cardinal Place where is Microsoft Uk Head Quater in London. Yes, the have big campus in Reading, where you can meet folks from Coeo. But in this post I’m writing only about London’s event.


Biggest event in very important place. But Victoria Square/Cardinal Place remembering me La Sagrada Familia  – neverending building process. It’s reallly anoying, but… Londoners are prepared for this, for last few years. Two rooms: Auditorium 1 and Auditorium Two – separated after Keynote (of course by Anthony Saxby) and Speaker Room and few other nice places. At the same time at Microsoft happened three or four internal meetings, Dynamyx Training, Azure Talks and something more. I really appreciate local Microsoft’s stuff – the made great, really great job. Two track and special session for me – I didn’t put it on my schedule before SQL Relay, but with free place and collaboration with Tony Rogerson I did’it! So our agenda was simple:

Keynote | Microsoft
Sponsor Sessions by Violin Memory & Pure Storage

Both Tracks: DBA Track & BI/DEV Track
SQL Server 2014 New Features (not Hekaton!) | David Williams

DBA Track
Understanding Parallelism | Christian Bolton
Dave’s SQL Fun Time Hour | David Morrison
SQL Server 20014 Hybrid Cloud Features | Scott Klein
T-SQL Performance Issues : What you should know to find and resolve them | Claire Mora
SQL Azure from Plan, to Backup to Cloud | Tobiasz Koprowski

BI Track
Using PowerPivot and DAX to predict and win Fantasy F1 | Alex Whittles
Introduction to Power BI websites | James Boother
BigData for SQL DBA’s | Alessandro Recino
Business Insight: Structure data in relational databases | Sameer Parve
Fast and Flexible Data Wrangling with Data.Table in R | Matt Dowle

We had few necomers like: David Williams {TWITTER} and Matt Dowle {LINKEDIN} but most interesting was Claire Mora {TWITTER}, because she was First Time Speaker. I had no time for attending on her session, but I’m sure I will do it next time. Last day of SQL Relay 2014 Autumn Tour. Again busy and full of work. It was special for me, because on behalf of Tony Rogerson I was proud to closing conference and whole tour on DBA Track – because Tony was able to closing it only in one room in one time. Fast but long day.

[EN] SQL Relay Autumn Tour – Day Seven

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Seventh day in Birmingham. I have been in this sity many times. Even on SQL Relay 2013 or just for visiting on my free times (it happened few years ago, yes). I had bunk bed in really nice hostel close to center, and I will back ther on my next trip – if I will go eg for user group meeting. Birmingham is the Alex Whittles’s area , he is the leader of local user group and made many succesfull events – even with me as speaker. Short sleep, coffe to go and less than oneour walk throuds Birmingham, close to canal pathway, acreoss the factory’s area and nice green park. on last SQL Relay we hadconference in theatre, butthis time Alex found much better place. In the centre of green, full of wild animals Cannon Hill Park.


We had two track here, great coffee and good located exhibition area. But before our event started, we work a little with preparation task, I got a chance to test my equipment in ‘my SQL Relay session’s best tour place’ and locate half of table in speaker room. I spend about twenty minutes with magic (‘cos entrance to the venue was close till nine, and people start to come about 8:20) things close to etrance with tallking with Steve and one of the venue staff member. I had chance to talk with Stuart Moore {TWITTER} and John Q Martin {TWITTER} few other peoples. Our agenda was very interesting again, even we had only two tracks, but both in cinema-style rooms. YAY!

Keynote | Microsoft
Sponsor Sessions by ProfiSee & Microsoft

SQL Engine
Building an automated database deployment pipeline | Alex Yates
Transaction Logs: A primer | Stuart Moore
Query Plans Deep Dive | David Morrison
SQL Azure from Plan, to Backup, to Cloud | Tobiasz Koprowski
Something new in SQL Server 2014* | John Q. Martin

BI / Analytics
"But SSRS Can’t Do That" – How to make it do that! | Oz Locke
Hadoop for the Microsoft Person | Allan Mitchell
Implementing self-service BI | Reuben Pearse
Top 10 Analysis Services Multidimensional Design Mistakes | Chris Webb
Automate your SSIS Build using BIML | Steve Powell

I came for last session on DBA Track where John replaced Mike Bowsell and really don’t remember what was the session title. I hope that all sessions will be availalble soon, so I can download and look for it. One of the best place and event in this tour and I’m very happy that Alex think about next event in the same place (and maybe for user groups too?). We packed all our stuf, leaved one hundreds profisee bottles on reception desk (as a charity for kids or something like that) and went for last city. Before we catch morothay, we found very noisy, annoying service where half of stuff had day off, so even on fast food style we wait about 20 minutes for pizza of fish and chips. very annoying. And our super driver hero Steve, found info abour traffic and accident on motorway to London, so he decided – and it was best decision – to driving thorugh villiges. Finally about nine pm we meet Anthony at Cardinal Place and unpacked whole our stuff.. pssst… the corridors under Cardinal Place could be used for horror movie.

[EN] SQL Relay Autumn Tour – Day Six

A series of short post about SQL Relay Autumn Tour in United Kingdom, where I speaking, networking, helping and doing more fun and business things. Sixth day in Leeds. I have been here on SQL Relay 2013, but in different place. We arrived on Monday evening and our good friend Martin Bell just ran on time to right place to help us unpacking our stuff. My great driver found strange place where I had accomodation – as always I sleps in different place that all other peoples. I had plan for work, but place was not very good, so I just went sleep – especially that I entered door not for my hostel but or private house – and a little drunk owner scream to me: “Get out. Next door, damned! Next door!” Morning, I woke up morning and went to Costa Caffee close to venue.


About eight I found Alex Whittles near wrong reception desk (on 2nd floor) and tried to help him with organizing room – especially with abnormal floating screen / really terrible effect for speaker and audience. Some help with organizing, unpacking and checking the rooms. I found amazing theatre-style grand room for DBA track and finally small room for Cloud track. Of course ss always I occupied table with working process. In Leeds we had only one keynote presented by Anthony Saxby but in really great treater room. leeds was biggesr event, another with three track (after Southampton and Cardiff). And here is the final agenda (after some unexpected changes):

Keynote | Microsoft
Sponsor Sessions by ProfiSee & Pure Storage

Dev/DBA Track
Dave’s Fun Time SQL Hour | David Morrison
SQL Server Unit Testing | John McLusky
Uncovering the hidden gems in execution plans | Kevan Riley
Business Insight: Structured data meets unstructured data | Stephan Lawson
Statistics, Estimation & Plan Caching – The Big Three | David Morrison

BI Track
Using PowerPivot and DAX to predict and win Fantasy F1 | Alex Whittles
A look at 3 Big Data Tools | Allan Mitchell
"But SSRS Can’t Do That" – How to make it do that! | Oz Locke
Intro to R | Stephanie Locke
MDS and DQS – Beyond the TLAs to Data Quality | Neil Hambly

Cloud Track
Building an automated database deployment pipeline | Alex Yates
Cloud Services for Microsoft Peoples | Chris Testa-O’Neill    
Using Windows Azure SQL Database with Windows Phone | Allan Mitchell
Windows Azure SQL Database – Tips and Tricks for beginners | Tobiasz K.
SQL Azure, from plan to backup to cloud | Tobiasz Koprowski

Leeds was a special day for me. Firstly – I presented two sessions about Azure SQL Database, one as introduction, second as backup deep looking. Secondly – now I owe a special coffee for Allan Mitchell. Thirdly – since this day I’m a owner of my own super special helicopter from Violin Memory. Cannot time for play it, yet… but cannot wait for that. After packaging process we stayed for two hours for dring and fantastic dinner at local indian restaurant. Amazing salad bar and grill table and kitchen readu for grilled stuff for vegetarian. I will back there!