[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] 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!

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