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.
You can register for the webinar here and check what time it will be in your timezone here!
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.
Questions area:
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!
Slide deck:
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!
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
…impressing a future employer with a diploma(only). My personal view on the topic is quite extreme (although I know that all extremes are harmful), but that is probably coming from my experience as both student and someone who teaches university students. My opinion is that diploma does not mean anything! I mean seriously! I really (if I am the employer) don’t care whether someone is coming from Sofia University or Cambridge. I just don’t! The only thing that I (and the business) care is how this person can win me money. And yes – that’s sound a bit rude, but… get over it, because that is how things work in the real world! Continue reading
I want to finish this post for 20 minutes! Let me see if I can summarise what I was “dealing with” in the first months of 2013:
1. I was still doing some interviews, because the prize I received – Student of the year 2012.
2. I did my first podcast for PeopleTalkingTech with Denny Cherry (Blog|Twitter). Continue reading
I will try to be short! I promise! Here’s my story…
During my first year in the university, I started realising that being really good at what you are studying for is a necessity. Actually, it is a must! However, I started realising that it is quite not enough. It just isn’t if you want to succeed and it isn’t enough, because one should have a broader spectrum of knowledge and skills. One of the areas, I thought back then is important, were presentation skills and so, I started searching for ways to develop them, but boy that turned out to be a challenge! Continue reading
It was a start of the year full of teaching! After the incredible success of our(HP) course on SQL Server at Faculty of Mathematics and Informatics at Sofia University, I trained the second group of SQL Server DBAs, who enrolled in the course in SQL Server Administration at New Bulgarian University! After the success this course had last year, when I trained the first group of SQL Server DBAs, I now went even further and trained the group on a lot more new and fancy stuff! Continue reading
