…how important the early start for a great carrer is and probably one of the best examples to understand this is to check what DJ Danny Avila does. Take a look at who this guy is, what he does and you will probably understand what I am talking about…
In the second SQL Server hangout, I was joined by Lance England(blog|twitter) with whom we discussed what everyone coming in the Business Intelligence world (of course the one SQL Server) has to know or is good to know to have a flying start! Listen to Lance’s advices as he has some really interesting things to say! Hope you will enjoy the video!
Last week one of our customers called and said that their app was working slow! I took on this as I was curious what was going on and because I felt like this is going to be an interesting one. You know how it is with performance tuning – there is always something that can surprise you! Continue reading
On 12th of June I will be presenting for the PASS Virtual Chapter, so join me and learn more about SQL Sever locking, blocking and isolation levels! We will discuss how the locking manager actually works, what are the various problems caused by the process of locking, how can we actually troubleshoot them and where do isolation levels actually fit in this picture.
Hope to see you all online!
Update: I had so much fun during this presentation! Thank you all for joining me and thanks to the organisers of PASS Virtual Chapter for inviting me! Below you can check the slide deck from my session and the questions that I did not have enough time to answer to.
Q: I want historical blocking info – like happenned a day or 2 ago? [Suresh Raavi]
A: I am not aware of any built-in way for you to do that. You will have to set it up and capture the locking/blocking info somewhere. For example – set the Blocking Processes Report, capture the event and send the output to a table or file. You can capture it with both Profiler and Extended Events. You know which one you have to choose! Another option is to capture the output of sp_whoIsActive again in a table or file. It’s totally up to you.
Q: How to prevent deadlock on cascading delete for 2 different delete statements executed via different proc trying to use same table?[H G]
A: Can you point me to a code that I can take a look at. Until then though, have you tried to run the 2 delete statements serially?
Q: What is disadvantage of “AUTO” table escalation lock? [Mehmet Güzel]
Q: Why is not default table escalation lock “auto”? [Mehmet Güzel]
A: Great question and it’s answer is in Books Online. To sum it up for you – there are chances for deadlocks and that is why TABLE is the default lock escalation level.
Q: For row versioning will all data read result in a physical write to disk for the tempdb or can it do this all in memory? [James King]
A: It all goes to tempdb. From there you read it and it goes then to memory, so think again about what will “happen” to your tempdb database…
Q: Can you please the book isbns or name of the books? [Manjunath Jayanna]
A: Microsoft SQL Server Internals (ISBN-10: 0735626243, ISBN-13: 978-0735626249), SQL Server 2008 Query Performance Distilled (ISBN-10: 1430219025, ISBN-13: 978-1430219026)
Q: What’s your hangout handle? [Jeromy Kimani]
A: You can reach me here -> https://plus.google.com/116047053532709671184/ I am not sure how I have to create a handle for the hangout, but will be happy if you can share it with me and why not do one together on a topic that we choose? Ping me and we will arrange it!
Q: Was this recorded? [John Danley]
A: Yes, it was and it will be available in the PASS Virtual Chapter web site! Stay tuned!
I was on a holiday and I was checking my e-mail at 4 AM in the lobby of the hotel. The receptionist came to me and ask me why I was working at 4 AM? Wasn’t that crazy and wasn’t I supposed to just relax and forget about everything at least during these days while I was there? That made me remember one thing – how much I love my work and how amazing it is that even when I was supposed to get some rest I was doing something that I love! I also thought about the opposite though – isn’t it sad that there are so many people that wait exactly for their holidays just to leave “all that work”? Isn’t it said that these people are actually doing that same thing 5 days a week for almost the whole year?…
That moment made me smile and reminded me one thing – how much I love what I do…
I love the SQL Server community! So is it a surprise for you that I also love our local user group in Bulgaria? Hope not! If you have followed me and my work, you have probably seen that I have also presented quite a few times there and every…single…time I did, it was so much fun! Continue reading
I’ve got an idea! I think our SQL Server community can embrace Google Hangout(as a technology) and use it in a cool way! In this first hangout I invited Mathan(twitter|blog) with whom we discussed how can Google Hangouts be used in help of our favourite community. In the next hangout next Tuesday I will be talking with another Twitter friend – Jess Pomfret! What the topic will be – stay tuned and you will find out!
I am now already doing jogging for more than 8 years and last year I thought it’s time to challenge myself a bit more! This October I will go for the half-marathon race in Sofia! … and as you can see from the photo above – preparation already started!
Wish me good luck!
…regretting. That is a really interesting topic to me and I am really fascinated to talk with older people than me and ask them:
What do you regret for?
Interestingly, the answers do not vary and most of them are:
- Did not spend enough time with my family!
- Did not spend enough time with my closest people!
- Did not do what I love doing!
Think about that…
It’s strange, but I’m loving the fact that my post for T-SQL Tuesday #42 will be so close and related to my previous one for #tsql2sday. So what is technology “X” that had influence on my development in the last years? Hm… let me tell you a story about a technology and a skill that I was relying heavily on(and I still am…) in the last couple of years and that led me to where I am now! Continue reading