My thoughts on Xbox One

I watched the XBOX One launch video today on my XBOX 360 console dashboard.  It is impressive in some ways but I am really disappointed that they are going to charge you if you buy a used game.  I only buy used games so this made me quite upset.  Actually, I got so angry at Microsoft that I cancelled my Xbox live subscription so it will end in January and I will not renew it.  They will only be hurting themselves.  A minority but still significant portion of people who buy new games count on being able to sell them when they have finished playing the games.  They use the money they get from the sale to buy more games.  Those that buy the used games when they are still relatively new might still buy the game new if it was not available used but many of the other used buyers like me would not buy the game new.  I get about $10 of fun out of the average game so I will not pay more than that for it.  Some games like Civilization, Dragon Age, Sacred or Kingdom Under Fire were worth a lot more to me but then there were games that I bought and then only played once or twice.  Maybe they will realize the economics of the situation when they finally start selling the system and as games age.  Maybe that will cause them to reverse their policy but that will take a while.

The media components of the Xbox are cool but many of the new TVs or blu ray players have social networking, video on demand, chat and audio streaming built right into them and those who do not have that can get a Roku or an Apple TV.  I would rather get an Apple TV for $100 than pay several hundred for an Xbox One.

I didn’t see anything on it but is it going to output in 4k resolution?┬á I am looking forward to the 4k technology.┬á If I was designing a game system I would make sure it had 4k video and 7.1 surround sound and make it very social for gamers. Make it easy to take pictures and videos of games and to post those to social networks.┬á Let gamers update their social networks with gamer stats and live updates from games and create parental controls to keep kids safe.


June 19, 2013 update: Microsoft backs down on DRM.

Windows 7 and the Microsoft Strategic Commander

Microsoft released one of the greatest gaming controllers with the Strategic Commander back in 2001.  The controller fits perfectly in your left hand so that your right hand can still use a mouse.  It has six programmable buttons and three shift keys for 24 possible combinations.  Beside the buttons is zoom bar that allows you to zoom in and out.  The entire unit swivels on a base so that you can change orientation in a game.  A toggle switch on the side allows you to change modes.  Three modes can be programmed giving you 72 possible programmable buttons.  Using their sidewinders software you can assign complex actions to the buttons such as shift and 1 or a series of steps like shift + 1 and then alt + C.  You might wonder how this could be useful so let me explain. 

You are playing a real time strategy game and you want to built a barracks to produce units.  Normally you would click on a free worker and then select build structure and then select the barracks.  There are key combinations to perform each of these tasks but most of us do not memorize all of them.  Some gamers might memorize the last one which in this case I will assume to be the letter B.  With the strategic commander you can do all that with the press of one button.  Program a button to execute Shift + A to select an available worker then S for build structure and then B for the barracks.  It is easy to see how this controller can improve your gameplay. 

The strategic commander can also be used for regular windows tasks.  The programming works in the same way.  You can set a button to open your favorite programs or copy, paste, delete.  Photoshop users can program macros into the buttons to perform edits quickly.  The device is really amazing. 

You’re probably wondering why you’ve never heard of it if it’s so great.┬á Well, Microsoft discontinued the device in 2003 citing poor sales as the reason.┬á Still, enthusiasts created drivers for Windows XP and then Vista and now Windows 7.┬á For Windows 7 you can use a driver called ATK0110 ACPI Utility (Download for Vista works on Windows 7) and software called Strategic Engine to program it.

So for those of you with strategic commanders, dust them and use them again.┬á If you don’t have one an ebay search will still turn up results.┬á


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.Extensions" publicKeyToken="31bf3856ad364e35"/>

        <bindingRedirect oldVersion="" newVersion=""/>




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 doesnÔÇÖ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 (ore 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 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 questions 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. Lets 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.

Read the entire article here :

For interviewing help go to


Full Text Catalog Organ Transplant

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 here 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. 

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.┬á 🙁