SQL Server version information from build numbers

Just a quick post in case anyone else finds this useful; for a report I’ve created, I wanted to have SQL Server versions displayed in a nice, readable form, rather than the usual build number format (e.g. 11.0.3128.0). So I found the very useful SQL Server Builds page (thanks to whoever maintains that), and proceeded to […]

Read More

Customising SQL Management Studio 2012

I’m setting up my new work laptop, and decided to have a look around the net for what the cool kids were doing these days to customise SSMS 2012.  Surprisingly not a lot seems to have changed (i.e. changing font, adding keyboard shortcuts, and using a trendy dark theme are still the most common tweaks). Aesthetics […]

Read More

What’s in your toolbox?

I’ve had a few weeks off work recently, during which time I decided to tidy up (or attempt to anyway) my collection of “utility scripts”.  This consists of about 95% regular T-SQL scripts, with the rest being a mixture of PowerShell scripts, batch files, etc. This made me wonder how other people managed their collections, […]

Read More

SQL script of HTML status codes

Bit of a random post; I couldn’t find anything similar online, so created this script and thought I’d share it in case anyone randomly needs a lookup/dimension table of HTML status codes. All pulled directly from Wikipedia.

Read More

Combining different database technologies

Well the past month or two have been “busy”; I bought an old motorbike and restored it (win!), I sold my main motorbike and bought a new one (bigger win!), I then crashed it (not badly, but enough to ruin my day – boo!), I got the repaired bike back 4 weeks later (yay!) – […]

Read More