formats

SQLRelay 2014 slide decks

I’ve just finished a few enjoyable days with the great people on SQLRelay.  I only managed to get involved with the Newcastle and Leeds events, but it was an amazing experience.  The interaction I got at the end of my Leeds session was fantastic – I’ve never had so many questions. Some of the questions I

formats

SQL Server conference season

SQL Conference season is upon us it seems. Unfortunately I don’t get to go to the PASS Summit, but nevertheless, it’s manic here too. SQL Relay started it’s first leg (13-16 October) last week, and is now having a week of rest! On Friday 24th October, I’ll be heading down to London for the annual

formats

SSDT error SQL71501: Procedure: contains an unresolved reference to an object

I’ve recently started to use SQL Server Data Tools (SSDT) a lot more in database development. And I must say that I’m quite impressed. Having previously used database projects in VS, and fought with msbuild, SSDT is much easier. If you are starting out with SSDT, then I can’t recommend enough that you read Jamie

formats

Replacement RSS reader – update

It’s a few weeks since I blogged about finding a suitable replacement for Google Reader, but I can say I’ve found it. Despite having a rocky start, Feedly has become a mainstay of my daily information overload, and they’ve come a long way to fixing a lot of the issues I found. In fact they’ve

formats

Why I am studying for SQL 2008 exams

I recently passed the Microsoft exam 70-451, earning myself the MCITP certification Microsoft Certified IT Professional (MCITP): Database Developer 2008, and I’m often asked why am I actively chasing 2008 certifications especially when the SQL 2008 exams are due to retire at the end of July 2013 the SQL 2012 exams are now fully available,

formats

On the hunt for a Google Reader replacement

When I first heard about Google’s decision to close down Reader , I was disappointed, but also quietly confident that I would find a new reader and that it might even open my eyes a little, enhancing my newsfeed consumption. It also meant that I would probably have to spring clean my news feeds too

formats

SQL – rounding to nearest 5

Had a requirement to round some price values to the nearest £5 in a SQL stored proc. It’s easy to round to the nearest 10 using a negative value for the length parameter of the ROUND function i.e. returns 10 returns 20 but length must be of type tinyint, smallint, or int; so you can’t

formats

Exceptional DBA

It’s that time of year again when Red Gate open the nominations for it’s annual Exceptional DBA Award. I entered and made the final 2 years ago, and honestly believe it has added value to me as a SQL professional.  I was immensely proud to be associated with some ‘big names’ in the SQL world, and be

formats

Power and Deception of CTEs

This is a reprint of an article of mine that appeared on SQLServerCentral.com in December 2008 Introduction A customer of mine had a performance problem with a stored procedure that uses Common Table Expressions (CTEs). The performance had gone from sub second to 10-12 secs, and the approach that was being taken to diagnose and

formats

RECONFIGURE messages in SQL Log

One of the best ways of monitoring your database server health and general well-being is to keep an eye on the SQL Server Log. A lot of information gets written to this log, and it can be quite daunting if you are trying to look for pointers in the event of a server failure or