Category Archives: Uncategorized

Patching

We had a communication from an Ops team saying that they intended to apply Windows patches to all our SQL Servers in one six hour period. This just felt wrong, on so many levels, including: QA, UAT, DR, Production all … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Data Cleansing for Fun & Profit

It was during SQLBits 10 in London that I first uttered the phrase “data cleansing for fun & profit”, as a spoof presentation title during Buck Woody’s “Moves Presenting Like Jagger” presentation. ¬†I hadn’t really thought about it much since … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged | 2 Comments

Off Topic: Sponsorship demands!

Martin Handsley, the chap who got me started on this “career” as a SQL Server DBA and occasional blogger, is attempting something amazing. He and a colleague are attempting to walk 100 miles in 24 hours along the River Thames … Continue reading

Posted in Uncategorized | Leave a comment

Housekeeping, News, No SQL content

Nothing SQL-related to read here, so if that’s what you’re after, forget it for this month! A couple of things have happened recently that haven’t necessarily warranted their own post, but, seeing as I’ve not done anything else blog-wise this … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

SQL Server User Groups

I’m a bit swamped with reality, pressures of work etc, this week, so I’ll just take the time to say: Find your local SQL Server User Group and visit It’s not difficult. ¬†Googling for “SQL Server User Group” will show … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , , | 4 Comments

String Concatenation using XML Path

This is really here partly for my own reference, and partly because it is the answer to quite a few questions on Ask.SQLServerCentral.com. For example, we had recently this query from a chap who was looking to build with one … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , | 4 Comments

Hiatus – apologies

I would like to apologise for the failure to keep this blog active over the last few weeks. Combination of major project delivery at work, reaching the end of another project at Apress, and a week in the orchestral pit … Continue reading

Posted in Uncategorized | Leave a comment