Category Archives: Uncategorized

Replace [Replace] with Replacement

Dear Microsoft, Thank you for sending me a follow-up email after I downloaded something from your website. Unfortunately, the email isn’t particularly helpful. I’ve tried clicking the “Having trouble viewing this email? Click here to read it in a browser” … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Filtering sp_who

sp_who – useful – up to a point. Particularly when the server is busy, and you’re looking for something specific (eg to see if certain processes are out of a database before running an update) If the server is busy … Continue reading

Posted in Uncategorized | Tagged , , , , | 2 Comments

Availability Groups, Busy Databases, and Badly-Timed Reboots

A server’s availability group was mostly healthy, but for a couple of databases. There was nothing apparently wrong, but they weren’t synchronised, and we were beginning to see transactions failing to complete as they couldn’t be written on the secondary. … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

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