My Public Events RoundUp

Categories: News, Professional, SSC
Comments: No Comments
Published on: May 10, 2011

As a part of my careers goals, I am trying to remain involved in the community through various engagements and events.  Recently, I was able to present to the South Africa Johannesburg group as a part of SQL Saturday 83.  I posted an announcement on that opportunity here.

I wanted to briefly cover my experience with that presentation.  I was quite pleased with the presentation and know that I could have done better with it.  That is where practice comes into play with each presentation.  One area of concern was trying to invoke group participation.  The group in JHB participated quite well – considerably better than the last time I presented this particular presentation.  I don’t think the book giveaways had much to do with it since I didn’t even mention that.  Also, they were participating well before we did the first book question.  I might have been a bit punchy during the preso – lack of sleep and sinus meds might have contributed.

I would like to thank everybody in JHB for a great job.  It was nice having a panorama camera available so I could see the group too.  That was very helpful.  I have not heard back yet if the recording is going to be made publicly available.  If so, I will pass it along so more of you can poke fun at me. ;)

This week, I will be giving that very same presentation to the DBA Virtual Chapter.  That presentation will be Wednesday May 11, 2011 at 12PM Mountain Time.  Since this is a virtual chapter, that means the presentation will be done via livemeeting.  If you are interested, you can register and attend the meeting via these links.



I hope to see a few people on for this presentation.  It is a low-level kind of presentation and is aimed at creating useful documentation with sql scripts (thus helping reduce cost).

No Comments - Leave a comment

Leave a comment

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

May 2011
« Apr   Jun »


  • @vestergaardj: Anyone know any good resource for scale-out #SSRS scenarios, gotchas, best practices #SQLHelp SSRSHelp
  • @wsmelton: @PearlKnows not required, only is if you want to schedule the package. #sqlhelp
  • @AngryPets: #sqlhelp Looking for docs on why sprocs/OBJCP get evicted when a) they're 'correct', b) there's no memory pressure. Evicted, not recompiled.
  • @JoshLuedeman: @PearlKnows I’m pretty sure that’s not needed. It’s an exe on your local machine that handles the connections. #sqlhelp
  • @AaronBertrand: @jsauni filter on your current database_id - WHERE database_id = DB_ID(); #sqlhelp
  • @PearlKnows: #sqlhelp Must you have #SSIS installed to use Import/Export wizard? Or is the DTSWizard.exe separate.
  • @AngryPets: #sqlhelp [3/3] Virtually no recompiles. Plans just don't 'stick'. Simple/repeat sprocs 'pruned' after 10 - 20 seconds. Ideas/Docs?
  • @AngryPets: #sqlhelp [3/4] No schema changes, colmodctrs are minimal - 'correctness' isn't the issue. SQL Compilations/sec is about 1/4 of requests/sec.
  • @AngryPets: #sqlhelp [2/4] I have < 2GB (total) of PHDR + OBJCP + SQLCP + XPs in cache, but constantly seeing plans 'kicked' from cache.
  • @AngryPets: #sqlhelp [1/4] Looking for docs on how/why SQL Server 2014 removes plans from cache. Server has 96GB of RAM, PLEs consistently > 23K

Welcome , today is Wednesday, January 28, 2015