I have been struggling with some ASP AJAX code.  I moved the site from Server 2003 32-bit IIS6 to IIS7 on Server 2008 64-bit.  After a lot of searching and banging my head against the wall, I found a blog on MSDN that told me how to add a binding redirect to my web config file so that the code would use the AJAX built into .NET 3.5.  Here it is.



    <assemblyBinding xmlns=urn:schemas-microsoft-com:asm.v1>


        <assemblyIdentity name=System.Web.ExtensionspublicKeyToken=31bf3856ad364e35/>

        <bindingRedirect oldVersion=>




Obtained from:


Interviewing Tips from Microsoft

In a 2008 blog entry by Steve Clayton at Microsoft, he mentions the five things he looks for in candidates when hiring.  This information is useful for both job candidates and those looking for qualified people.  Here are his five tips:
  1. Hire for diversity, not consistency – I wanted people in my team as diverse as I could. Having twenty brilliant but unmanageable tech wizards in the team don’t work. Balancing out the wizards with the delivery guys worked out well.
  2. Hire Delivery Guys (and girls) – I don’t mean postal workers. I mean make sure you have folks who simply deliver – again and again, on time and with minimum fuss. When the chips are down, they come to the fore, and your wizards take a back seat. As a side note, figure out what makes these people happy and reward them well. They’re gold.
  3. Hire Wizards – in my experience everyone great team has one (or more) who are just brilliant minds. They’re the creative ideas people who differentiate you from the average team. They’re often a nightmare to manage, but they’re worth it. How do you know a wizard? They’re curious
  4. Hire Curious People – by this I mean people who have a natural curiosity. Stephen’s mentions this in his interview with Bill Taylor, and it struck a chord with me. These are the people who ask questions. Constantly. They may not ask questions out loud, but they will question things and often go away and explore to find the answer for themselves. They may never need the information or us it – but one day they may. Trust me this is a very valuable skill. These people become information hubs, and you hear their names again and again in the company as they’re “go to” people. I learnt some of this from my Granddad…but that’s a story for another day.
  5. Hire Passionate Readers – this doesn’t mean hire people who read Mills and Boon. It’s similar to curious people but worth calling out separately. A friend (who is a wizard and curious) taught me this interview question when I joined Microsoft. Ask someone what magazine they regularly read. Let’s say they answer with WIRED. Then ask them how many back issues they have in their loft. It’s not a deal breaker question, but my guess is if you’re reading this you know what I mean. People who are passionate about stuff read about it. A LOT. Okay so they may read online now, and this question may be dated but try it anyway. They may say “ah I just auctioned off my 8-year collection of National Geographic on eBay.” That’s a hire.

For interviewing help go to

Full Text Catalog Organ Transplant: Moving SQL Server full text indexes

Full text searching allows more complex searches such as word or phrase searching, inflection matching, proximity searching, and relevance matching to be performed on many different fields within tables.  In order for these searches to run SQL server builds and maintains a catalog.

We have such a large amount of data that rebuilding a full text catalog can take as long as 14 days.  We needed a way to be able to bring the full text catalog back without rebuilding it, essentially, I needed a backup.  Microsoft does not backup the full text catalog in normal backup operations and you cannot access it with software while the server is running because it is always in use.

You cannot use standard backup commands to back them up and Microsoft does not have any utilities available for the task either.  They do, however, have a guide for how to migrate it from one server to another.  We needed to do just that.  I call the process full text catalog organ transplant because organ transplants require the patient receiving the organ to have the same characteristics as the donor in order for the body to accept the new organ.

Full text catalogs need to have a destination system with many of the same characteristics as their previous system or they will not work at all.  The characteristics that must be similar are the SQL server version, full-text catalog folders and file locations, full-text catalog folder and file names and contents, and the same database id and table ids on both servers and databases.

The first few similarities are easy to recreate on the destination system.  The database id is a little more difficult as some DBAs do not even know what the id is for their databases.  You can obtain the database id of a SQL server database by issuing the following command:

Select db_id()

You have to be in the database you want to query first.  Use databasename will accomplish this.

This database number is generated when the database is attached to the instance.  Since the numbers have to match between source and destination, you need to create a situation where the database will receive the same database id when attached to the destination as it did at the source.

We found that you can reuse numbers from databases that have been detached so the process involves knowing the database ids of the databases you will import and then the ones in use at the destination.

If there is a database using the needed id, simply detach it, attach the imported database, and then attach the database you just detached.  The imported database will assume the detached database’s id as long as it is the lowest available number.

If you have a gap in numbers such as in this example where there is no database with an id of 6 you will need to fill that gap first.  NOTE: master, tempdb, model, and msdb always have the numbers you see below.  You can do that easily by attaching the database with the id you want to use first so that it consumes that spot.

Database ID
master 1
tempdb 2
model 3
msdb 4
Database1 5
Database2 7
Database3 8
Database4 9

If you have a number of gaps and not enough databases to fill them you can create new databases with no data in them to consume database ids.

The rest of the process can follow the guide outlined in Microsoft’s knowledge base article 240867 so I will not go into details on the procedure.  I hope this helps you if you are in the same situation.

Microsoft Database Administrator

Another certification.  I took the MCDBA (Microsoft Certified Database Administrator) tests and passed them all.  I finished the last one today.  I will take a break from certifications for a while and then pick up on them after a few months.  I may try for CEH (Certified Ethical Hacker) next.  We will see.  For now, I will enjoy the rest of my vacation. 

New Vista Beta

Ian gave me the latest Beta of Windows Vista. I have the 64-bit edition and I hope it will work this time. Right now I have the 32 bit edition installed. I should have it installed by tomorrow so expect a review soon.

Source Force – Microsoft Action Figures

Ian got me the 4 Microsoft guys from the Source Force. I gave a few of them different names when Microsoft was doing the promotion. I call the green one the programming pervert because he has the visual studio sign over his eyes like someone who is peeping. I call the orange one the Database Domanatrix because she is for SQL Server and she has some tough gear on. Here is a picture of the figures. Also below is a picture of the source force at TechEd 2006 in costume.

SourceForce2 SourceForce1

Vista Updates

The reason why Aero Glass fails sometimes is because Virtual PC 2004 does not support the Aero glass look.  I can turn on glass when Virtual PC is not running and not VM (Virtual Machines) are in a saved state.  However, I have been using SQL Server quite a bit lately so I have not been able to enjoy Aero Glass.  🙁