It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical post. I have been asked a few times over the past month where I got my online name from – BLOBEATER.
Well I will tell you. Firstly one of my favourite topics is DBCC CHECKDB ( and no I can’t use DBCC WRITEPAGE to fix corruption). Learning about it via sqlskills I noticed an internal variable called BlobEater which is a dummy variable with no purpose other than to consume any output from the CheckIndex function (source: http://www.sqlskills.com/blogs/paul/checkdb-internals-what-is-the-blobeater).
I thought this would be a good name for my online identity when you also throw in the fact that in my younger days my nick-name was BLOBBY!
So a past nick name + reference to of my favorite subjects ( which happens to be written by my ex-mentor) = best possible online name for me.
Statement Execution, Stored Procedures, and the Plan Cache
SQLOS Memory Management and Memory Performance Tuning
Performance Issue Patterns
All the above was covered over 10 days (split across 2 courses), each day was very intense but fun at the same time – the sqlskills team are really engaging, passionate and have great energy between them which at times left me in stitches. Obviously I Learnt alot but more importantly certain areas just made much more sense to me after that specific session – I mean, who better to tell you about how logging works than Paul?
If I was to pick 3 of my favorite modules they would be: (No particular order) Wait stats, Transactions / logging and Memory performance tuning.
A special mention to the last module in IEPTO2 – Performance issue patterns. Here we had to use what we learnt over the 10 days to diagnose a scenario and present a solution to the problem given to us – which varied from plan cache bloat to INSERT hotspots – this was an interactive and fun module! It was really tricky as some parts of the issue would lead us completely down the wrong path, much to Jonathan’s pleasure!
If you get a chance to attend these classes you will not be disappointed, you will feel more confident in your daily job and be better prepared for those “late” nights.