Posted on April 16, 2015
In the last few years the SQL Server community in Bulgaria grew dramatically. The SQLSaturday event in Sofia is just one proof for this – we already had 3 really successful events behind our back. This year Mihail Mateev, who is the organizer of dozens of events in our country including SQLSat Sofia, is doing one additional event for all database professionals, but this time in Varna – the second biggest IT city in the country. The event will be held on 30th of May and many international(and great!) speakers are coming here in Bulgaria to speak at the event. I am also happy to be one of the selected speakers and even more happy to deliver one of my favourite presentations – the one on SQL Server Concurrency!
So everything you need to have a great time – a beautiful city, the Black Sea, amazing speakers and an event that is free! Coming? Let me know in the comments! (putting just “+1″ is more than enough!)
Posted on April 14, 2015
The year 2015 started in a crazy, but good way. I was engaged to deliver more than 7 courses just in the first half of the year and for those of you who are trainers, you guys know that every single time when you teach a class you always learn something new. Most of the times it’s because your students have some specific case that they want to ask for or it may be because of a weird thought they have and just want to check what’s your opinion of it. This is where the inspiration, let’s call it, for this blog post is also coming from – we have the “teach something new” idea and I was teaching when I learned this and now I again will, in a way, teach it. So here’s the thing… Read More
Posted on April 12, 2015
Global Azure Bootcamp. An event that’s being held all over the world is again in Sofia for second year in a row. I am extremely pleased to share I will be speaking at our local event on 25th of April. I will be talking about how we can secure the data in our SQL Azure databases with the help of some new features – Dynamic Data Masking and Row-Level Security. However, please be absolutely sure that those will not be marketing talks – I will demo what works and what doesn’t(and not just the first one!) and where you can face some serious problems. So, if you want to learn more about the topic of securing your data and see what is the current state of the SQL Azure DB technology, I hope to see you at the event!
By the way, the event is free, so you have no excuses for not stopping by!
… just wanted to mention it…
Posted on April 8, 2015
I haven’t started the post yet and I am already feeling honoured that I am writing this. On 1st of September I will have to fly to Stockholm to speak for one of the best SQL Server User Groups in the world – the one in Sweden(if you doubt that – just check their YouTube channel). I am extremely happy that I will finally be able to be part of and see the community there as I have worked for companies that operate from Sweden and because I have heard so much about those guys! What I am going to deliver during the meeting is a session that will stress and go quite deep in one of the most complex subjects in SQL Server – concurrency and more concretely isolation levels – one of my favourite topics!
Posted on April 2, 2015
So it’s a day after 1st of April and that’s the date when I get to know whether or not I will be an MVP for the upcoming year. Last year Microsoft awarded me for first time with this prestigious award and now I am really, really happy to share that once again I was chosen to be SQL Server MVP!
It was a rough year. It really was. And I am speaking from community perspective only. However, I really enjoyed it! Travelling and speaking at more than 10 countries at events large and small, delivering webcasts, continuing the SQLHangouts, helping online almost every single day – everything pays off at this single moment when one sees the e-mail from Microsoft stating that he/she is awarded again and that’s true because of the value that this program has to both the MVPs and Microsoft itself. It’s just priceless to be able to speak with the Product Group and brainstorm with them on upcoming features and products. It’s also amazing to be able to share/ask/help to fellow MVPs, but of course that’s not all…
So congratulations to everyone who got this e-mail today and for all of you who want to become an MVP – get involved. Go out there. Go the extra mile and help the community. It’s worth it.
Posted on March 17, 2015
So let’s say you have a project to move one of your databases to Azure and “convert” it to a SQL Azure Database. Our company did this just recently and I was the one involved for the database part. Now, that’s all cool and I was really happy to give SQL Azure Database a try, but once we successfully reconnected the application and it was living it’s new “cloudy” life, I decided to check something. Let me tell you what was that and why it surprised me.
I was recently at the SQLBits Conference in London and way back, when I was selected to speak about SQL Server concurrency, I decided I want to do something that’s completely focused on isolation levels. So knowing that I will be doing that at an event of SQLBits size, I figured why not test SQL Azure Database too and see whether or not there is something interesting there. Guess what! There is… Read More
Posted on March 14, 2015
I am extremely happy to share that I was selected to speak at the Tarabica IT Conference in Belgrade, Serbia, which will be held on 28th of March! This is one of the best (if not the best) community events in Serbia and what makes it special is the fact that presentations that are level 100 or 200 are not even considered by the team that organizer’s team. That’s a good way to say to the audience that they can expect only hardcore IT training and no marketing messages during the day and I really love that!
Already looking forward to 28th of March, seeing and meeting a ton of new people! I think it will be a great day there in Belgrade where I will spent 4 days actually as I will also be speaking on 30th of March too, but this time at the Microsoft’s MVP gathering event.
Hope to see you all at Tarabica!
Update: If I have to be honest, I did not expected to see more than 300 people at Tarabica IT 2015. However, I am sitting here, listening to Sergey Olontsev(t|b) speaking about corruption and I can see around 70 – 80 people just in this room. Surprising or not the attendees of the conference are more than 600(yes, seriously!), so it’s easy for me to say that this event is one of the biggest in the country and I feel even more privileged to be part of it(not to mention how much are the organisers taking care of us as speakers!). Sharing my slides and code as many people asked about those already!
Posted on March 10, 2015
I am just coming back from SQLBits where I delivered a 75 minute session on isolation levels and one of the things that I thought about during my preparation which I figured may be interesting for the audience is a perfect fit for number 64 of our favourite T-SQL Tuesdays. This “thing” involves table partitioning and the serializable isolation level. Let’s me show you what I mean…
Serializable isolation level makes sure that no concurrency phenomenons like dirty reads, non-repeatable reads and even phantom records are possible. The latter are the ones that we want to stop at for a sec and the reason for that is because I want to spend a moment talking about how serializable makes it possible that phantom records will not happen. In serializable isolation level SQL Server takes the so called Key-Range locks in order to not only lock the already read records(as it’s doing in Repeatable Read), but to actually lock the whole range of values preventing the chances of a concurrent transaction to actually insert a record that may be returned once you run that same SELECT query as part of your transaction. OK. Sounds reasonable. Is that… true though? Or if it is, can there be something that can worry us here? Let’s take a look an example. Read More
Posted on March 2, 2015
Microsoft Certified Trainer. Forth year in a row. And the first time I am blogging about it. Why?
In the last few years my personal opinion on the value of the MCT certificate was, let’s say, mixed. It was strange for me how one can become MCT(yes, anyone could have became MCT if he pays a fee!?). It was also strange to me that the training materials that Microsoft was providing to the MCTs (at least to the SQL Server trainers) were with really poor quality, sometimes even full of errors! What’s more, I seriously doubted the overall value of the certification – there was almost nothing that you, as an MCT, get from that program which is somehow… not fair. Now, for first time since 3 – 4 years, I feel like this certification is something one should again be proud of. It’s again something that is worth mentioning when you say what you do and who you are (and that’s not because the fee was raised dramatically). Microsoft has strengthened the requirements for one to become MCT and they actually started requiring things like training experience(kinda important, right?) + feedback from the students to be higher than X. In return they provide MSDN and Office 365 subscription(+ some other cool things), but again – that’s a step in the right direction and I am really happy to finally see it because training, teaching and education in general are really, really important things and I want to see only capable people involved there.
As of me, I have already delivered my first course for 2015 (LINK) and I have 6 more (yes, 6) already arranged and booked till the end of May! So, I am busy, but with a smile on my face and already looking forward to meeting so many new people.
MCTs, wishing you a successful year and a I hope you will be having an amazing time with your students!
Posted on February 28, 2015
Last Saturday the 4rd group of DBA students (and 5th group just from New Bulgarian University) completed their 40-hour DBA training. I have to say(once again) that I am extremely proud of the group! Their motivation for learning(during some of the days we were working for more than 7 hours – they were just not going home…) was almost second to none. Those guys are all actually database professionals – some of them are system engineers who also work with SQL Server, some of them are reporting specialists and some of them are doing both Oracle and SQL Server on a day-to-day basis. It’s always a fun experience for me as trainer to have such a wide variety of skills because it’s not only them that learn a lot. I do too! So huge congratulations to them for taking the course. I feel privileged that I was their trainer and what’s more I am happy that I made them join our SQL community in Bulgaria. That’s 5 more seriously knowledgable people who are going to participate in the user group meetings, come to events and probably decide to speak at some one day! So much great things, huh?
Posted on February 26, 2015
First of all, I have to say that being a Microsoft MVP is a huge honour! Since I got this award last year, many things changed for me for the better and so that’s one more reason why I am really looking forward to 1st of April when Microsoft will announce whether or not I will continue to be part of that elite group of people for one more year(so everyone wish me luck!). In the mean time, however, the MVPs from our region(CEE – Central and Eastern Europe) will gather in wonderful Belgrade on 29th and 30rd of March for a 2 day conference and I am really pleased to say that I will be one of the speakers of the event! What I am going to talk about is one of my favourite topics – Presentation Skills and the title of my session is “Deliver Better Presentations. The Next Level!”. In the 50 minute slot that the conference organisers are giving every speaker, I will simply share my algorithm of how to create and deliver presentations/talks/sessions (whatever you wanna call it) in a way that the audience just does not have any other option, but to rate your session as the best one. I am really looking forward to this event already! The bar is raised high, but I have some serious experience in delivering amazing talks, so I would love to share some of the things I know with the other MVP folks!
See you there and I am sure we will all have great time!
Update: A few hours after the end of the event and just a few more before I get the news on whether I will be MVP for one more year or not, I am attaching my slides from the talk that I delivered at the event. It was a really nice experience to see so many new people and talk about(even under NDA) for the things we care about – SQL Server and even more interestingly about soft skills and their importance(that was not under NDA though :D). Ending it here with one last huge “THANK YOU” to Yulia Belyanina for everything she did for so many MVPs during her stay in Microsoft! Thanks, Yulia!
Posted on February 24, 2015
SoftUni Conf. A conference held in Bulgaria. A conference that’s not organized by Microsoft. A conference that is not organized by any other huge company or corporation. However, a conference that gathers really important group of people together – the people who are going to rule the IT industry in the upcoming years – the students of Software University. I am extremely honored to be able to join that conference as a speaker and I am already looking forward to meet, chat and have fun with those guys this time not for 4 hours though, but for a whole weekend!
Update: When SoftUni was founded, I knew that it was going to be the best place in Bulgaria for young people to become software engineers. Now, however, after being part of their annual conference – SoftUni Conf and actually speaking at the event, I am 100% sure that this is indeed the case! Those students and the people who actually teach, mentor and guide them in their future careers(and many of those students actually already started their careers now!) are simply one of the best in the industry! I am extremely honoured that I was part of this weekend and I am already looking forward to meeting all of them again soon(together with the founder of the university, we have some interesting plans). Here are some of the photos that we(with my girlfriend) took during our stay in Pamporovo and here are the scripts and my slide deck that I used for my presentation.
Posted on February 22, 2015
Just one day. That’s how much time the students of Software University had between the two lectures I delivered for them. During the second one, we talked about transactions. We again had 4 hours in front of us, so we started with the basics, but ended in the world of isolation levels and update conflicts. We also touched on what problems come when using locks and of course they know now what ACID means(because I told them they are going to be asked on their interviews about this!). As last time – here is the video, screen capture and slide deck. Almost everything is again in Bulgarian though.
Posted on February 21, 2015
I recently blogged about me delivering 2 lectures as part of the course on databases at Software University in Sofia. Both of them are now in the past and what can I say – it was great! In my first “visit”, I spent 4 hours with the students and we discussed a lot of things that they need to know in order to make their applications work fast. We started from the hardware(even though they are preparing to become developers) and moved towards instance configurations, database design techniques and finally – queries and execution plans. There were tons of questions and I really believe we all had great time. The materials – video, screen capture and slides are below. However, most of those are in Bulgarian
Posted on February 18, 2015
I am trilled to share that on 18th of April “I will be back” to one of the biggest SQLSaturday events in Europe – the one in Budapest! Last year the event was crazy successful – more than 500+ people showed up and think about it – when you have so many people + great speakers, sponsors and organizers – the show is guaranteed! Frankly, I expect nothing, but the same if not even more from this years’ event, so I am already looking forward to it!
Hope to see you all there!
Update: Sitting at the Vienna’s airport and thinking about the event. Trying to figure out whether or not the fact that there were less people who attended the event compared to last year was a problem. May be. I really don’t know as I had great time. My audience and the people who I met during the conference were all great and we had some really interesting discussions about SQL Server and much more. At the end of the day – I am happy! I am happy I was part of this SQLSaturday once again! And of course for everyone who attended my talk – here are the so awaited scripts that you wanted to have.
+ Delayed Durability is present in all editions of SQL Server. Not only Standard and above. That’s one of the things I said, but was obviously wrong. So for those of you(because I had some conversations after my session on this) that were using SQL Server 2014 Express and want to try Delayed Durability – yeap, it’s possible!
Posted on February 17, 2015
On 11th of March at 17:00 CET I will be delivering a webinar for the PASS Professional Development Chapter. I will be speaking about the topic of design and more importantly what every speaker (or someone who wants to be such) needs to know when he/she is preparing his slides. My personal opinion is that this part of the preparation of a presentation is many times underestimated and I cannot understand why!? I agree that content is important, but how you will deliver it is also something that plays a huge role in the “overall game”. Register here for the webinar, book your calendar and see you in March!
Update: First and foremost – thanks to everyone who attended! It was really great that we were finally able to do that webinar and I am always happy to speak about presentation skills and presentation design in particular. My slide deck and a video from the webinar are below, but I also promised to share some other links, so let’s me keep my promises. Here you can find Cathrine Wilhelmsen’s slideshare profile. I am sharing it, again, just because I want everyone to see that combining different fonts on the same slide can actually a good thing and on this link, you will find some free web sites that you can use for HD photos.
Hope these materials are of use to you and looking forward to hearing from you on what happened when you applied any of those 10 principles we talked about! Good luck and have fun!
Posted on February 12, 2015
What a great number and what a great hangout once again! Alessandro Alpi(t|b), a friend of mine from Italy, joined me to talk about testing database code with tSQLt. As you will learn from him tSQLt has a lot of advantages over other tools like Visual Studio for example, especially when we talk about testing code. Alessandro, who is MVP for 8 year now, also shared his experience with a tool that’s called with the interesting name SQLCop and I believe that after watching this video, you will not only be assured that testing your code is important, but you will also know where to start from! So enjoy watching and have fun!
Posted on February 10, 2015
SQLHangout 32 comes to you and it’s with a special guest – Argenis Fernandez(t|b) or as you may already know him – @DBArgenis! We have been planning this hangout for at least 2 months, so I am really happy it finally became true. What we talked about is simply storage. A topic that is crucial if you are looking forward to having a SQL Server that is performing well. Learn from the SQL Server Certified Master about what’s coming up in the storage world(and what storage he is using), why you need to know more about system administration and Windows Server in particular and what are the specifics of SQL Server when we talk about storage configurations and requirements. By the way, do you know what shortstroking is? You guessed it right – that’s one more thing you will learn about. Enjoy!
Posted on February 10, 2015
Security – a topic that is even more dear to us in the last few months after witnessing so many major flaws with huge, huge organizations. There are quite some things that worried and continue to worry me when we talk about securing data in SQL Server, but one of them really stands out in my mind. Let me tell you which one. Read More
Posted on January 30, 2015
Some months ago I delivered a 3-hour seminar for the students at SoftUni. Back then we talked about their first steps with SQL Server and we covered the basics – how to set up an instance, configure the security, create the databases they need and connect their application to that. Now, however, it’s time for the students to pass a whole course on databases and I am happy to “announce” that I will join the trainers team that is lead by the founder of the university – Svetlin Nakov(t|b). I will cover just two of the topics during the course – the one on performance tuning and the one on concurrency – really important topics as some of you know. The course will start on the 2nd of February and I am already looking forward to seeing the students! Stay tuned as more interesting information is coming up really soon…
Update: Here is a short interview with me from the opening day of the course. It’s in Bulgarian though!