CREATE DATABASE – I’ve not seen that before.

TweetG’day,
It’s been a while
I thought that I’d make a quick blog post about an incident that I encountered today...

What’s happening in Asia Pacific?

TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.

I...

TSQL Tuesday #68 – backup checksum default

Tweet
G’Day,
Well it seems like TSQL Tuesday #68 is providing me with a real good reason to get back into my...

More Azure SQL Database Enhancements – Meet RLS (cloud first debut)

TweetG’day,
Well, it was only a few  days ago that I blogged about some major Azure SQL Database enhancements. Primarily, in...

2014 – A year in review.

TweetG’day,
And so another year passes, and as I’ve never wrote a “year in review” post before now seems like a...

I’ve joined the SQL SERVER MVP community – Thank you!

TweetG’Day,
Today I awoke to find an email from Microsoft informing me that I’d been awarded an MVP. Wow.
I had to...

A real life table variable performance problem.

TweetG’day,
I’m sure we’ve all heard and read about the differences between table variables and temporary tables. In case you haven’t...

SQL Saturday #316, MVP’s, MCMs and a baby.

TweetG’Day,
Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).
We learnt...

Import export wizard at the commandline

TweetG’day,
Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something...

Two IDs, One database and a Magic Number (and maybe even an empty string)

TweetG’day,
I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least...