New Arrival
Produced: 30/08/2015 12:08:00
So I’ve been a little quiet on here recently, well there’s a good reason… 3 weeks ago today I became a dad for the first time and therefore I’ve been a little too tied up to keep my website up to date.

Continued...
A Little Happiness in SSMS
Produced: 23/08/2015 06:52:00
This is basically an introduction into something I want to play with in some upcoming posts, but to start with I thought I would introduce the topic with a little bit of happiness.

Simply it’s the lesser known ability (it’s VERY rare to find anyone who knows about this) of SSMS to natively produce shapes and graphs based on data you provide it.

Continued...
Using sp_executeSQL with Variables
Produced: 16/08/2015 05:29:00
When looking through other people’s code I tend to find that people struggle with dynamic SQL and how to write it in the best way. Specifically when it comes to using variables within the dynamic string.

Generally people will start to concatenate all over the place, which tends to involve awkward conversions or casts and can start to look really messy and unreadable.

Continued...
Quick Note About INSERT INTO vs SELECT INTO
Produced: 09/08/2015 05:14:00
The debate about INSERT INTO vs SELECT INTO can be quite long and get people quite heated and therefore I’m not going to go into the entire thing right now, but what I did want to mention was something that I encountered the other day and which could be worth considering next time you’re deciding which approach to take.

Continued...
THROW instead of RAISERROR
Produced: 02/08/2015 05:09:00
I’ve done a couple of posts about RAISERROR, but if you’re using SQL Server 2012 and above then there’s a new syntax also available which I think is a little better. That syntax is THROW.

This does a very similar job to RAISERROR but has a couple of advantages that I want to highlight.

Continued...