[EN] T-7 Days till my next session… at SQLSat Manchester

LOGO__SQLSatManchesterA week in advance annoucement. I’m very happy to be one of the speakers at upcoming SQL Saturday No 418 in Manchester (England). This conference will be hosted by my very good friend Chris Testa-O’Neill {BLOG|LINKEDIN|TWITTER} and his team in very interesting place. The event will take place at the Mechanics Institute in Manchester. Founded in 1824, it’s goal was to provide adult education to the local area, especially in the areas of science and technology.  This SQL Saturday will be splitted for two days:

Friday: with six excellent pre-conf/workshops:

  • SQL Server Business Intelligence | Chris Testa-O’Neill
  • Database source control workshop | Alex Yates
  • Practical R: A hands-on training day | Stephanie Locke
  • Building Big Data Solutions with Microsoft Azure HDInsight | Graeme Malcolm
  • SQL Server 2014 In-memory technologies – Columnstore, In-Memory OLTP | Tony Rogerson
  • Machine Learning without a PhD in statistics | Andrew Fryer

Saturday: with twenty nice more excellent sessions focused for topics: Business Intelligence, Azure, Business Analytics, Data Practices and DBA. And list of speakers is really, really impressive:

Bob Duffy + Satya Jayanty + Chris Testa-O’Neill + Gavin Campbell + Dmytro Andriychenko + Alex Whittles + Stephane Haby + Graeme Malcolm + Stephanie Locke + John Martin + Alex Yates + Ben Cooper + Steve Wharton + Ian Macdonald + David Dye + Kevan Riley + Andrew Fryer + David Williams + Terry McCann + Uwe Ricken + James Rowland-Jones + David Morrison + Adam Aspin + Neil Hambly + Emanuele Zanchettin + Tony Rogerson + Chris Adkin

International company, many experts: MVPs, MCMs. A lot of ons of discussions, coffee, comments, swags, networking opportunities and Saturday full of knowledge.

I will present one of my favourite session AD 2015. 2AM A Disaster Just Began… at 1:30 PM in Dean Room.

More details and resitration are available at the conference page: http://www.sqlsaturday.com/418/EventHome.aspx

[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.