Keeping up with SQL Server Connect Items Marked Closed as Fixed

May 11, 2016 · 1 min read ·

Share on:

Earlier this week, I was trying to determine people's feelings about Microsoft Connect by looking through Twitter. A few scrolls down, and I came upon this

@Ms_Alaina My problem is I sometimes stumble upon a Connect item I filed in 2008, and have no idea when it was closed as fixed.
— Aaron Bertrand (@AaronBertrand) December 4, 2015

That gave me the idea to make a Twitter bot, which I called @closedasfixed, that searches Microsoft Connect for items recently marked as Resolved or Closed as Fixed.

Syntax error in sp_readrequest prevents proper error and can halt DB Mail - @AaronBertrand https://t.co/qudWG1N8oG
— Closed as Fixed (@closedasfixed) May 11, 2016

Basically, it scrapes the website every 30 minutes (their feed rarely gets recompiled so is not useful) and posts one Tweet. Seems to be a hit so far, gaining nearly 50 followers in just one day.

Here's my Scraping and Twitter code if you'd like to roll your own :)