The CHOOSE keyword

G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...

TSQL-Tuesday#050 – Automation

TweetG’day,

Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to...

Do you clean up after yourself?

TweetG’day folks,
I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that...

Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!

TweetG’day,
Just a quick post on a seemingly trivial matter that others may find useful.
The post was prompted by the Simple-Talk...

SQL Saturday #252, Christchurch New Zealand

TweetSQL Saturday #252 Christchurch, New Zealand
G’day,
Well, these are exciting times for the Christchurch SQL SERVER User Group.
After a period of...

Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS

TweetG’day,
As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open...

Multiple ALTER DATABASE SET options

TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...

SSPI error and Incorrect timing.

TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...

The first record on data page.

TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...

2012 DDL for Roles

TweetG’day,
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored...