SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Speaker of the Month, January 2014

A whole new year. Cool.

I was at SQL Saturday DC, #233, at the beginning of December. I sat through several really good presentations. I could honestly give the award this month to any of the ones I took notes on, but I have to pick one person (although, not always, my award, my rules). So, speaker of the month for the brand new year is Konstantin Melamud (li|t). Yet another speaker without a blog. Maybe I should enforce my own rules at some at some point. <sigh> Anyway, I enjoyed Konstantin’s presentation. Let’s talk about it.

Performance Tuning – Index Optimization was an excellent presentation. Konstantin came at the topic very carefully. He started off with a knowledge level baseline, right at the start. I thought that was a pretty good idea. It let people level set from there. He then went through each index, provided a good definition of the index, then discussed information about it, tradeoffs, suggestions. It worked really well as a format for approaching the subject. He did things I wouldn’t necessarily have the guts to do, including doing a pretty good demo of full text search. Throughout the presentation he checked to see if the attendees had any questions. He even had a “I know more than you do” questioner who Konstantin handled professionally. It was a good presentation giving out good information (with an exception that I’ll point out below) that was really well presented. Konstantin’s delivery was very soft, quiet and comfortable. The way Konstantin answered questions and discussed the topic with people he demonstrated a great grasp of the topic. I’m sure people left the presentation and put some of his suggestions straight to work.

The stuff Konstantin could work on is the same stuff that many speakers (including me) need to polish. He didn’t repeat the questions. Even though it was a small room (packed to the gills, standing room only I might add), the acoustics were pretty terrible, so a question from a woman sitting directly in front of me was unintelligible. I’m sure people in the back never heard it. A few of his demos tanked because he didn’t reset after testing them earlier in the day. Understandable, but avoidable. He had one demo using clusters that basically implied the old saw that clusters are best for range data retrieval. I’d suggest changing that demo (and don’t trust me, talk to Gail about it). That’s about it. Like I said, a good presentation.

Once again, no way to determine where Konstantin is speaking next… Help me, help you… Where was I? But, I would absolutely recommend you track him down for a presentation.

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).


Leave a comment on the original post [www.scarydba.com, opens in a new window]

Loading comments...