• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

Enough of the theme test posts already!

September 5, 2011 by John Sansom 1 Comment

Some of you may have experienced a rather annoying volume of theme test posts in your RSS Reader yesterday. My apologies if that was the case.

If you have no idea what I’m even talking about then you can completely ignore this post too :-)

Ironically in an effort to improve visitor experience to the blog website, it was migrated from a Windows Host to a Linux host over the weekend but clearly with a few teething problems.

The Technical Stuff Bloggers May Find Interesting

I sometimes use Windows Live Writer to author blog posts. I find it to be a fantastic blog authoring utility however on this occasion it unfortunately did not want to play nice in the new environment. The test posts should have been automatically and immediately removed but this was not the case for some reason.

If you’re quick about it though, you can delete the posts in WordPress before FeedBurner publishes them to an RSS Feed. By the time I had discovered  there was a problem however, it was already too late.

Having deleted the posts in WordPress, the next step is to resync the RSS Feed in FeedBurner under the Troubleshootize menu. Doing so fixes the original RSS feed but of course Goolgle being the clever folks that they are choose to cache rss feeds on their side. So even though the offending posts no longer exist in the actual RSS Feed, they will still appear in Google Reader.

Now there is a sort of work around to this, involving the create of posts with the same GUIDs, a WordPress hack and then modifying the posts to have an old publication date, thereby forcing it to the very end of a feed. To be honest, that’s too much like hard work for a busy DBA and so instead I’d rather beg for forgiveness and move on :-)

Here’s how it can be done though for those that may be interested:

  • How to Effectively Delete a Blog Post

Filed Under: Blogging

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy