[EN] TechNet UK IT Pro New Year’s Honours List

Twenty Five Heroes. I’m very happy to know few of them, and I’m very sad to hadn’t chance to meet others. I hope in this year I wil meet some of those Heroes honoured by TechNet UK New Year’s list. I’m glad to know Jen Stirrup, James Rowland-Jones, Chris Rhodes andChriss Webb, I heard about Ed Jones, Linda Smith, Peter Bryant.

I really like this idea which came from Microsoft techNet UK. It’s really sad that I cannot find any of this honourable list prepared by Microsoft in Poland. We have a lot of great people and it would be great to honoured all of them.

Here is the original post: http://bit.ly/1BrfrUU This year’s IT Pro New Year’s Honours List:

  1. Jamie Bryant@MrCloudOS
  2. Mike Halsey (MVP)@PCSupportTV
  3. Roland-Jones (MVP) | @jrowlandjones

In summary: twenty new twitter accounts to follow!

[EN] Sunday Market–SSMS Spotlight Plugin by Dell (part one)

It Sunday again. And some shops are closed. If Yes, it’s time to get next useful tool for free. It’s my episode #07 in non-frequently series: Sunday Market. This time we will look for Dell. Inspired by online session of my good friend from England: Richard Douglas {TWITTER|BLOG|LINKEDIN} I want look for Spotlight Essentials Plugin by Dell. Richard delivered session: Wait Watchers – No pain, all gain exercises to increase database performance at PASS Database Administration Virtual Chapter and it was very interesting. Interesting enough to look for this plugin. It is free, so we can get in on Sunday, just like today. This post will be divided in two parts: one for basic installation – till the moment “"’I got it!’ and second with more configuration options. So let’s install this plugin.

Phase One. Getting the plugin.

You should go to Spotlight Plugin site: https://www.spotlightessentials.com/sql-server/instances 


Pict. 01 | Intoructionary picture of plugin


Pict. 02 | Registration form for account using Spotlight in future


Pict. 03 | Downloading plugin (ca 70 MB)


Pict. 04 | Registration for Spotlight Essential Web Account (if you registered before new geristration is not necessary)


Phase Two. Installation of plugin.


Pict. 05 | Welcome screen (same type like Visual Studio 2013 isn’t?)


Pict. 06 | Transaction Product Agreement – in normal words license.


Pict. 07 | Installation of Diagnostic Server with specify Diagnostic Server Service Account


Pict. 08 | Using special dedicated account SQL Spotlight will bring errors with permissions, but it work and is best way in my opinion.


Pict. 09 | Configuration os specific Payback Database which will store recent and current data (we can choose special instance or the same instance as production server)


Pict. 10 | If desired instance are not connected or not running, we will get error.


Pict. 11 | In the case of clicking NEXT at previous screen we will get error that Specific Database not exist


Pict. 12 | When we click CREATE on screen (at picture nine) we can creat Specific Database


Pict. 13 | Specific Database created succesfully


Pict. 14 | Installaton started…


Pict. 15 | …and finished. Aproximately time is less than five minutes.


Phase Three. First view in SQL Server Management Studio.


Pict. 16 | Specified Database appears in databases tree: SpotlightPluginPlayBackDatabase


Pict. 17 | We can docking Spotlight Plugin in a tab. But we can’t connect to Diagnostic Server if our Spotlight plug-in Diagnostic Server Service didn’t run.


Pict. 18 | We can check Services and even we see that service is running, we can STOP and START again it.


Pict. 19 | First view for our plugin in General Tab


Pict. 20 | Next step is connecting instance to Spotlight Essential Plug-In Web Account (I will write more about in in next post)


Pict. 21 | Time for connect first instance. In my case is the instance with Specified Database


Pict. 22 | And here we see status of connections: to Diagnostic Server and to Instance


Pict. 23 | First detailed tab: Overview Tab with Waits, Top Databases Files IO, Batch Request, Summary, Connections, CPU Usage and more.


Pict. 24 | Second detailed tab: Sessions with sessions status, activity last command and over thirty other details about sessions


Pict. 25 | Third detailed tab: Resources Waits with Wait Time Trend ans Waits Details


Pict. 26 | Fourth detailed tab: Data File I/OS with general data file infor for each data file and system databases


Pict. 27 | Fifth  detailed tab: TOP SQL  with detailed information about last TOP 25 SQL Queries


Pict. 28 | After few minutes of work we can see more events on our General Tab where alarms are sorted by Severity


Pict. 29 | And more and more alerst after next few minutes.

Screenshot 2015-01-04 18.17.01

Pict. 30 | We can add more instances for Diagnostic Server


Pict. 31 | But we can’t connect with SQL Azure Instance if we just click without changing authentication type


Pict. 32 | When we use SQL Authentication, connection is succesful


Pict. 33 | And we can see all instances in General Tab


Pict. 34 | In General Tab we see status of our instances in colors which based on health status

Screenshot 2015-01-04 18.47.05

Pict. 35 | When we move mouse in General Tab over one of many instances we will see pop-up windows with short information of errors

Screenshot 2015-01-04 18.48.51

Pict. 36 | And those errors will be different, they change in time

Screenshot 2015-01-04 19.01.23

Pict. 37 | Same pop-up windows we will see in Overview tab on each instance


That’s All Folks. Get the plugin, istall the plugin and configure the plugin. From this point You can test this plugin and start to play with this nice tool. More details about configuration, errors, connections and how useful this plugin could be in next post.

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

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).

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.

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.

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!

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.

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 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. 

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.

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!

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!