[EN] MAY 2016 and my public speaking and presence

April was a little busy month, again. But May and June (ok, next six-seven weeks) will be extremely busy. I have been registered for few events, most of them as a speaker, or community helper. With connection of my ‘making money’ life and family business things in May… my schedule is almost full.


To hear someone, to see someone, to meet someone, to be inspired. My plans are a little flexible (even my calendar is not):

User Groups Meetups:

  • SharePoint User Group UK West Midlands|Birmingham, England|11th May {SITE}
  • Information Security Division PTI Poland|Wroclaw, Poland|24th May {SITE}


  • SQLBits XV – Not of This World|Liverpool, England|4th-7th May {SITE}


  • SQLBits Pre-Con > DBA 2.0–How to Advance Your Career in a Changing Landscape |Liverpool, England|4th May
  • SQLBits Pre-Con > New SQL Server Upgrade and Migration: Project Chinook |Liverpool, England|5th May



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:


  • SQLDay 2016 – VIII Anniversary PLSSUG Annual Conference|Wroclaw, Poland|17th May {SITE} | one session: AD 2016. 2AM A Disaster just began…
  • Data Security for Government Organizations|Warsaw, Poland|18th May {SITE} | Opening Debate: TOP 10 intriguing issues related to information security and one session: Mirage of Security (Part. 3): Untold
  • SQL Saturday No 508|Kiev, Ukraine|21st May {SITE} | one session: AD 2016. 2AM A Disaster just began…
  • IT Camp 2016|Cluj-Napoca, Romania|25th February {SITE} | one session: Encryption in SQL Server in AD 2016


  • SQL Saturday No 508 > Storage, Backup and Restore Management in the Cloud World|Kiev, Ukraine|20th May



I have two confirmed internal training in May:


  • Core SharePoint 2013 skills|Manchester, England|10th May
  • Corporate Strategy for IT|High Wycombe, England|12th-14th May


As You can see, a lot of places and dates where and when you can meet me. Hope you will find a moment to say Hi!

[EN] Reminiscence Boulevard–SQL Bits IX (Liverpool)

LOGO__SQLBitsI suppose… No I expect, that All of You, my SQL Server Family Members have a plan to go for minimum one SQL Server Event in next year. If You living in Europe, You have no choice (in first half of 2012 You can go for two, maybe three events oriented for SQL Server). One of this is SQL Bits. I wrote about my last experience of this, no, of THIS event.


Last edition of SQLBits IX was held in Liverpool (September 29 – October 1), and called: “Query across Mersey”. As almost always I went from Wroclaw to reception desk)East Midlands, meet my family (especially my goddaughter) and went to Liverpool (with excellent bus service National Express). I came to Liverpool about 1PM on Wednesday (28th), found my early booked hostel (with Polish person at , check-in and in the afternoon (after half hour or searching) found Conference Venue: The Adelphi Hotel (Ranelagh Place Liverpool L3 5UL). In place I meet The SQLBits Team, with many old friends and some new: Anette, Jonathan, Allan, Christian, Jamie, Mark, Christina, Simon, Andree, Maciej, John, Dirk, Kevin, Chris, Thomas and more. About 6 PM we started preparation. It was similar talk, like Previous Edition – SQLBits VIII in Brighton. In few hours we’re packed conference bag with information materials, gadgets and other nice stuff. Between un-formal competition (eg. between Mark and Me in “BADGE PACKAGING”), beers and pizza we talk about community, future and of course SQL server.

I have had interesting experience when I back to my hostel, I saw fire on three. I called for 112 and after three minutes of explanation, fire officer asked again: Where EXACTLY You are? I made mistake: I was on Brunshwick Road, but I said Brunshwick Street (different place in Liverpool). But they found me in two minutes. New skills: remember where on which kind of area You are: street, road, alley, avenue, square…

You can find You, Your friends and our stuff on my FLICKR EVENTS: SQLBITS9 Query Across Mersey [Wednesday Set]


Thursday morning. Alarm clock started about 6:30 AM (it was not easy, but I done this target). Short breakfast, coffee, mail checking and go to hotel. The venue was very close, about twenty minutes on foot. Firs day it was my first day as SQLBits Helper. I was a member of the special division under command and control by Annette Allen (better known as Mrs. Fatherjack). My target for Thursday was very clear: Reception, Marshaling, Community Corner, general conference attendees frequently asked questions, and preparation for next day (and evening). On Thursday I meet first time new fantastic peoples: Darren, Martin, Victoria, Tim, Karla, Laerte, Allan, Aaron, Kevin and of course Best-Room mate Mr. Neil. and more, more, more. All attendees was very surprise, because badges was sorted by Name (yes – First Name) not as standard by Surname. A lot of very funny questions: Wait, what is my name? After midday, when we finished, I went to sightseeing Liverpool. This part require separated story on my private blog, maybe next week… But you can look for my Photosynth small set HERE.

Back to the venue about 5PM to start preparation for the evening. For Thursday the SQLBits organizers prepared interesting music evening. About 8PM we can saw another face of Chris Testa-O’Neil with his band TRIPOD. It’s generally cover band, but sounds really good. In my opinion better than cover band of The Beatles (probably played after Tripod) but… With some of new friends, old friends, speakers and influencers we went to China Town for special Speakers Dinner. Oh it was really crazy experience: Chinese district with open-air cinema with Chinese horror-fantasy movie on very big screens. You know: the Hero can jump for hundreds meters and flying and… nevermind. Something interesting for eating in Chinese restaurant with very good Tsingtao (one of the most popular beer from China from 1903! more HERE). When we back, we talked very, very long – but… hostel was twenty five minutes away…

You can find You, Your friends and our stuff on my EVENTS: SQLBITS9 Query Across Mersey [Thursday Set]


Friday morning the blood still on my hand… No, sorry. It’s not review of Dream Theater’s Metropolis P: 2 album. Friday, very heavy and hard and long morning, I back to the Conference Venue. First target: coffee, next SQLbits Helpers as Marshall with Victoria. It was really nice and funny. The badges surprised again. On Friday I have meet first time Allan White, Andy Leonard and some other new (for me) peoples. Really Exciting! You know three years ago I hadn’t dream about it. Now it’s more simple. Of course I can’t forgot about Kevin Kline, Aaron Bertrand, Klaus Aschenbrenner, Steve Jones, Hannah Jermy and all teams from exhibitors: Fusion-IO, SQLSentry, Coeo, Microsoft UK, RedGate, Quest, Idera, Adatis and more.

Because standard conference day just started, I had more tasks, ordered by Annette. I had Room Monitor (You probably know what is it: checking the facility, power, projector, speakers, microphones, keep timing, and so on) for two sessions. For two GREAT sessions. For TWO EXCELLENT SESSIONS!! Yes, I must scream it! First session which I monitor was provided by Steve Jones {BLOG | @way0utwest} with subject: Preparation for Disaster {Sooner or later some sort of disaster occur on your SQL Server instance. It might be the destruction of a server, the corruption of a page inside the database, or just the unexpected deletion of some data. When disaster does strike, will you be prepared? Steve Jones will cover a number of common disaster occurrences and the ways in which you can be prepared to handle the situations}. You can see this session HERE. The second one on Friday was provided by Jennifer Stirrup {BLOG | @jenstirrup} with subject: iPad and Powerpivot-Mobile Business Intelligence in action {Mobile Business Intelligence allows end users to access data to support their decisions, irrespective of time and place. The Apple iPad is the definitive tablet of the decade, and is game-changer as a credible business tool. PowerPivot is a game-changer because it places data, and data structures, back in the hands of business users. Apple’s cutting edge usability, along with PowerPivot’s accessibility, can be combined to enhance productivity for mobile business users. Together, these technologies can support Mobile Business Intelligence as an essential tool for end users who need data ‘on the go’}. You can see this session HERE.

Evening with James Bond Cassino was not for me. OK, Almost. I haven’t special uniform/costume/dress for going to the Casino. Anyway I spend all evening from 6:30 PM with big friendly SQL Server Family. I want to say Thank You for John Martin (aka @SQLServerMonkey) for hours of learning of the English culture and traditions. We will continue this… We drunk a lot of Guinness – I preferred Guinness or Murphy’s (it’s just for SQLbits organizers info) with fantastic peoples, beautiful girls (even lives in London and from Poland). Again exciting language experience, speaking naturally (almost) in English, sometimes in Polish – especially without people from UK. I meet fantastic pair from… Plymouth. We went for small dinner and back about midnight. When the event finished, my new colleague from Poland and I we went to long talk (over one hour outside), next I back to hotel’s pub for… Guinness of course. I back to rom very early morning (about 3:34 AM) just for 3 hours sleeping with ghost.

You find You, Your friends and our stuff on my EVENTS: SQLBITS9 Query Across Mersey [Friday Set]


Morning… Saturday Morning… Is something which I remember? Yes. I was very tired. But coffee, friends, breakfast and friends keep me alive. I server a little less marshaling on Saturday. And spend more time in community corner. And meet new fantastic person: The Canon-Girl, beautful girl fromw Ireland. Thank You for talking about cameras, Carmel. I have two sessions for monitoring too. Another kind of sessions, in some of different subject, but interesting. First, provided by very interesting Dutch-Swedish SQL Server enthusiast Ola Hellengreen {BLOG} with subject: Inside Ola Hallengrens Maintenance Solution {How do you do database maintenance in an enterprise environment? I have developed a stored procedure based solution that has become extremely popular in the SQL Server community. In this session I will go through how the solution works, how it can be used in different scenarios for backup, integrity check, index and statistics maintenance and talk some about the background for the design. You can also bring your questions about the solution or about database maintenance in general}. You can see this session HERE. And the second one on Saturday, my fourth and generally last session at SQLBits 9 was presented by Dave Ballantyne {BLOG | @davebally} with subject: Whats new in Denali-TSQL {A look at the new TSQL functionality within denali}. You can see this session HERE.

After half hour after last session end The Master Of Ceremony: James Rowland-Jones starts the Final show, with many “Thank You All” with special thanks for Annette and other SQLbits Helpers. And at the end every exhibitors raffled a special awards and gifts for the attendees. Really great awards: Free Entrance for PASS Summit, or Super-Spy Flying Predator (from Fusion-IO) and many, many more.

Two hours of collecting things from event venue, packing all our stuff (ducks, stickers, books, demos…), and with a big hungry SQL crowd, we went for beer, dinner, beer, talks, beer, beer… and beer. I discovered – Super BIG, BIG Thank You Christina – Awesome Spanish Tapas Bar La Tasca. You must go there when You will be in this city.

You can find You, Your friends and our stuff on my EVENTS: SQLBITS9 Query Across Mersey [Saturday Set]


My friend, Allan Mitchel {BLOG | @allanSQLIS} invited me for Lightning Talks. In fact twice: on Friday and on Saturday. What is LT? Based on the SQLbits site: A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love. Presented by Various Speakers. It’s really amazing experience. Just five minutes, sometimes almost not prepared, just: go to the stage and talk about SQL Server in Five Minutes. I prepared short session titled: 2AM A Disaster just Began – about best practices to survive disaster. Both my micro-sessions was funny and interesting for attendees and after talks, I received some good comments, and wishes for full session next year. Thank You friends. Thank You Allan Mitchell. And thank You all supporters: Jen, Laerte, Karla, Christina, Thomas, Mark, Allan, Annette, Neil, Richard, Andrew, Martin. You can see some of those sessions from SQLbits VIII (Brighton) here.


It was my third time at

SQLBits Premier European SQL Server Conference

in order: York (autumn 2010), Brighton (spring 2011), Liverpool (fall 2011). Every time received more knowledge, opportunity to give help for other, possibility to get help from friends, share knowledge, meet new peoples and make some special gifts. I’m sure that it’s not last time. If You are a little bit, more or less, familiar to SQL Server… If You are newbie or freak or nerd… Just save the date on every of bi-yearly editions and go!

I expect to go for every next editions till they will happen. Hope to be full session speaker next time – even my English is not excellent. But I’m still working on it. Hope to be invited for SQLbits Helpers Team again. Hope to find enough time to meet all of You, my SQL Family Members.

So, see You in 2012…

[EN] SQLBits voting ends soon!

So, folks. SQLBits 9 is coming. A little earlier which I expected, but the date is acceptable for me (of course, I’m kidding). This time, second of year-2011 edition will happen in Liverpool on last September’s weekend. The formula of SQLBits is the same last time: Thursday: Pre-Conf >> Friday: Paid Conference >> Saturday: Free Community Event. Price are not very high (especially for passonates od SQL Server working in Europa – especcially outside Poland). Pre-Conf subjects (You can register for Your favorite HERE) are interesting:
Automate and Manage SQL Server with Powershell with Allen White
Upgrading your DBA Skills to SQL Server Denali with Christian Bolton
End to End Business Intelligence Using Microsoft Sharepoint with Duncan Sutcliffe
Master your data with MDS
with Jeremy Kashel
Controlling and Optimising Eecution Plan Compilation, Recompilation and Caching with Maciej Pilecki
DAX Deep Dive with Marco Russo
SQL Server Storage Engine and MDF File Internals with Mark S. Rasmussen
Data Vault in a day with Martijn Evers
SSIS Performance Design Patterns with Matt Masson
High Availability and Disaster Recovery for the Novice DBA with Satya SK Jayanty

But for me, the Saturday: Free Community Event is most important. Why? 1st: it’s for community by community; 2nd: I’ve submitted my session to; 3rd: You can choose what You can see (so maybe my session too) from below sessions (sorted by session level):
2 sessions for CAREER TRACK:
200 | Branding Yourself for a Dream Job | Steve Jones
200 | IT Team Management Crash Course | Kevin Kline
40 sessions for DBA TRACK:
100 | Index Fundamentals | Christina E. Leo
100 | LogParser-quicker than SSIS, easier than BCP | Jonathan Allen
200 | Apply Intelligent Laziness to the Management Data Warehouse | Jennifer Stirrup
200 | HA/DR-Focus on Options, Comparisons and Interoperability | Chirag Roy
200 | High Availability of SQL Server in the context of SLA | Tobiasz Janusz Koprowski
200 | Preparation for Disaster | Steve Jones
200 | SQL Storage for the real world | Brett Roux
200 | Ten Horrible Mistakes By the Accidental | Kevin Kline
200 | What do all those DBCC Commands do | Neil Hambly
200 | Working with Server Side Traces | Christina E. Leo
300 | Beware of the BLOB! | Mark Broadbent
300 | Disk IO Tuning for Microsoft SQL Server Newbie | Kevin Kline
300 | Explore the world of Dynamic Management Objects (DMO) | Neil Hambly
300 | Gather SQL Server Performance Data with PowerShell | Allen White
300 | Inside Ola Hallengrens Maintenance Solution | Ola Hallengren
300 | Master Data Services-how easy to implement using SQL Server. | Satya Jayanty
300 | Performance Testing with Visual Studio Load Test | Hue Holleran
300 | POSH Clustering | James Boother
300 | READPAST & Furious: Transactions, Locking and Isolation | Mark Broadbent
300 | Replication-Best Practices, Troubleshooting & Performance | Neil Hambly
300 | RoboDBA | Andre Kamman
300 | SQL Server Denali-Always On Deep Dive | Bob Duffy
300 | SQL Server Query Tuning | Klaus Aschenbrenner
300 | SQL11-DENALI: Whats new for|and Developers | Satya Jayanty
300 | The Accidental Cube Administrator | Bob Duffy
300 | The forgotten|daily essential checklist | Francesco Quaratino
300 | Transaction Log Performance and Troubleshooting-Deep Dive | Chirag Roy
300 | Troubleshooting TempDb| Klaus Aschenbrenner
300 | Turbocharge Database Recoverability Performance | Chirag Roy
300 | We have control!-Controlling Resources in SQL Server | Chris Testa-O’Neill
300 | What PCI Compliance Can Teach Us About SQL Security | Nigel Ainscoe
400 | Advanced SQL Server 2008 Troubleshooting | Klaus Aschenbrenner
400 | Automate Policy-Based Management using PowerShell | Allen White
400 | Demystifying Database Metadata | Mark S. Rasmussen
400 | Hey PowerShell Eventing, can you notify me ? | Laerte Junior
400 | Knowing the Internals, Who Needs SQL Server Anyway? | Mark S. Rasmussen
400 | SQL Server 2008 Database Internals | Klaus Aschenbrenner
400 | SQL Server Index Internals | Klaus Aschenbrenner
400 | SQL Server Upgrade: take help from tools and best practiceS | Satya Jayanty
400 | Why are we Waiting.. Part 2 | Neil Hambly
21 sessions for DEVELOPER TRACK:
200 | CTE by example | Peter Doyle
200 | Database unit testing with visual studio 2010 | Anthony Brown
200 | Introduction to service broker | Anthony Brown
200 | Let Service Broker Help You Scale Your Application | Allen White
200 | Making the SQL developer part of the team | Richard Fennell
200 | SQL Azure-Design Concepts | Geoff Clark
200 | T-SQL : Bad Habits to Kick | Aaron Bertrand
200 | Understanding and Preventing SQL Injection Attacks, Demo Edition | Kevin Kline
200 | Virtualisation on a Developer’s Laptop | Gavin Payne
300 | “Cursors are Evil” | Dave Ballantyne
300 | Around the world (of query plan operators) in 50 minutes | David Morrison
300 | Busted! A journey into the most common TSQL & Tuning myths | David Morrison
300 | Crossing the river of time: Periods in SQL Server | Martijn Evers
300 | How to Detect and Solve Deadlock Problems in SQL Server 2008 | Milos Radivojevic
300 | Performance tuning from the field | Simon Sabin
300 | SQL tuning from the dot.net perspective | Bob Duffy
300 | The Art of War-Fast Track Data Warehouse and Fragmentation | James Rowland-Jones
300 | TSQL Performance Recommendations | Milos Radivojevic
300 | Understanding SQL Server Execution Plans | Klaus Aschenbrenner
400 | Building a SSMS Add-in; The Agony and Ecstasy | Mark Pryce-Maher
400 | SQL Server Do It Yourself practices | Satya Jayanty
10 sessions for DENALI TRACK:
200 | Basic BISM | Chris Webb
200 | Blurring the boundaries with Contained Databases | Martin Cairney
200 | Data Quality Services-Making Data Suitable for Business | Allan Mitchell
200 | High Availability with SQL Server Denali AlwaysOn | Justin Langford
200 | Master Data Services in SQL Server Denali | Jeremy Kashel
200 | Whats New in “Denali”-Database engine and client tools | Aaron Bertrand
200 | Whats new in Denali-Sql Server Developer Tools | Dave Ballantyne
200 | Whats new in Denali-TSQL | Dave Ballantyne
300 | To Err on the safe side: Denali T-SQL Error handling | Martijn Evers
300 | Whats New in SQL Server Denali for SSIS | Matt Masson
35 sessions for BI TRACK:
100 | Design and Implement|Like Edison! | William E. Pearson III
100 | MDX and DAX-compare and contrast | Mark Whitehorn
200 | Attribute Discretization in Analysis Services | William E. Pearson III
200 | Data Vault, the new datawarehouse supermodel | Martijn Evers
200 | Documenting Your Integrated Microsoft|Solution | William E. Pearson III
200 | Getting Dimensional with Data-UDM will still be relevant! | Chris Testa-O’Neill
200 | iPad and Powerpivot-Mobile Business Intelligence in action | Jennifer Stirrup
200 | Making Full Use of SharePoint for Business Intelligence | Duncan Sutcliffe
200 | PowerPivot and QlikView 101 | Alex Whittles
200 | Using Change Data Capture in ETL Routines | Duncan Sutcliffe
200 | Writeback-Here Comes the Sun | Stephan Stoltze
300 | Beyond Plateaux: Optimize SSAS via Best Practices | William E. Pearson III
300 | Creating a Meta Data Driven SSIS Solution with Biml | Marco Schreuder
300 | DAX Programming Patterns | Alberto Ferrari
300 | Fast Track to Spatial Reporting | Jason Thomas
300 | Generate SSIS Packages with Biml | John Welch
300 | Handling Advanced Data Warehouse Scenarios in SSIS | John Welch
300 | Kerberos-All You Need to Know in One Hour | Duncan Sutcliffe
300 | Many-to-Many: Multiple Calendars in a Single Cube | William E. Pearson III
300 | PowerPivot for SharePoint Fundamentals | Bob Duffy
300 | Programming SSIS | Abolfazl Radgoudarzi
300 | SSIS Custom Components | Dave Ballantyne
300 | SSIS Gotchas Tips & Tricks | Sutha Thiru
300 | Tuning Analysis Services Processing Performance | John Welch
300 | Vertipaq vs OLAP: Change Your Data Modeling Approach | Marco Russo
300 | What’s new in DAX 2.0 | Marco Russo
300 | XML in SSIS | Abolfazl Radgoudarzi
400 | Advanced data modelling for data warehouses and cubes | Alex Whittles
400 | Advanced SSRS. Find out what you have been missing. | Emil Glownia
400 | Analysis Services Architecture : The life of a query | Kagan Arca
400 | Designing an SSIS Framework | Andy Leonard
400 | Implementing Real-Time Data Warehouse | Sutha Thiru
400 | Many-to-Many Relationships in DAX | Alberto Ferrari
400 | Reporting Services and SharePoint Integration | Rob Carrol
400 | The many adventures of the utility dimension | Tomislav Piasevoli

It’s a lot, isn’t? Yes, 108 sessions and You can choose 10 sessions HERE. Of course You must be registered user on SQLBits site. I just voted :) So, make Your duty and see You in Liverpool.