Archives / 2007 / February
  • Spam Countermeasures

    Spam is an increasingly annoying and expensive part of our lives as computer users.  In the last week, I’ve been forced to take measures to deal with spam on several of my web properties.  On, an online library of regular expressions, it was brought to my attention that a large amount of comment spam was being added to expressions.  After some analysis, I ended up cleaning out over 35,000 spam comments spanning the last 18 months or so.  Among these were also a few cross-site scripting attack attempts made possible by a lack of HTML encoding in the comments.  I corrected these issues and emplaced a CAPTCHA, as well as changing the IDs of the … more

  • ObjectDataSource could not find a non-generic method Update Error

    So I’m writing a quick demo for a book chapter, and I want to use something close to best practices, so I’m eschewing the SqlDataSource and favoring the ObjectDataSource.  Because this is meant to be a quick example I don’t want to spend a lot of time helping the reader get the database set up, so I’m using the built-in ASPNETDB.MDF database that gets created in App_Data when you select the Web Site Configuration Wizard, and I’m going to edit the aspnet_Roles table using a GridView. After creating a TableAdapter by adding a new DataSet to my project and creating the necessary Select, Update, Insert, and Delete columns, I wire up my GridView to an … more

  • Dell Dimension SATA Drive Windows Installation

    Last week I had to rebuild a Dell Dimension 9150 with an SATA hard drive and when I tried to install Windows XP I received an error saying txtsetup.oem not found when I tried to provide the drivers on a USB floppy drive.  I searched for a while and found nothing terribly helpful so I contacted Dell via phone and chat (sat on hold on both – chat answered quicker).  Via chat they were able to solve my problem as follows: 1) Reboot and hit F2 on the Dell screen2) Go to the SATA Operation section3) Change to Combination SATA/PATA mode.4) Reboot and re-attempt windows install Windows XP was then able to see the drive without my having to use a floppy drive and F6 to … more

  • MVP Live Chat Tonight

    Join Scott Guthrie, myself, and numerous other MVPs for a live chat this evening sponsored by StrongCoders.  The chat starts at 8pm EST this evening, 16 February 2007.   more

  • CinCHouse Article

    ArmyAdvice and Christie and Ryan were mentioned in an article on deployments by Allison of CinCHouse, an online community for military wives and women in uniform.  It's a good writeup about how technology can help ease the pain of deployments, especially the fear that comes from not knowing.  I'd like to add that I'm still accepting new bloggers on ArmyAdvice, so if you're reading this and you're a soldier or military wife (or husband or significant other), please Sign Up and request a blog. more

  • SQL Reporting Services 401 Error

    If you just installed SQL Server Reporting Services and you are getting a 401.1 Unauthorized error when you try to go to the http://localhost/reports this post may help.  I ran into this and was having a heck of a time figuring it out, since I assumed that since my Reporting Services Configuration Tool was all GREEN that I was good to go.  Not so. In my searching I eventually found this post which led me to my old friend, a KB article I’d already found once a week ago when fighting with Reporting Services on Vista.  My search also yielded this (more of the same). I never did get RS working on Vista so tonight’s task was to get it working on a from-scratch XP … more

  • Resignation Letter Template Posted

    A lot of officers are looking for information on how to resign, and unfortunately the Army doesn't make this easy to find (I can't imagine why...).  Thus, I've posted my resignation letter (sanitized) for download in the downloads section of  I also want to make sure people have a reasonable expectation of the timetable involved, so here's a summary of how things went for me (admittedly some time ago):6 January 1995 - Enlisted as E3 w/8 year commitment (ETS 5 Jan 2003)25 July 1997 - Received 2LT Commission - commitment automatically extended to commission date + 8 years (26 July 2005)20 July 2005 - Sent resignation letter, with … more

  • Need Work - Cure Cancer

    Fellow RD Stephen Forte is hiring for a project that promises to help accelerate a cure for cancer.  The work will be performed remotely using the latest Microsoft tools and technologies.  If this sounds like something you might be interested in, please read his complete requirements and get in touch with Stephen. more

  • Murach SQL Server 2005 For Developers

    Recently I picked up a copy of Murach's SQL Server 2005 For Developers, and while I haven’t had a chance to really read it through cover to cover, I have read the first few chapters and skimmed the rest.  It’s a meaty book, and is actually not a first edition as the name might imply but is a third revision book (with a new title) — meaning that there are no glaring holes in it that first-time efforts sometimes have.Ok, so it’s a book on SQL Server 2005, that’s obvious.  But why is it interesting compared to so many other such books?  The main reason is that it is very approachable – there is not a lot of dense text, just simple … more

  • Reporting Services Plus Vista Equals Pain

    I spent quite a few hours yesterday trying to get Reporting Services to work on my Vista laptop.  It didn’t end up working.  For quite a long time I got a login prompt when trying to go to localhost/reports, which would bomb after 3 tries and had references to several KB articles, including this one: None of the ones listed helped.  I found plenty of others with similar problems.  I made sure to install the December CTP of SQL Server 2005 SP2 but that didn’t help.  I found this newsgroup post that seemed like it might help, but didn’t.  Perhaps it will help someone else. As it stands now, going to … more

  • Offering Remote Assistance on Vista

    Julie showed me how to do this on XP/2003, which helped me figure it out on Vista.  Following her lead, I created some screenshots… First go to your Start/Windows icon and click on Help and Support. Click on Windows Remote Assistance under Ask Someone. Next click Offer to help someone Now you can type in the IP address of the user you’re looking to help, and if they accept your request, you can control their PC and show them how to do stuff or help them troubleshoot a problem.Tags: RDP more