Microsoft Certifications

Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...

MS Access – Store a Different Value than Displayed in a Combo Box

It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...

My thoughts on Recertifying your MCSE through Microsoft Virtual Academy

A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...

Query shortcuts in SQL Server Management Studio

Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...

Too many indexes!

Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...

Why I Practice Presentations

I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want...

You don't need any Training? OK...I believe you.

This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop...

An Update on My 2012 Mac Air

Typically I want to get 3 years out of a laptop to amortize spending on a premium grade machine. I’m...

Check Database Server Workload - Batches/ Sec

Today's post is about a simple but very useful query.

One of the basic things one needs to check is the...

Diff All Files - Reviewing Changesets Quickly

Update: 2017-07-14
Still find this incredibly awesome! Developer just updated for Visual Studio 2017 after a lot of hard work. Github...