[EN] SQLBits XIV – pre-conf, sessions, discount and community

Largest SQL Server conference in Europe. Legendary SQL Bits. In March 2015 fourtheenth edition named: SQLBits SUPERHeroes will back to London {CONFERENCE PAGE}. This edition will be largest than ever, and most interesting ever. With some changes about pre-conf, sessions, and events arround everything sounds exciting. The orginizers team listen the audience, and this is result of it:

Precon Training

Duration: One Day

A full day of immersive content delivered by world class experts in their respective fields. These sessions are designed for you to focus on the subject of your choice. SQLBits XIV has the biggest range of precon sessions to date.

Normal Sessions

Duration: 60 minutes

The traditional format of SQLBits has been to run 60 minutes sessions on a given topic. We still continue to support this format during the course of SQLBits XIV 

Extended Sessions

Duration: 75 minutes

New to SQLBits XIV, and based on feedback by speakers as well who cite that some sessions require 75 minutes to deal with more complex or longer topics.

Double Sessions

Duration: 2 hours with a 15 minute break

When you are able to attract the best speakers in the world, we all want to spend more time with them. The Double session always both attendees and speaker to provide greater insights into the topics they present.


LOGO__SQLBits_SuperheroesDo you need more? Start to plan how many days you will spend in London, based on this question: What happens during the days?

  • Wednesday – Is a day dedicated to the Precon session format
  • Thursday    -  Is a combination of all the formats with half of the conference centre dedicated to the precon format, the other to the other formats
  • Friday – Is a combination of normal, extended and double sessions
  • Saturday– Is a combination of normal, extended and double sessions

Hundreds of standard sessions has been submitted and you can vote for those sessions (ten which you want to see) here. And if you are not sure about Pre-Conference seminars, look for the list:

Wednesday 4 March 2015

  • Become an Enterprise DBA with Sean McCown and Jennifer McCown Managing hundreds of servers is difficult if you haven’t been shown how. You need to change the way you think about your environment. Learning syntax isn’t enough. You have to put the different strategies together to be able to exercise your vision.
  • SQL Server Reporting Services with Chris Testa-O’Neill This precon will explore the creation of reports, through to the deployment and management of reports into production. Providing you with the ability to work productively with Reporting Services after completing the precon
  • Mastering T-SQL Querying Fundamentals with Itzik Ben-Gan T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
  • Understanding Execution Plans with Hugo Kornelis Reading and understanding execution plans is key to understanding and fixing ill-performing queries. This full-day seminar will teach you everything you need to know about execution plans. Attend this seminar if you want to hone your tuning skills!
  • Upgrading to Microsoft SQL Server 2014 with John Q Martin With Microsoft SQL Server 2005 going End Of Life in early 2016 it is vital to start planning your migration to a supported version of Microsoft SQL Server. let me help you get ready for this by helping you understand the process and tools available.
  • Storage and Virtualisation for DBAs with Denny Cherry This session will be a two part session in which we will be focusing on two of the biggest topics in the DBA field. How to properly design your SAN storage solution and how to properly design your virtualization solution.
  • Optimize “All Data” with a modern data warehouse solution with Adam Jorgensen Most of the world’s data exists in a combination of on premise, cloud and non-relational forms. This session will teach you the options, best practices, and patterns to acquire, store, process and analyze all forms of data in a modern solution
  • A practical guide to using charts & graphs! with Dan Bulos Choosing between the multitudes of chart types can be challenging. The session will cover how to select the right style of chart to accomplish your purpose, whether that is analyzing data to gain insights or producing a dashboard.
  • Better Performance Through Parallelism with Adam Machanic This full-day seminar will teach you the ins and outs of Windows scheduler internals, SQLOS, intra-query parallelism, and patterns that can make your parallel queries many times faster. After attending you will be in full control of your CPUs.
  • Data Wars: The Cloud Awakens with Matt Masson Come to this session to see the forces of business and IT armed with Power BI for Office 365 and Azure Data Services do battle with an increasing number of challenges in the workplace. Who will win?
  • A Day Inside SQL Server with Bob Ward If you want to know the internals of SQL Server then this is the session for you. Prepare to have your brain melt in this deep session from the man who knows.

Thursday 5 March 2015


And of course is not all. Pre-conf and standard conference day (Wed, Thu, Fri) are paid. Early bid price for full four days and SuperHero Party is 699 GBP. But as always Saturday is community day – so you are very welcome, even you not have budget for full four days (and You can join for Friday’s SuperHero Party). If you are member of SQL Server Community – doesn’t matter from where (from SQL Server FAQ in United Kingdom, or from Polish SQL Server User Group in Poland, or from different community)  you can get 5% discount from your User Group Leader – just ask.

I will be there, so see you in London ExCel!

[EN] Sounds of SQL

I’m always, always exciting of any new community activity. Few months ago I was invited for SQL Hangout  – series of Google Hangout Videocast provided by Boris Hristov {TWITTER|BLOG} Bulgarian SQL Server MVP. My episode have number #008 and recently Boris published episode #024. You can fing all of those at his blog.


On last day of SQL Relay 2014 Autumn Tour, in London, friend of mine and active member of UK SQL Server User Group informed me, and very quickly invited for his new activity. Sounds of SQL is a fantastic project running under Mark Pryce-Maher {TWITTER|BLOG|LINKEDIN} invention. How it works? Mark catched almost all speakers on last day of our conference, and steal five minutes for short interview. Results?

Really good! First of series of 5-min interviews is ready and you can listen, and download from the Sounds of SQL project site HERE (site is hosted on Microsoft Azure Services!). And here is the result:

Matt Dowle is the main author of the data.table package for R. Matt has worked for some of the world’s largest financial organizations and has been programming in R for over a decade. Check out his talk from the R conference in LA earlier this year.  http://datascience.la/matt-dowles-data-table-talk-from-user-2014/ Matt has kindly given us at 10% of coupon ‘MY-DATATABLE-COUPON’ for his training course on Data Camp:  https://www.datacamp.com/courses/data-analysis-the-data-table-way?referrer=GitHubWiki

Please add this page for favorites, follow twitter accout: @SoundsOfSQL and enjoy!

[EN] Anorak in the UK – Summer Tour

Friday 14th June. I’m still “in recovering mode” after my long trip in May and fantastic birthday Saturday in Edingurgh (I will blogging about #202 soon). And I’m close to finish my crazy 62-hours work week in my data center. Even I’m little tired, with mass of “TO DO NOW” targets (or “IT MUST BE DONE for YESTERDAY”), I’m trying to prepare my sessions for next long, hard and heavy week in UK. Few months ago I did Spring Tour, now is time for summer. My Summer Tour will start in Glasgow (Scotland) and finish in Dublin (yes, Ireland are outside UK). March Route is very big:

>> First Part : SQL Relay 2013 | LINK #SQLRelay |

June 17th | Glasgow | Cineworld, Renfrew Street | direct link
June 18th | Leeds | Leeds Art Gallery | direct link
June 19th | Birmingham | Crescent Theatre, Brindley Place | direct link
June 20th | Norwich | King’s Centre | direct link

I cannot write something better than Head Organizer: Alex Whittles wrote in last mail for SQL Server FAQ members list:

LOGO__SQLRelay2013It must be some kind of mistake… Or you just haven’t heard the stunning lineup of speakers that we’ve got for you?.. SQL Relay is coming to Birmingham on 19th June for a full day of SQL goodness, and you haven’t registered! Are you ok? We’re importing Kevin Kline (MVP), Grant Fritchey (MVP) and Scott Klein (Microsoft) from the USA, and Anthony Saxby & Andrew Fryer from Microsoft UK, not to forget Tobiasz Koprowski (MVP) from Poland and Rich Douglas from Quest/Dell. And if that isn’t enough, there will be pizza & prizes (A surface RT, RedGate Toolbelt, and more!). Oh, and it’s free! Get yourself over to the registration page and sign up now before it’s too late (3 of the 8 relay events are already full…). If you know SQL people in other parts of the country, then there are also Relay events being held all over the UK (Glasgow, Leeds, Norwich, Cardiff, Southampton, Reading & London) – help us spread the word!

My silent advice: even registration is full, as always few people never appears, so You can go for one of this event, and I’m almost sure that you will enter to this event.

>> Second Part : SQL in the CITY| LINK #SQLintheCity |

June 21st | London | Congress Centre, 28 Great Russell Street | direct link

LOGO__SQLintheCityAfter fantastic first edition, two years ago, and absolutely amazing last year’s event, RedGate announced 2013 edition. Free, full of Redgate folks, tools and worldwide experts: Steve Jones, Grant Fritchey, David Atkinson, Gail Shaw, Simon Galbraith. Fourteen sessions, free luch, tons of free swags, books, licenses, gadget. And finally – this time without me – great Redgate Ale! Subject: Query Tuning, Azure SQL Database, Team-based Development, Cloud, Monitoring, Encryption, Backup and Recovery problems. This event for me will be only attendence mode. So my plan is simple: three first sessions in Congress Site and dissapearing…

>> Third Part : SQL Saturday No 229| LINK #SQLSat229 |

June 22nd | Dublin | Hilton Hotel, Charlemont Place | direct link

sqlsat229_webMy last saturday with es-qu-el as a speaker. it’s not in UK, but last is not least. I will present session abour SQL Azure in beginner level, but it’s interesting (as I heard in Kiev and Edinburgh). All ettendees have big problem: problem of choosing right sessions: Seven of 28 (no, Seven of Nine will not come). Last year it was very succesfull event. I’m sure that this time, second SQL Saturday in Dublin will be great event too. Based of great organizers team (similar to last year) and great speakers: Jen Stirrup, Christina Leo, Kevin Kline, Mark Broadbend, Gail Shaw, Niko Neugebauer, Chris Webb, Matija Lah, Bob Duffy, Matt Masson, Neil Hambly and many more. And I waiting for two fantastic member of Women in Technology from (almost) Poland…

In short summary: hundreds of miles, five sessions with sharing knowledge and prectices (bad or good) and about fifteen with learning. Very intensive week. Ooopppppssss. I almost forgot: and visiting Leicester’s family between Norwich and London.