SQLRally Nordic 2012

IMG_2138SQLRally Nordic is one of the biggest SQL Server related events in Europe. Organised by a couple of very capable volunteers Raoul Illyes and Johan Ahlen this event is the biggest event that PASS is organising in Europe. Labeled as a European Nordic event, it seems that the tradition is to organise it in Sweden and Denmark, changing the location on different years.

IMG_2135This year the event was organised in Copenhagen, Denmark and I was extremely glad when one of my sessions was accepted. I was deeply honoured to be selected to present there.

I was quite surprised by the interest that apparently my session has created – because all the available places were taken and people were standing near the walls and some even sitting on the floor. My session on “Dynamic SSIS Packages generation” as a matter of fact was picked a number of times in 2012, but the most unforgettable of all the presentation for me was at the SQL Rally Nordic in 2012.

Once again I have meet so many good old friends like Hugo Kornelis, Neil Hambly, between others and also manages to get to know a good number of very interesting people from the #sqlFamily, like the organisers themselves – Johan and Raoul, and others like Leonard Lobel, Steve Simon.

I have managed to attend a good number of sessions – I definitely could not have missed some of the sessions by the likes of Connor Cunningham or Thomas Kejser.

All the event organisation for the speakers was absolutely top notch – starting from the speaker dinner and the small excursion on the bus through Copenhagen, and inclusive the amazing speaker gift and all in all relationship to the organisation team.
I am definitely writing this event as the very best event I have ever been to. The location, the number of attendance were exactly right ~450 is when it feels big but at the same time not too big, when you still able to find quickly any person you are looking for, when each and every thing looks well organised and right on time – then this is the SQLRally Nordic. :)

SQLSaturday #170, Munich Germany

SQLSat MunichI was amazingly happy and incredibly nervous when I have received a confirmation of being selected as a presenter for the first SQLSaturday in Germany. Happy – because of being selected and going back to Munich after so many years, and nervous because I knew that I would want to present in German and that the lack of practice that I have had in the recent years has definitely affected my capability of speaking this language. The other dangerous thought that was constantly crossing my mind was that I have never ever made any presentation in German.

46475_471779302853138_1588325839_nI have had a very positive advantage for my presentation – this topic was already presented in Portuguese a couple of month before, so I have received some very good feedback and tips from my local countrymen and delivering it for the second time is always at least 3 times easier then doing it for the first time.
So, I told to myself that there is nothing else to be afraid of as I have decided to jump in and deliver my “Dynamic SSIS Packages” session in German, even though I have not even checked how to say the respective SSIS terms in German.

IMG_2101PASS Deutschland Team (which consisted of Oliver, Tillmann, Constantin, Dirk and others) have made a wonderful choice of selecting Munich for the first SQLSaturday in their country. I personally think that the location was nearly perfect – it was close to the airport but also close to Munich as well. The German Microsoft HQ are really nice place to have an event, and so far I know it was the very same impression from the most of the attendees.

This event was exactly one week after the SQLSaturday in Cambridge, UK – and so I have managed to find a good number of people that I have been with 7 days before. Since Karla Landrum & Rodney Landrum were travelling in Europe, they have attended both of the events, which was a great deal of fun for me – I have managed to spend a good amount of time talking to Karla about some ideas and plans for the future of the SQL Server community in Europe. I was extremely happy to meet again the likes of Hugo Kornelis, Allan Mitchel, Jen Stirrup, Tobiasz Koprowski, between others.

In 2012 it was a good number of times (at least 4), that my session was picked up to be as the first one at the events. This situation is very interesting, because you actually don’t get a real feeling of how the event starts, since you are occupied verifying everything once again while people are arriving at the registration. So definitely at this event I have managed to get the feeling of the event only in the second part of it – since I was busy preparing and then delivering the presentation while people were arriving.

IMG_2092My presentation went quite well – I know that there were a couple of awkward moments when I was looking for the right term (though Germans do use english terms like DataFlow or OleDBSource when talking about the SSIS components), but overall I am quite happy with the presentation that I have delivered. :) I have received some very useful critics about my presentation and I hope to have learned together with the attendees a couple of things.

The rest of the event I have spent attending a couple of sessions and talking to a lot of old friends and meeting a lot of new great people like Oliver Engels, Tillmann Eitelberg, Dirk Hondong, Sascha Lorenz and a lot of others. It was one of those events where you definitely looking for more and can’t get enough of it. The day ran very fast and by the time we were leaving I have had a sad feeling that it was already over.

541143_525250557488334_731314809_nIt was not completely over yet, because the organisation team have put together a dinner at the Hotel where most of the speakers were staying, so we have shared a wonderful meal with a lot of conversation right until the moment when we were actually invited to leave, since they were closing the doors of the restaurant.

Oliver, Tillmann, Kostja and their crew have made a wonderful job of organising this event. With a great support from Microsoft Germany (starting from the availability of the wonderful HQ near Munich and including the PMM & MVP Lead both being present there).

On Sunday, before leaving back home, I have managed to get to the center of Munich and spent a couple of hours visiting some very beautiful places around.

I guard some amazingly happy memories from this event and I hope to see more such SQLServer community events in Germany next year (2013).

SQLSaturday #162, Cambridge UK, part 3

Buck WoodyThis was one of more social events for me, as I have managed to speak with a lot of people including the likes of Karla Landrum, Jen Stirrup, Allan Mitchel, and of course Mark Broadbent and Lorraine. It was great to see a number of companies sponsoring this effort, as without their support a lot of such great initiatives shall be quite limited – so I did my best to talk to them all, in order to learn better about their products. If you are enjoying any event, you should really try to say it not only to organisers but to the sponsors as well.

I have managed to attend a couple of sessions, “Windows Azure from a Data Perspective” by Buck Woody which was a really great one and “Troubleshooting SQL Server with PowerShell” by James Boother, where once again I was serving as a session monitor. Both sessions were really enjoyable and for those looking to get an understanding of both technologies (Azure SQL Database & Powershell) they were really not to be missed.

CambridgeThis was one killer event, and every time I think about having courage of running a SQLSaturday, I really think of Mark who showed a great courage of risking loosing his own money in order to make this event happen. I really believe that people who attended it should show a token of great appreciation for all that he has done for the local English SQL Server community.

Once again I think that the effort of the organiser’s partner should be underlined, as Lorraine has sacrificed a lot of her personal time in order to support Mark with this whole idea of giving something good for the local community.

Cambridge_3I have spent at least a half of Sunday visiting some of the amazing sightseeing that Cambridge and Ely offer, and there is no doubt that all the area around the first SQLSaturday in the UK is to be explored in the nearest future, hopefully this time with my family and with more time to explore all the cultural and historical treasures. I would recommend to anyone this event – you will get much more then you would expect – a great SQL Server learning, a lot of new personal connections and friendships and you might even stick for a couple of days because of the amazing environment.

I expect that in the year 2013 this story to be continued…

Going to and presenting at SQLSaturday #170 Munich

The first SQLSaturday in Germany is just a couple of weeks away and I am so excited about it. Knowing one of the organizers – Constantin Klein, I am confident that this event will be a great success and generally I am genuinely excited that Germany is finally stepping in for one of the best tech community events in the world. Looking at the presenter’s list, it feels like a very serious SQL Server experience – Hugo Kornelis, Allan Mitchel, Dejan Sarka and Jen Stirrup between others are very recognized in the community.

Doing the first SQLSaturday in Germany in Munich is an obvious choice for me, since Microsoft’s Headquarters in Germany are located exactly at the location of the SqlSaturday – at Unterschleißheim, near Munich. There is no need to describe the beauty or the importance of the Munich as a city on a global level. Coming there once in a lifetime is a must for anyone looking for culture or business.

I am very happy and deeply honored to be selected as one of the speaker, and I will be working fiercely to improve my presentation on “ETL Frameworks with Dynamic SSIS Packages” which I have already delivered exactly 2 weeks ago for my local Portuguese PASS Chapter. I will be doing my very best to deliver my presentation in German, so it will take some serious work from my side, since it has been quite some ages, since I talked German in public.

I am looking forward to meet and greet German SQL Server Community and to meet some good old friends like Mark Broadbent, Milos Radivojevic, Jen Stirrup and Hugo Kornelis between others. If you live in Germany, then there are definitely very few excuses to not to be at the single most important SQL Server Community event of the year in Germany.

Going to SQLSaturday #162 Cambridge

My good friend Mark Broadbent and his team are organizing the very first official SQLSaturdy in the UK – The SQLSaturday #162. This is going to be a huge and important landmark for the SQL Server community in the United Kingdom, which important can not be underestimated. There were already 10 editions of SQLBits with Saturday offering a free entrance for anyone, but this is a different kind of an animal – this is a SQL Server community event which I expect to set a new high standard on the SQL Server events.

Besides the free SQLSaturday, the SQLCambs team are organizing 3 pre-cons on friday with 3 great specilaists – Jen Stirrup, Buck Woody and Mark Rasmussen. This is going to be a very tough choice for the most SQLPeople for sure. I highly recommend anyone and everyone signing up and attending those pre-cons. I am loooking forward to find out if I can get a day extra to attend one of them. Which one? – I am not sure, since all 3 of them are looking so damn good. :)

I think there must be very few people in Europe or for that matter around the world, who has never heard about Cambridge – their University is constantly being referred as a top-5 University worldwide. Cambridge technology pool is also know for some big corporation that it has produced, and for SQL Server people, it will be enough to refer the name of Red Gate Software.

I feel deeply honored to be selected to present at the SQLSaturday #162 Cambridge. The organization committee has selected my session «Inheriting a database for Developers» and the moment I have received the confirmation started randomly jumping around my chair – with my coworkers probably picking up their phones and calling for the emergency and security. :) haha. I have already presented this session almost 1 year ago at SQLPort, but I am already working for a new version which I expect to have some things in common, but to be a new generation of it, a version 2.0 so to say.
I cant make any promises, besides that I will spend the biggest amount of time I have ever spent preparing a presentation, because I really want it to rock.

I am looking so much forward to this event that I really can’t describe – there are so many great people that are going to be around: Mark Broadbent, Neil Hambly, Jen Stirrup, Laerte Junior, Karla Landrum, Hugo Kornelis, Gavin Payne, Andrè Kamman, Rob Volk, Andy Leonard, and much more!

SQLSaturday#148 part VI

SQLSaturday #148 Speaker party was a dinner, and for those who attended it, it will stay in the memories for a very long time. Looking at the picture – do you see anyone being unhappy or unsatisfied? The dinner was absolutely amazing if you ask me – the food and the company were memorable, and we simply have had fun, enjoying the moment.
I have to say that I feel honored sharing all those moments with each and everyone who were present, and that the connections that were made at this event are to last.

Besides enjoying the company and having an enormous amount of fun, we still have had time to share our impressions on the event, to discuss some things that went right and wrong, and make some expectations on what the future might bring to the Chinese SQL Server community. Everyone wants to see the results of their work, their impact, to see things growing, each and everyone wants to leave their print on whatever they choose to do – and knowing that we did our best to help SQLFamily in China to grow is definitely a big satisfaction for me.

Sure thing, nobody knows how things will look in the future, but there was a strong spark of the community which should help community to carry on, reaching for better and bigger results. :)

On the next day, Tiffena was kind to take Mark Stacey, Matt Horn and myself for a trip to Suzhou for a Humble Administrator’s Garden visit. Besides being an amazing place by itself, this short trip (around 110km) provided me with a better understanding & insight into the Chinese society normal life. I have had experienced different types of transportation – subway, local train, bus, catching a cab on the train station (easy), catching a cab near the Gardens (impossible). :)

This was an important experience for me, because it was an outlook on a real life, that people in China are living.

There are actually very few words that can describe the beauty of the gardens – you gotta just walk around, get lost in them to be able to feel them. I enjoy greatly staying in any garden – being surrounded by the nature is a big pleasure, and I certainly believe that the gardens are created for relaxing and viewing pleasure – so if you are inviting me for a walk in Garden, most certainly I will accept it. The Humble Administrator’s Garden had a lot of places to view and a lot of opportunities to sit down and have a talk – which we certainly did a number of times through the day.

The main problem I have had during that day was the exhaustion and the temperature combined with a humidity – it was absolutely devastating. I had to stop, sit down and drink a lot of water in order to be able to carry on. Especially the humidity was something which I have found out was quite difficult to support. The beauty of the gardens and the company were really compensating – I have had so many great conversations that I am constantly coming back to, though it is being almost a month that since this trip has passed. The positive things were in such a superior quantity, that they are what I cherish the most from this trip.

This is a photo was taken near the gardens and when I look at it – it takes me back into a different century, into a different time and space where people were living in a much simpler way. I wish I had an experience of spending a week exploring this beautiful places like Bill Graziano did. I am sure that one day there will be an opportunity to come back with my family and explore chinese cultural heritage. :)

(to be finished)

SQLSaturday#148 part V

I have already written IV parts about my SQLSaturday experience in Shanghai, but this will be the first which will be dedicated to the event itself. Warning – this post is an honest point of view, and while you might not agree with it at all, it represents what I think and feel about the event itself. Do not forget that it takes so much courage and personal time to organize any event, and all organizers of the SQLSaturday #148 Shanghai deserve a lot of respect for all the hard work that was done. My most sincere admiration goes to Tiffena, who was the driving force behind this event, while being thousands of miles away in Seattle.

The schedule of the event was very nice for the first event of this kind in China – with PASS President Bill Graziano opening the “sql hostilities”, and then bringing some serious BI firepower with Pragmatic Works South Africa founder Mark Stacey. Han Wong then delivered the first chinese speaking session of the day, and then it was my time to carry one the mission right into the lunch break. After the lunch and some very interesting conversations with some of the attendees, we had another Pragmatic Works SA guy, Matt Horn delivering a very interesting session on the SSAS manipulation with a SQL Agent. The finishing touches for the event were given by Wee Hyong Tok and Miguel Granados, who were presenting on SSIS and DQS respectively.

Every great event has some things to improve, and this one is no exception – first of all, I felt that the right balance between the local and the foreign speakers was not achieved. I always try to balance the events I am organizing by giving around 50% of the time to the local speakers – this gives the opportunity for them to grow their CV into a bigger international events. Also, the event felt like a simple mixtures of sessions and not a cohesive event which were telling a story to the attendees: BI was dominating the event, but there were 2 T-SQL sessions (Bill’s and mine) and there was also some Azure with a Data Sync Introduction. I would like to repeat once again though that for the first SQLSaturday, organized by the people who has never been to a one, it was a very solid effort.

The expected number of attendees as we were told by Tony was around 70 (exact number of the registrations), which was quite surprising as for example in Portugal we have a rule of 2/3 for any big events, which means that only around 70% of the people will appear. The final count for me was 48, but I admit that I might have missed a couple of people. Also to note is that the knowledge and the experience level of the attendees was far from what was expected – the crowd was most definitely not a advanced professionals group as we were told a day before.

Unfortunately for Bill Graziano, he had to find out about it in the worst way – while delivering his presentation (having some advanced topics), because of the lack of the feedback he asked how many people actually knew how to read and to us the execution plans of the SQL Server. At this very moment I was extremely close to getting a heart attack, because there were only 3 people in the crowd who responded positively on his question. Since I have had 2 hours before my presentation, I started rewriting it in panic, throwing away all more advanced stuff.

From my personal experience of the event I really enjoyed it a lot, though I had to skip some amount of the presentations firstly because of the changes that I was doing to my presentation and secondly because of the timezone difference. I almost felt asleep at one of the sessions, and so asked Tiffena and Bill Graziano to accompany me to the nearest place to get some coffee.
I was a kind of fascinated by the Wee Hyong Tok’s presentation on the new functionalities in SSIS because I really enjoyed it a lot, and because I felt like I was really getting what he was saying in Chinese. Maybe it is because I already tried the new SSIS in SQL Server 2012, but I am really confident to say that it is definitely has to do with his skills as a presenter. To get an attention of somebody living half across the globe, while speaking a language which has nothing in common – this takes a lot of skill to do. :)

My own presentation went quite well, and I felt that I have managed to get the people interacting, which is always important when having a language barrier. The question about the EXEC WITH RESULT SETS function, asked by Peng, really brought me to investigate better the new functionality and I am definitely coming with a blog post on this matter in the next weeks. I am definitely looking forward to coming back and presenting once again in China in the future.

By the end of the event, all of the international speakers were really ready to take some rest. Actually the event ended sooner as planned because one of the local speakers did not show up, but the timezone difference, the hot temperature and all the excitement were definitely getting the best of us. We were ready to get some rest before the speaker party, organized by Tony & co.

Lessons learned :
1. To be more flexible and to be ready to change your presentation on the fly if you see that the attendees are simply not ready for the material. Naturally it depend on the situation, and if you have just a small part of the attendees that have no knowledge to keep up, then give a small introduction in order to bring them a little bit up to speed.
2. If your are presenting in a non-English speaking country, then adjust .. your .. presentations .. speed. The people might have difficulties in understanding some of the words and terms or they might be having difficulties in translating your accent.
I think that I have got a lot of interaction with the crowd, because I managed to speak slowly and adjusted my presentation to a simpler level.

Update on 17th of July, 2012: Tiffena sent me a message saying that actually after contacting a number of the attendees after the event, she found out that they have considered the presentations to be quite simple and easy. One more lesson for me to learn: in a multicultural environment you never know until you know.

(to be continued)