Posted on April 18, 2014
SQLHangout 18 with Gianluca Sartori(t|b) on two of the new features inside SQL Server 2014 that you should definitely pay attention to – the new cardinality estimator and delayed durability. Listen to why these can help you improve the performance of your queries, but don’t forget that you have to test them beforehand! Hope you enjoy it no matter the fact that there was a 20 second network drop exactly at the moment we started to talk about delayed durability. Enjoy!
Posted on April 14, 2014
Posted on April 10, 2014
SQLHangout #17 with Rasmus Reinholdt(t|b) on how to use the most popular piece of technology in SQL Server 2014 not for OLTP workloads, but for OLAP ones. Listen carefully to what Rasmus have to say and how he actually used XTP as part of an ETL process in order to speed the load of the data dramatically! Also “get creative” and you may even think of ways how to deal with the limitations of the technology – see what I mean here(it’s related to the MERGE statement)! Enjoy watching! (bonus – you will hear some info even for PDW)
Update: For some reason G+ recorded only Rasmus, but not me. I will follow up on this and double check it for the next recording!
Posted on April 8, 2014
Posted on April 7, 2014
SQLHangouts #16 with Janos Berke (t|b) and Zoltán Horváth (t|b) – the guys that put up quite a show for SQLSaturday Budapest where I actually also delivered a session! In this hangout video you will hear from them some of the things you need to know if you want to organise a SQL Server event. Prepare yourself as some of their advices are quite unusual, but it is exactly what I wanted to hear from them – lessons learned! So with a more than 500 people on their event now behind their back, I am sure you will be interested to hear their opinion and they can be of great help to you if you are also planning to organise or probably volunteer for an upcoming event in your region! Enjoy!
Posted on April 4, 2014
I know I have to put a blog post around this, but it’s so hard for me to express how I feel and actually how happy I am at the moment! 1st of April was a date on which a dream of mine became true – I received the MVP Award of Microsoft! That recognition is something I was pursuing from quite some time and was indeed one of my goals for this year!
Thank you, Microsoft, for making me part of this exclusive community of experts and naming me an MVP! I feel honoured and privileged to be one of the few SQL Server experts awarded with this prize!
Posted on March 16, 2014
Training and education evolve and if there is one organisation that really gets that, I believe that’s Pluralsight. I have been subscribing for their courses for more than a year, but now I am really pleased to share that I will join their company as Author and Instructor! This means that I am now going to be producing content for them and that is really something special and something that I am quite proud of! My first course is coming soon and it will be on the topic of Auditing SQL Server with Policy-Based Management. Expect quite an interesting modules as I will be also touching on topics like PowerShell, AlwaysOn Availability Groups and EPM Framework!
Already looking forward to start the preparation of the course and I hope I will soon be able to share part of the experience on this video below – Pluralsight Author Summit!
Posted on March 11, 2014
“For me only my technical skills matter!” or “I prefer to spend time only developing my technical skills!” or “If I have the needed technical skills, I will be just fine!”! That’s what I am hearing very, very often and don’t get me wrong – I agree with it… partially! What a great chance for me to talk with an imaginative person(IP) and discuss it!
Posted on February 19, 2014
On 26th of February I will be speaking for the PASS DBA Virtual Chapter! I will present on the topic of Distributed Replay in SQL Server 2012 and how it can help you do performance tuning, application compatibility testing and forecasting. So if you are interested in any of those three above or you feel like they are important for you and your job, register for the webinar and I hope to see you online!
Update: Below are the recording and the questions that I did not have time to cover during the webinar. I hope that they will be helpful to you: Read More
Posted on February 13, 2014
I will be speaking in Copenhagen on 29th of March! This one is a huge one for me because I will again have the chance to be among rock star professionals and SQL Server experts! Unfortunately, because of this engagement, I declined to speak on the Global Azure Bootcamp, but I promised to do it next year! My session in Denmark will be on Distributed Replay in SQL Server 2012(and above) and I can’t wait already! See you there, #sqlfamily (watch out for me – I will be wearing a T-Shirt with that hashtag!). Read More
Posted on February 11, 2014
Posted on February 8, 2014
On 6th of March I will be speaking in Vienna! This time SQLSaturday is actually on Thursday, but that only makes it even more special! I will be delivering 2 sessions – one on Distributed Replay and one on SQL Server Concurrency with almost 20 more rock star speakers (just check out the agenda!). Already looking forward to the conference and visiting Vienna again! Let this SQLSaturday be a great SQL Thursday! See you there! Read More
Posted on February 6, 2014
SQLHangout #15 with Richard Campbell(site|twitter) who is also the host of RunAs Radio - one of the most popular podcasts in the IT world(I was on it too recently) joined me to talk about the concept of DevOps. If you haven’t heard about this emerging role or if you are interested in how DevOps will change your current role as a DBA or developer, I think you will definitely like this one! Enjoy watching!
Posted on February 1, 2014
I am following the work of Robin Sharma and his advises for a long time now. Last year I saw his offering about his Masterclass, but it was just too expensive for me(serious 4-digit number). I thought to myself that I just have to be part of his class one day and this year I went for it! Up until now (and the real 12-week training has just started), I can tell you that this training program is worth every penny! Stay tuned for more details around the Masterclass as I will be posting them here in the upcoming weeks…
Posted on January 29, 2014
Just recently I recorded a podcast with Richard Campbell(blog|twitter) for his famous internet radio show – RunAs Radio! We discussed one of my favourite topics – Distributed Replay – a topic that you will not hear or see a lot on the web unfortunately! So if you are interested in the subject and want to hear more about how you can replay your workload and thus be better informed about what’s going to happen with your app’s performance or whether or not it will what so ever – download the show, listen and let me know what you think!
Posted on January 27, 2014
It’s #14 and this time I am joined by a friend of mine from Italy – Alberto Gastaldo(blog|twitter). We met in Italy on the SQLSaturday in Verona and we immediately started talking about delivering trainings on SQL Server and teaching people. That’s why I asked him to join me for a SQLHangout and give some of his advices on what does it mean and what must a trainer consider in case he wants to deliver his training in a proper way! Listen to our discussion and the advices given and I hope that you will find it helpful if you want to enter in the so called “training space”! Enjoy!
Oh, and if you want to learn more about Presentation Skills, you can check the 3 part series of blog posts that I wrote on the topic. Start here.
Posted on January 24, 2014
A lot of IT Recruiters are on LinkedIn nowadays, but most of them do not know how to use the platform properly and that hurts everyone or at least the guys like me that really try to not spend time on things that do not matter. Let me tell you what I mean. I promise I will keep it short!
Posted on January 20, 2014
In #13 I am joined by a friend of mine from Slovenia - Tomaž Kaštrun(blog|twitter). I met him at SQLSaturday Slovenia, but unfortunately I was not able to attend his session and that’s why I invited him to talk with me about Business Intelligence! In this hangout session you will learn more about what exactly do you need in order to build the ultimate BI solution and which component of SQL Server is used when? Many people wonder what is DQS and MDS (or both), what’s that Analytical Cube and why do I have to use a staging database for my BI solution. If you need more clarity on all of these and more – watch and I hope you enjoy it!
Posted on January 16, 2014
In SQL Hangout #12 I was joined by a friend of mine from UK – William Durkin(blog|twitter) who, however, is working as a SQL Server DBA in Germany. He is in the middle of a huge consolidation project(me too) and in this 30-minute hangout we share what we have learned, why you need to use the MAP Toolkit before you even start such type of project, where problems could arise and much more! I believe this was one of the best hangouts till now and I hope you’ll enjoy it!
Posted on January 14, 2014
Hearing the word “automation” is like hearing “cloud computing” – everyone knows at least a bit about it. What’s more interesting is how many people are actually taking steps to “go there” and get their hands dirty and thus become more productive. I myself am a time management fanatic and I really, really like to spend my time on things that matter and cannot be otherwise done by a script, algorithm or machine in general. This blog post will touch on a very simple trick that all of us can use in our day-to-day job and I call it “automate the automation”. Let me tell you more about it… Read More