[PL] SQLDay 2015

Kolejna doroczna konferencja Polskiej Grupy Użytkowników SQL Server to już historia. W drodze na autobus, pociąg lub samochodem, samolotem (z Wrocławia można dojechać i dolecieć w wiele miejsc) wreszcie mam czas na zastanowienie się jaki jest bilans zysków i strat zarówno zawodowo jak i prywatnie uczestnictwa w tym wydarzeniu.

Interesując się trochę akurat tym silnikiem baz danych mam okazję uczestniczyć w wielu spotkaniach tej grupy {POLISH SQL SERVER USER GROUP} w ciągu roku. Czy jestem we Wrocławiu czy w Poznaniu, Warszawie, Krakowie, Katowicach, a nawet odległych Lublinie, Gdańsku czy Bydgoszczy, prawie w każdym miesiącu mogę spotkać takich samych fascynatów (lub sekciarzy jak mówią niektórzy) jak ja. Niektórzy mają więcej, znacznie wiecej wiedzy ode mnie, niektórzy wręcz przeciwnie – to ja mógłbym ich czegoś nauczyć.

Czwartek przyniósł mi największy problem – tylko jeden z pięciu warsztatów mogłem wybrać (bo przecież w dwóch nie dałbym rady uczestniczyć na raz. Padło na Adama Machanica, ale tylko dlatego , że pozostałe były albo po polsku albo z gatunku “opowieści o kostkach i wymiarach”, a Klaus jest na tyle blisko, że zawsze można go gdzieś w Europie złapać. W każdym razie po warsztatach nawet na kolację nie miałem siły. Powrót do pokoju zakończył się brazylijską telenowelą, bo to był jedyny sposób by moje myśłi wróciły na właściwe tory. Po zaprostowaniu moich zwojów przez Adama, tylko telenowela mogła mnie uratować. Szkoda, że Niewolnicy Isaury już nie puszczają.

Z natury jestem bazodanowcem a nie inteligentem, więc ścieżka DBA/SEC zdecydowanie bardziej mi podpasowała niż BI/DEV. Zresztą tak naprawdę nie było specjalnego podziału na ścieżki. Nie dość, że organizatorzy wszystko wymieszali to jeszcze poprzestawiali językowo. Co zreszta okazało się nie tak złym pomysłem, bo mózg mógł odrobinę odpocząć.

Wybór nie był łatwy, ale metodą dedukcji/selekcji postanowiłem się wybrać na: Anderasa Woltera – słyszałem o nim dobre opinie tu i tam, poza tym jest nowym prelegentem na SQL Day, poza tym to MCM z SQL Server; drugi w zestawie był Charley Hanania – to gość, który się mocno udzielał przy PASS Europe (tak była kiedyś taka konferencja), a skoro o niej moja to nie mogłem ominąć Pawła Potasińskiego – byłego MVP, byłego prezesa PLSSUG, oraz wciąż aktywnego członka społeczności oraz Damiana Widery – występującego wcześniej, ale wciąż przedstawiającego coś nowego; którzy mi oniej kilkukrotnie opowiadali.

Postanowiłem tez zastosować się do rady dobrych wujków i wybrać na sesje, które nie tylko zapowiadały się bardzo cieżko dla mnie, ale też były zupełnie nie związane z moją codzienną pracą – wujkowie radzili, że to najlepszy sposób na zwrócenie uwagi na coś nowego, odkrycie nowego kierunku czy też może na poszerzenie horyzontów. W tej puli wybrałem oczywiście Adama Machanica – jak nie wiecie kto to jest to wpiszcie w wyszukiwarkę sp_whoisactive, oraz nowe twarze Katarzynę Żmudę – nie tylko ze względu na ciekawy tytuł, ale dlatego że jest jedyną prelegentka (a takiej okazji przepuścić nie można) oraz Kamila Nowińskiego razem z Tomaszem Liberą – nie są jedynym duetem na konferencji ale tu znowu ciekawy temat się pojawił. Pozostało mi tylko z obowiązku wybrać coś z kosmicznej tematyki BI. W tym wypadku aby cokolwiek zrozumieć zedydowałem się na znanych i doświadczonych prelegentów Grzorza Stoleckiego i Marcina Szeligę … a co tam niech będzie w kolejnym duecie z Andrzejem Kukułą.

Co więcej o konferencji mogę napisać? Kawy nie zabrakło, żarcie z kuchni wyszło o czasie i było dobrze podane, miejsce fantastyczne (dobrze, że padało, bo tak to bym na Planty poszedł albo do Ogrodu Japońskiego). Dobrze, że przyjechałem tramwajem, bo parking mimo, że pod ziemią pod centrum to przeobrzydliwie drogi (i pewnie dlatego pusty). Impreze integracyjną z innymi uczestniczkami, uczestnikami, prelegentami i organizatorami przez grzecznośc przemilczę. Mam też nadzieję, że żadne kompromitujące zdjęcia (zwłaszcza te rozwodowe) się nie pojawiły. A mój mózg nadal paruje. Szef powinien dać mi wiecej wolnego, ale dał tylko na konferencję i jeszcze będzie chciał słuchać jak było… mógł sobie sam pojechać.

Ach i jeszcze ten bilans muszę zrobić… ale czy na pewno?

*****

Tak naprawdę to nie ja powinienem pisać ten tekst, tylko Ty, czytelniku. Masz jeszcze miesiąc na rejestrację zarówno na warsztaty:

  • Adam Machanic | “No More Guessing! An Enlightened Approach to Performance Troubleshooting”
  • Alberto Ferrari | “From 0 to DAX”
  • Klaus Aschenbrenner | “Performance improvements in SQL Server 2014″
  • Marcin Szeliga | “Mistrz danych (Data Scientist) w Chmurze.”
  • Łukasz Grala | “Projektowanie modelu wielowymiarowego danych (DimensionalModeling)”

jak i oczywiście na sesje:

  • PROCESOWANIE I PARTYCJONOWANIE SSAS OD PODSZEWKI (300)
  • ADVANCED TIME INTELLIGENCE IN DAX (300)
  • BUDGETING WITH POWER PIVOT (300)
  • POWER BI DASHBOARDING (300)
  • ŁATWY ETL PRZY POMOCY BIML (300)
  • PROCEDURY SKŁADOWANE W ANALYSIS SERVICES MULTIDIMENSIONAL (400)
  • BI SOLUTION PERFORMANCE MONITORING (300)
  • AZURE MACHINE LEARNING — NOWA PLATFORMA EKSPLORACJI DANYCH (300)
  • TRANSFORMACJE SSIS POD LUPĄ (300)
  • SSIS – DOBRE PRAKTYKI (300)
  • FROM LOCKS TO DEAD-LOCKS.  – CONCURRENCY IN SQL SERVER (300)
  • “SQL ATTACK…ED” – SQL SERVER UNDER ATTACK VIA SQL INJECTION (300)
  • OPERATIONAL BEST PRACTICES FOR SQL SERVER – NOTES FROM THE FIELD (200)
  • HIDDEN GEMS FOR IO HEAVY DATABASES (300)
  • ETL A CLUSTERED COLUMNSTORE INDEX – DEEP DIVE (400)
  • TROUBLESHOOTING TEMPDB (300)
  • IN-MEMORY OLTP INTERNALS (400)
  • INTRODUCING SQLPROXY (300)
  • UPGRADING TO SQL SERVER 2014 (300)
  • DZIENNIK TRANSAKCJI W SQL SERVER OD A DO Z (400)
  • DATA, FASTER: SQL SERVER PERFORMANCE TECHNIQUES WITH SQLCLR (400)
  • QUERY TUNING MASTERY: CLASH OF THE ROW GOALS (400)
  • QUERY TUNING MASTERY: THE ART AND SCIENCE OF MANHANDLING PARALLELISM (400)
  • WYSZUKIWANIE PEŁNOTEKSTOWE W SQL SERVER (300)
  • INDEKSY I STATYSTYKI OD ŚRODKA (300)
  • JOINS IN SQL SERVER – AS EASY AS ABC!? (300)
  • UNIQUEIDENTIFIERS AS PRIMARY KEYS IN SQL SERVER (300)
  • DUŻE OBIEKTY W SQL SERVER (400)
  • UNIT TESTS WITH TSQLT (200)

I to tylko ty będziesz mógł zrobić bilans zysków i strat zawodowych i prywatnych wynikających z tej imprezy. Mam jednak dla Ciebie złą wiadomość. Żaden księgowy nie zaliczy ci tego bilansu, bo nie będzie on na zero. Być może będziesz miał jakąś pozycję po stronie WINIEN (cholera twitter mi nie działa/kawa o siedemnastej była już o jedną za dużo), ale po stronie MA lista będzie się ciągnąć bardzo długo. Nie zwlekaj i nie zmarnuj tego czasu. Rejestracja ukryta jest pod obrazkiem:

PS. i olej majówkę jest nic nie warta w porównaniu z…

[EN] 2Q 2015 and my public speaking and presence {updated}

Second quarter of 2015 looks really busy, even with less number of travels. I’ve few confirmed sessions at conferences and user groups, and some plan for attending only. I will miss few events and unfortunetelly reject some of them. This post unfortunatelly I publish a little late than expected, but it’s still “a beginning of second quarter”.

Attendee:

This quarter will be few events when I will attend. To hear someone, to see someone, to meet someone, to be inspired. My plans are very flexible (even my calendar is not):

User Group Meetings:

  • Leicester SQL Server User Group|Leicester, England|15th Apr {SITE|TWITTER}
  • Azure UK User Group|Birmingham, England|16th Apr {SITE}
  • Azure UK User Group|London, England|27th Apr {SITE}
  • SharePoint UK User Group|Nottingham|30th Apr {SITE}

Conferences:

Speaker:

Speaking is most important part of all my events. As many of us – The Speakers – we love it. So of course I will have some chance to increasing my speakers skills here:

User Group Meetings:

  • London PASS Chapter|London, England|19th May {SITE}|session: WASD for Beginners
  • East Midlands PASS Chapter|Leicester,England|17th June {SITE|TWITTER}|session (or two): TBA

Conferences

  • Enterprise Security and Risk Management|London,England|28th April {SITE|TWITTER}|experts panel & session: Trust. The Primer
  • ITCamp 2015|Cluj-Napoca, Romania|21st-22nd May {SITE|TWITTER}|session: SQL Server Security in the Cloud
  • SPBiz Conference|Virtual Event, Worldwide|17th-18th June {SITE|TWITTER|FACEBOOK}|session: 2AM A Disaster Just Began

Trainer:

After great event in Microsoft Norge [whrere I delivered Hybrid Cloud full day workshop as second part of LEAP Program], I will back to my favourite place: Reykjavik. As always with great cmpany at Skeifan district I will deliver my authored:

  • SharePoint 2013 Administration for ITPRo Masterclass |{REGISTRATION}

Rejected events:

Time is not flexible. My outlook calendar is but with limited level only. So based on many reasons (fortunatelly all are connected with business, not private things) I had to reject my attendee as speaker or subject matter expert at some events:

  • Microsoft Ignite
  • SQL Saturday Exeter
  • SQL Saturday Varna
  • SQL Saturday Krasnodar

I know it’s always very bad news for organizers and I have full respect for their hard job and results of choice the best speaker for their events. But I have always two side of coin:

  • I can send my submission and if something happen with my clients or business things in advance I can decide to not go, reject my session and living in shame
  • I can stay at home and watch tv still thinking ‘I could be there if I’ll submit on time’

The problem only is that I have no tv screen in my flat, so I can only look on my walls.

[EN] The 2014 Year Recap. Few words about past and future…

A little different year than previous one. And I expected this, because each year should be different. Many changes in the world happened, some changes in my life happened too. Still Poland is more and more Catholic oriented country and I really don’t like it. Too many priests, too many bishops, too much money from goverment to church and of course only one kind of church. And even I don’t have any propaganda tube machine in my flat, some voices arround me still talking about it. “Power Peoples” still cannot use our public money in right way. And all politicians are liars (does no matter from wich political party). This year was very productive in some part of it. And very, very lazy in other part. It’s very stange experience for me and I definitely should avoid it in next years. I should be more productive and effective. But some goals are fery clear: more speaking, more training, listening, more learning and of course more travelling. And here is my summary based on the last years schema:

imageProfessional Job
After nine years and two months, on last day of August I finished work for corporation. And not only for this corporation, but for corporations in general. I’m changing my vision of my life in few aspects: kind of work, profits, risk and opportunities, typical working day, place for work and especially people which are now my ‘work colleagues’. I should write something about my past job but I still only thinking about it. In general my new work title: Independent Consultant, Speaker and Trainer. Norway was new country where I worked this year, and Iceland is very, very familiar – I could say it’s my second homeland. And it’s ideal weather there for me.

Teaching
I delivered few training courses (from Microsoft Official Courses Library) in Poland. And I’m very proud to deliver my authored SharePoint 2013 for ITPro MasterClass course twice on Iceland last year. And other course in Norway. Both outside Poland courses I deliver with CQURE Academy. And I’m working on new CQURE Academy project (it will be very exciting thing).

Learning
I learn about some new things, skills, features. Not too much, based on very busy time on part of year, and making lazy time on another part. I found this sentences on blog: “Perhaps the most important life skill is the ability to learn.  By learning new skills we increase our understanding of the world around us and equip ourselves with the tools we need to live a more productive and fulfilling life.  Life skills are not always taught directly but often learned indirectly through experience and practice.” And I totally agree. I’m always learning, sometimes hard skills, sometimes soft skills, sometimes I just learn how to be patient enough. And my learning process growing from last year and will grow in current. That’s my plan.

User Groups
Work life has change. Community life has changed too. Since last day of September I’m not longer Polish SQL Server User Group Leader in Wroclaw. I had less and less time for this community in last few months and because quality and regularity of meetung are most important (much, much more important than my leader’s pseudo-ego) I resigned. But I’m sure that this group in Wroclaw will grow faster. New Leader: Roman Czarko-Wasiutycz {LINKEDIN|FACEBOOK} is very active person, with good community skills and power for continuing existence of PLSSUG Branch in Wroclaw. Even I occasionally contect (and attend) for PLSSUG MeetUp (full calendar is here) I definitelly focus for PASS Community and communities in defferent countries: United Kingdon, Ireland, Russia, Ukraine,  Mediterranean and Scandinavian area. And I’m higly involved for Security Division Community with PTI in Wroclaw.

Blogging
About one hundred posts. Is enough? Statistically yes, but for me definitelly not. I should increase not only number of post but especially value of this. I should back for old series such “Sunday Market” or “Express’owe Instalacje” (last one is in Polish). And definitelly create new series. But it’s only one of few my blogs. Two of five are completely zombie place. I should do something with this.

Speaking
It was a year of speaking! Definitelly. I achieved my primary goal (planned from November 2013) which means: speaking in China. I missed MVP Open Summit in Russia (and I don’t feel good with that, but I made a choice). Speaking in China not means speaking in Chinese (even on half of my three-week trip in Middle Kingdom I was able to order something in bar or from street seller), but I had great pleasure to be part of Organizing Committee, Chair of Security Track and Session Speaker at BIT’s 3rd Annual Word Congress of Emerging InfoTech 2014.  Of course Dalian is not everything: I delivered sessions in  Wroclaw, Cracow, Lodz, Katowice, Poznan, Wroclaw, Rzeszow and outside Poland in Sofia, Kiev, Reykjavik, Budapest, Krasnodar, Cluj-Napoca, Southampton, Reading, Bristol, Cardiff, London, Leeds, Birmingham, Newcastle, Ljubljana. In few of those cities more than once.  I delivered few workshops and one full day pre-conf (in Kiev).

Social Media
”Be social, Say More, Here and Learn More, Tech Someone. They are my personal rules. Even ‘be sociable’ is not very popular in Poland (yet) I trying to use my social networks for many purposes from reading and learning through meeting new peoples, ideas, opinions, facts and fictions, to teaching and helping peoples. One of very important hashtag is of course #sqlhelp / read more at old post from Brent Ozar blog. List of my social networks expanded from last year, but core is the same: Twitter, LinkedIn, GoldenLine, Facebook.” I wrote this in last year. This year I could write same sentences with small change – using social media by community in my country is growing. And I like it!

Conferences
public-speakingNo MVP Summit last year. No PASS Summit last year. No TechEd Europe last year. No TechEd North America last year. No SQLDay Poland last year. A lot of missed events. But every speakers and conference attendees know that: it’s not possible to going in every places. But I attended of few very interesting events: Data Platform Day in Moscow, InfoSecurity in London, SQL in the City in London, SQL Saturday in Vienna, InfoTech in Dalian, UtMessan in Reykjavik, SharePoint Saturday in Hinckley.. But more important for me are all events where I delivered my sessions: IT Camp in Cluj-Napoca, CareerCon in Wroclaw, Poznan, Katowice, Krakow, Rzeszow and Wroclaw again; SQL Saturday in Budapest, Krasnodar, Kiev, Sofia, Ljubljana. It’s really hard to listing all other events which I attended: IBM IT Forum, EMC Forum, VMWare Forum, Oracle Forum, Oracle Day, BIN GigaCon, EOIF GigaCon, Do IT with Poland, and more. And two most significant conferences: of course SQLBits XII in Telford, where I (as always) worked as SQLBits Helper, but this time not only for sessions suppport and pre-canf preparation and post-conf preparation, but also supportedone ofmy guru: Allan Hirt {TWITTER|BLOG}.  Second one it was SQLRelay Tour in two weeks in eight cities, with nine sessions, many bottles of different beer, hundreds miles on the road, different hotels, and hostels and missed point on map. Very good learning time for me.

Writing
I didn’t any writing task last year. And it’s very, very bad. I never cound some news publishing or discussion board activity as writing task. I have pland for next year. Serious plan and I hope to be consistent enought to se results. I finished one good writing task – I wrote full documentation for new collaboration platform for my former employer, but… I was only one person with skils to perform this implementation and it’s not my company anymore, so… I cannot count this task, right?

Collaboration
Collaboration is working with others to do a task and to achieve shared goals {right meaning}. in opposite: Collaboration is "a co-operation between elements of the population of a defeated state and the representatives of the victorious power" {meaning in my country}. My meaning is of course the first one and I very often in my course trying to explain this difference for my students. My collaboration is focused for: SQL Server User Groups in Poland, England, Ukraine, Scotland, Germany, Wales, Scandinavia, Russia and other countries. My collaboration is focused for SharePoint User Groups in England, Spanish speaking countries and Scandinavia. My collaboration is focused on worldwide security. My collaboration is focused for mentoring newbies in IT sector ans students. And I’m always open for new challenges. 

IMG_5391Travels
Travels… I’m traveller. And I really, really like not. Not, not only.. I love it! Last year: I travelled in few cities in Poland, but of course foreign trips are most exciting. I was twice on Iceland, once in Norway (first work task in Oslo), uncounted times in United Kingdom, Germany, Romania, Bulgaria, Ukraine, Serbia (first time), Slovenia (first time), Sweden, Finland, Denmark, Netherlands. Something spectacular? Yes three points: three weeks trip in China (中国:西安,北京,大连,威海,青岛,天津,胶州), almost four weeks at last trip (Poland, Norway, England, Iceland, Serbia, Slovenia), and three weeks tour with SQL Rally (Reading, Southampton, Bristol, Cardiff, Newcastle, Leeds, Birmingham, London). Short summary in facts:  37 trips, 158 days, 102,792 km distance, 55 cities, 18 countries. Not bad, but could be better.

Recognizing
Recognition is very important. I’m proud to be honoured as MVP for SQL Server 2014, and still be in Friends of the RedGate PLUS and active member of few community groups. And even I’m Vice-Chair of EMEA Board at Global IT Community Association in March I got new recognition. From March for cadence 2014-2017 I’m Member of the Board of Lower Silesian District at Polish Information Processing Society. Three honoured recognizing presents came for me as a special community voices: first from Boris Hristov {TWITTER|BLOG|LINKEDIN} and his SQL Hangouts Video; second from Mark Pryce-Maher {TWITTER|BLOG|LINKEDIN} and his Sound of SQL Podcast; and third from EMEA MVP Community with Facebook interview. YAY!

Hardware
Almost forgot about my new equipment. With great hel of my frien Dariusz Klos as a prophet of finishing my job in corporation (without agreement to keep my old notebook) I bought new one: very light, HP ENVY 15-j017cl Notebook PC (ENERGY STAR) which actually have: 16 GB RAM, 260 SSD, 750 HDD four USB port and HDMI port, no unecessary dvd bay, and not bad resolution. Of course is full of stickers. And I got my firsf Windows Phone – old but very good Nokia Lumia 620. Still no have iPad, iPod even Surface.

 

New 2015 Year? Excited and little nervours, but it will be more exciting!