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 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 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
Posted on January 9, 2014
In this session I was joined by a friend of mine from Turkey - Ümit Sunar(blog|twitter), who works as a Windows Azure Technical Evangelist for Microsoft! We discussed what’s Windows Azure and what’s that thing SQL Azure Database. He also shared how his customers are already using Microsoft’s cloud platform and he was also very kind to tell us whether or not Microsoft are serious about this platform. Hope you will enjoy it even though there were 2 or 3 short connection problems.
The resources that Ümit was talking about can be found here (definitely recommending you to take a look at it if you are interested in the subject!)
Posted on January 6, 2014
It’s not and I don’t want it to be a secret to anyone that I still haven’t graduated from my university. What’s more – I don’t even feel uncomfortable about this! I actually feel proud and happy in some way that I haven’t and that I spend my time doing real and relevant stuff. However, let me tell you why though, I will dedicate a week of my time(yes, I don’t need more), but I will write my bachelor thesis and finish my university education once and for all…
Posted on January 3, 2014
Recently a colleague of mine from the application team asked me the following question:
Can we grant someone who is not a sysadmin such rights that he will be able to modify SQL Agent jobs that he does not own?
As probably many of you that work with SQL Server on a daily basis know this is not that straight forward to achieve, right? Even if you grant that user the SQLAgentOperatorRole it will not work, because we’re talking about jobs that this user does not own not the ones that he has created himself. That captured our attention and actually as you probably have already guessed – we figured it out! Let’s talk code now… Read More