Another Awesome Tools in my Toolbox


My Toolbox

No, this is not your everyday tools and your normal toolbox.   These awesome tools came from a week long training with SQL Skills on their Performance Tuning week.   I learned new shiny techniques to troubleshoot performance issues, different ways to look at problems and new approaches on how to prevent problems before they even become one.    These tools are extremely important to have in my toolbox and an awesome addition to the ones I have.   Soon, I might need a bigger toolbox!

I’m not going to go over each day on what we covered in this post.   Erin Stellato (b | t) and Klaus Aschenbrenner (b | t) did a wonderful job to recap day-to-day summaries on their blogs, however, I want to summarize my experience and hopefully encourage others to attend this event whenever you can (and no, I’m not getting any cut for writing this) and to give my perspective to other managers out there if you are not sure which training you need to send your direct reports and what kind of ROI you can expect from an investment like this.

The Instructors

Let me start by talking about the instructors.   Paul Randal (b | t), Kimberly Tripp (b | t) and Jonathan Kehayias (b | t) are very knowledgeable and each have a different areas of expertise.   When you attend SQL Skills training (I have attended two of them so far. You can read my experience from last year here), you are not just getting the valuable material, but you are getting that from three different experts.   They often talked about the same subject, but from different perspectives and used different analogies which I think it’s very unique and extremely valuable for the attendee.  It is like hearing a story from three different people, each tells it slightly different based on their perspective, audience, and experience.  Combined, you learn more than if you had only received the story from a single source.  They are all very interactive and passionate about the subjects that they were talking about and it somewhat contagious!

The Material

We were learning a lot of in-depth topics and each of the modules has clear objectives on what the student is going to get.   Unlike an hour or two presentations at some technical conferences, you are getting 8 hours of training material every day for 5 days.  You are learning about the ins and outs of certain subjects and you get various demo scripts that written by the instructor team, and can be use to against your environment (another set of awesome tools for your toolbox.)   You will get a clear understanding about how the internals of SQL Server works and how to utilize all the bells and whistles that come with it, and I’m not talking about some pretty wizard.   I’m talking about some undocumented function and command that you can use to see or identify certain things.   How awesome is that!  It is like having a personal SQL concierge take you one a personal back stage tour of what is under the hood in your database server.

The Attendees

Here’s what most of the manager didn’t see.   In the last two rounds of the training from SQL Skills that I experienced, we had 30 plus attendees from all over the world that have all kinds of background.   During the training, you developed a relationship with the other attendees, some more than others and exchange stories about the challenges, environments and even solutions.   Certain challenges that you are experiencing today, might be yesterday’s problem for others and they have found the solutions and sharing the stories during break or lunch (or happy hour) might give you the solutions you need for your challenges today.   In summary, being in the same room with over 30 intellectual people who want to learn about the same thing and work in the same area, is another valuable aspect of this training.

The Perks

Yes, there’s perks.  Last week, we had Robert Davis (b | t) and Connor Cunningham (b) stopped by and gave a little talk.   Robert Davis is a Program Manager for SQL MCM program and Connor Cunningham is the Architect for the Query Processor team at SQL Server Division.   We get to learn more about MCM Program and ask questions about that program and we get to hear some inside story from one of the people who wrote the code behind SQL Server Query Processor.   These two gentlemen are wicked smart and to be in the same room with them and hear their story always an a great experience on its own.

So, for the managers out there – here’s my message to you.   If you are sending your people to SQL Skills training, I can almost guarantee that your staff will have a great tools that they can use right away when they come back.   It’s not some tool that you have to sharpen or make it shiny first, but the knowledge they gain can be immediately used. You should expect your attendees to return able to either identify the pain-point of your challenges or preventing future challenges.  They will have a great understanding on how the internals of SQL Server work and variety of techniques and resources available to gather the information and creating baselines for performance improvement of your system or recognizing potential problems.    Not only that, your staff will have direct access to the instructors to ask questions for your specific problem during class and even have them look at it for you!   I think that alone is already worth the investment!

As for me, I have pages of notes that I need to go through, and when I get the demo scripts next week, I already have plans on things I want to look at based on those scripts that I know will help me identify our current challenges.   On top of that, I have a whole lab of virtual machines that they distributed during the class for further learning.   I’m excited.   I am always hungry for a new knowledge and I love to learn and I think I will always learning something new even on a subject that I think I already know.


49 Responses to “Another Awesome Tools in my Toolbox”

  1. y4up says:

    Can you share some of the training contents?

  2. Ed says:

    Well said! I completely agree with your assessment.

  3. Lois says:

    I was really confused, and this answered all my qutseions.

  4. I’m not the least bit ashamed of my nation, as Tarrou is. I’m ashamed of its representatives. My nation is made up of a lot of good, decent people who respect others.I suspect that’s what Tarrou meant, though.Bless you Ken for writing this piece and putting these people in their place, even if only in your reader’s minds.

  5. I am a proud alumnus of NC A&T State University and has attended consecutively 20+ A&T Homecomings. I can say without a shadow of a doubt that it is GHOE. It gets bigger and better every year. It is so wonderful to see so many come together to fellowship and just have fun. I am so looking forward to next year.


  7. Oijoi mitä löytöjä oletkaan tehnyt! 🙂 hieno ompputuunaus. Mulle käy yleensä vaan aina niin, että kun oon sillä mielellä lähdössä kirpparille, että nyt kyllä löydän jotain tuunattavaa, nii ikinä en löydä mitään. Tuo rumpalisotilas on muuten kadehdittavan ihana! <3

  8. Na 34k for marketing for the WFF seems legit; you gotta think that they have to make a webpage for it and pay the designers and the programmers to put all together.  Then you have to factor in other marketing materials like a brochures and paying someone to market it all and get the word out.  Finally look at the video’s Mike puts together; they are pretty high quality production values and that doesn’t come cheap.You have to be kidding me, right? No way! 

  9. Hi, Neat bring out. There’s a problem with your locate in internet explorer, would ensure this… Explicitly at rest is the advertise site chief down with a corpulent percentage of people can skip the admirable script for this reason problem.

  10. She was spending her last body energy to complete items on her bucket list and enjoy her family and friends. As she wished, she was doing the things she wanted to so! Thank you all for sharing these memories of her last days and hours.

  11. War öfters in Kroatien, ich flog auch nach Split und von dort aus mit dem Tragflügelboot zu verschiedene Zielen. Dubrovnik ,Hvar,Brac. Machte irre viel Spaß, und kostete auch nicht die Welt.

  12. Nope, Deryle and bb, not due to the dangerous liaisons, IMHO (though I do give Petraeus credit for being more salacious than I might've imagined.)No, this pertains to the Libyan coverup, IMHO. Ms. Clinton and Petraeus shall fall on their sword (a very phallic act for La Clinton, nicely in line with the actions of another staunch lady — Janet Reno — after another murderous failure.)

  13. You really ensure it is seem so easy with your presentation but I locate this matter being actually a thing that I think I’d never understand. It seems too complicated and intensely broad personally. I am looking forward for your following post, I will attempt to get the hang of it!

  14. Le jour où les transports en commun seront tous humanisés comme çà, du sauce et la quille de rouge! peut-être que je laisserai ma voiture au parking… Bon noël!

  15. Je mi z toho zle, ale zlo môže mať rôznu podobu a teda aj má. Vždy takú aby vyskúšalo našu bdelosť vo všetkých ohľadoch. Podkožne, manipulatívne, cez bunky a každodenne. Verím, že aj na nich niečo platí, ved im nemôže byť daná sila a všemohúcnosť len tak. Treba im odobrať zdroj ich sily, jediné o čo sa môžme oprieť je naša neoblomná viera, sloboda, láska a pravda. charlotte.

  16. Multumesc, Alex. Lui ii place tare mult cand are ocazia sa faca baie. In rau sau in lac, pentru ca atunci cand vine vorba de spalat nu e la fel de incantat.

  17. Hi Folks,We are now confirmed for 10.30am at Condover. Remember, boots, shinguards, and a drink bottle. Don’t worry if you don’t have the right colour sox and shorts, its a friendly trial game against the “Funnel Webs”.Stew

  18. she was stuck on 3 or 4pages that she just keeps going back and reading them over and over. She said ,”Iwill never get through this book. It makes me stop and think.” I will visit her onWednesday. I am anxious to find out which pages she is stuck on.

  19. Hi, I am searching for a nice web host. Maybe you could advise a good host? I’d register with an aff link you give me. My current web host is rather untrustworthy right now. ):

  20. Det är lite sÃ¥ vi funkar tror jag. Önskar vi oss nÃ¥got, sätter egna ord pÃ¥ det, sÃ¥ ser vi ocksÃ¥ till att det händer. FÃ¥ saker sker av slumpen. Jag gillar uttrycket ”Det blir alltid som man tänkt sig”

  21. dit :Tu as de la chance de pouvoir acheter tes jeans sur internet. Moi vu ma mini-taille c’est compliqué =S. D’ailleurs en france, je n’ai trouvé que Zara qui m’aille comme un gant .

  22. Ja, det bärjar se bättre ut, hoppas det försvinner helt. Smörjer det med Elizabeth Arden 8 Hour Creme. Funkar på allt annat, så jag hoppas det hjälper nu med =)

  23. Uffff .. Dafne, llevo buscando horas una piedra y no encuentro ninguna… jejeje¿¿ Tener pensamientos “impuros” con otro mientras ñaca ñaca con tu pareja es una infidelidad ?? Yo mas bien lo llamaria fantasia o juego.

  24. Yesterday, while I was at work, my cousin stole my iPad and tested to see if it can survive a 30 foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is completely off topic but I had to share it with someone!

  25. 23/01/2013Bruno CignaniAuguri di una seconda vittoria al Presidente Rafael Correa.Viva Fidel CastroViva MoralesViva Chavez e per lui tanti auguri di una rapida guarigione e ritorno in Venezuela  

  26. It is perfect time to make some plans for the future and it’s time to be happy. I’ve read this post and if I could I want to suggest you some interesting things or suggestions. Maybe you could write next articles referring to this article. I wish to read even more things about it!

  27. Da komme ich ja schon vom Lesen ins Schwitzen! Aber Fluffy ist ganz begeistert. Das Tier steckt voller Ãœberraschungen … mehr wird noch nicht verraten. Sei aber darauf vorbereitet, dass Dehkah auch mitkommt zum Training. Die beiden hängen irgendwie ständig zusammen

  28. I'm quite excited about real-time analytics. Thanks for building it!When I make a change to a site, such as the site navigation, I'm often refreshing analytics every five minutes to see the effect.Having real-time stats will be great to quickly evaluate a change, and adjust if it's not working.

  29. Your right and Marina’s never been afraid to admit some of her ideas aren’t fully formed, she’s still working out her world view and in often does it via her music. Yeah heard all the early versions, and although Girls is an old song it is too catchy to leave off the album. Would love to hear a full studio version of ‘This Is L.A.” though

  30. Hold op et fint sted. Farver og lys og blomster. Og den der tallerken ser da virkelig god ud. Dejlig mor du har, der sådan giver frokost :-)Godt koncept de har der på caféen. Jeg elsker når man sådan kan gå rundt og shoppe lidt før og efter man spiser. God søndag Kate

  31. greetings to all.I would first like to thank the writers of this blog by sharing information, a few years ago I read a book called in this book deal with questions like this one.

  32. fasme Posted on Estimados:Integre el KCC 6 en un servidor local con xampp en windows todo funcionando OK, luego me baje la version para linux 32 bit para utilizarlo en un hosting pero no puedo integrarlo, me sale el error 283, el log me arroja esto:6107715646; 526; ;pago ; ;21122012 ;133530; ;ERR;597026007976 ;No se pudo decifrar el contenido, posible error de llaves6107715646; 526; ;pago ; ;21122012 ;133530; ;ERR;597026007976 ;283 Alguna idea?Tengo que hacer algo en el cpanel en el menu de administrador de SSL para el manejo de llaves?los cgi los subi en modo binarioy el resto en ascii

  33. Both cards are so special!!!Thanks for the tip about the scrabble tiles on pinterest.That little halloween card is so cute but that Xmas ornament steals the show…The image is a such a sweetie and the card is superb!

  34. Oh Yeah! That’s a keeper! Perfect consistency and it just kept giving. The squeezer had beautiful nails and she wasn’t afraid to mash that critter without mercy. Definitely 5/5 and into the faves. Thanks Cochore! This made my day!!

  35. Titan 提到…6/4Device : iPhone 4Finished Upgrade : From 5.0.1 to 5.1.1JB absinthe 2.0.4 : DoneAns: 恭喜順利 JB 越獄 成功,也感謝您回來分享喔!^_^感謝Andy,對我們Apple用戶的貢獻…Ans: 簡單的分享,可以讓大家的 Apple 裝置能夠使用的更方便、更順手,何樂不為呢?只是最近比較忙,發文越來越少…

  36. Federer a gagné et passe au prochain tour. Dans 2 mois, je ne me souviendrais plus de ce belge qui a un peu perturbé ce joueur. C’est un éternel débat, faut t’il gagner avec la manière et l’efficacité ou plutot en jouant moyen ? Pour ma part, je ne regarde que le palmares, qu’importe le jeu du joueur.

  37. Mijn eerste gedachte was: waar werk jij dat er zo'n streng kledingprotocol is. Of zit je op een representatieve functie, dan kan ik me er wel iets bij voorstellen. Maar je hebt zo een leuk setje. En die tas past precies bij jou.Geniet nog een fijne zomeravond!Lieve groet,Gerry

  38. Dr. estou sempre aqui no seu blog e leio todos os post… Não acredito em uma recuperação do Santos, nem mesmo quando o Neymar voltar, tô doida para gritar: ão ão ão Segunda Divisão! Torço muito para que isso aconteça, te admiro muito. Beijos

  39. maria:what chronically fatigues me is watching you play the innocent hereinand watching your schizo waffling from lying clone of eurasian to doormat clone of nicole etc…i am more tired of that than you could ever know in your schizoid delusions!!!

  40. Touché, Sue. Of course it is unfounded, I was speculating. Sue, it’s not that I don’t believe people when they say it’s bad writing. Why would they lie? It is because I believe it is possible, that people like to make it known that they are above the hoi-polloi who are gullible enough to fall for the charms of a popular novel.

  41. Good site! I truly love how it is easy on my eyes and the data are well written. I am wondering how I might be notified whenever a new post has been made. I’ve subscribed to your feed which must do the trick! Have a great day!

  42. Thanks for coming by and giving your lovely comment Dazy. Yes, writing is a bit of a roundabout ride but don’t we all love it! (Sorry not to reply before, for some reason WordPress did not tell me there was a comment).

  43. Aivan mahtavaa!!! Jokin on muuttumassa… mut hitaasti:Siis se vaahdotuaine lääkkeissä NATRIUMLAURYYLISULFAATTI eli sodiumlaurylsulfat, se joka aiheuttaa aftoja limakalvoille (muuallakin kuin suussa niitä on!) on alkanut vähentymään läkelaitoksen luettelossa. Kuluttaja on kuningas, mutta kovin huono, jos ei tiedä, mitä kannattaa ostaa! Aika paha, kun ei aina voi valita, ei ainakaan, jos lääkäri määrää just sitä pilleriä, mistä tulee uusi vaiva ja sekin pahentuu sitten…

  44. Jenny! This is fab! Your landlord must thank god every day you moved in!!I would fix the crooked part, it would drive me nuts. But what a massive improvement!!

  45. his could be a sign that these are truly the last days everybody needs to wake up jesus is soon to come don’t let the media cloud your mind about these being fake they refuse to let you believe in these things because they do not want you to think outside of the box.

  46. You should let partnership for everyone who has orignal content. Not restrict it to certain countries and certainly not continue to bypass intelligent vloggers and giving partnership to idiotic video m akers.I'm sure this will fall on deaf ears, but it ticks me off to be rejected for your so called program THREE TIMES.LET EVERYONE IN.

  47. NGADIOS | (12:50) yango oyo administrateur ya ndenge nini ,oza kaka neti batu oyo bazo diriger na congo ,zala na respect ya batu ba zokota site na yo oyoki ,aprés okoloba ke okola malamu yo okanisi soki père na yo azalaki na mua moyen yango nde elakisi kokola malamu?ba oyo bazo commenter awa yo oyebi ndenge bakola?soyez le bien kozonga na MELUN place omesana komela na ba exotique ,administrateur ya ba nganda… na sololi

Leave a Reply

Your email address will not be published. Required fields are marked *