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...

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...

Microsoft Certifications

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

A quick note comparing ISNULL vs COALESCE

There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...

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...

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...

This Week In Data – Episode 8 (Mastering the Tech Interview)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Why Can’t I View My Power BI Content Pack?

I had a call with a customer this morning discussing different ways to publish Power BI content and how to...

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...

Stretch Databases in 60 seconds

SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What is it? A stretch database is basically a database...