SQL Server Diaries

When being asked to deploy changes to a database, sometimes the TSQL files are not provided to us (DBAs) using a “user-friendly” naming convention. Countless times I have been provided with script files similar to the below: [Read More]

When I started thinking about bringing back the SQL Server Diaries blog, my starting point (and the only source to recover the old material) was an eight-year old WordPress export. Those who use Wordpress know that the data can be exported as a series of MySQL INSERT statements, as well... [Read More]

It’s been a while since my last post. Eight years actually. Unfortunately when the blog went offline back in January 2013 I lost my muse for a while. Like all IT professionals working in Ops, I did still write the occasional “TL;DR” email or publish an article in my workplaces’... [Read More]

A quick catch-up. [Read More]

After two years of writing, my (previous…) hosting provider unfortunately managed to lose all my articles; they couldn’t even recover the configuration from their own backup! I did recover all of the content from my own backups and will re-post all articles in due course. [Read More]