Chinh Do

Programming

• Borland Turbo Pascal was my favorite language in my early days of hobby programming. I feel a little sad to hear that Borland recently sold their CodeGear division to Embarcadero.
• Day-to-day with Subversion is a good and detailed write-up on procedures most developers need to perform daily. By Bil Simser.

.NET/C#

• The evil sou file - fighting and winning with Visual Studio. By Brian Noyes.
• Joshua Flanagan had an interesting idea on a Readable Regular Expressions framework.
• Derik Whittaker posted a tip on how to share config files between projects.
• Jon Galloway: //TODONT: Use a Windows Service just to run a scheduled process.
• You can throw away your own TitleCase method now. Because there’s one in the framework. Via ASP.NET FAQ.
• Operator~ and BinarySearch. By Shahar Y.
• Steven Harman detailed a hack to get Visual Studio to use more than 2GB of RAM.
• Frank-Leonardo Quednau: Lazy instantiation one-liner of instance fields with the coalesce operator.

Software and Tools

• Google Maps Street View is in Richmond.

  Goo

  It looks like the Street View images were taken around September 2007 because according to IMDB, the movie Game Plan was playing in the US starting 9/23/2007:

  

• Google Maps adds user-created photos, videos, maps. Via CNET.

  Goog

Something Different

• Top 50 soccer goals (video).

Just in case anyone else needs to do this out there…

I recently got myself a nice ThinkPad X60 Tablet PC. It doesn’t come with a DVD-Drive and although I have an external DVD drive, I just can’t seem to find its power adapter. Argg!

In order to do this, you must have the following:

• Windows XP installed on the PC you want to install Vista to.

Procedure

1. Log in into Windows XP on the PC you want to install Vista to.
2. Use Partition Magic or another partitioning tool and create a second partition for Vista. Make it a Primary Partition (don’t know if this is required but this is what I did). Format the second partition with NTFS. Your Windows XP installation will be left alone and you will be able to dual boot to it.
3. Create a folder (let’s called it "c:\VistaInstall") and copy all files from the Vista DVD / ISO there (either extract the files from an ISO image using a Virtual CD/DVD emulator like Daemon Tools, or copy the files from another PC with a DVD drive over the network).
4. Run Setup.exe from c:\VistaInstall.
5. Choose Custom Install and follow the prompts to select the second partition you created.
6. Follow the rest of the on-screen instructions.

As part of the installation, Vista Setup will copy the installation files to the new partition. After it reboots, it’ll have all the files there to continue.

After you are done with the install, you can delete the temporary folder c:\VistaInstall that you created.

Programming

• Very good tips to gain a better understanding of your Project Managers: 10 things Project Managers wish Developers understood. By Frank Kelly.
• Jakob Nielsen’s Top-10 Application-Design Mistakes point out some common design problems that can be easily avoided.
• What’s your favorite code search engine? Learn to search for code better with one of these 5 Great Code Search Engines!. By David Knight.

C#.NET

• Scott Guthrie provided an extensive First Look at Using Expression Blend with Silverlight 2.
• Circular references with WCF: solved a different way. By Ruurd Boeke.
• Bored with nothing to read? Check out Jon Skeet’s C# and .NET articles and links. Lots of good stuff to peruse.
• Keith Brown’s Security Briefs: Limited User Problems and Split Knowledge discusses WCF services running under normal user accounts.
• WCF - Securing your WCF service. By William Tay.
• WCF - Fundamentals of WCF Security. By Michele Leroux.

.NET Tips & Tricks

• Did you know you can give threads any names you want (MSDN)? The names are extremely useful when it comes to debugging time:

  

• System.IO.Directory.CreateDirectory will create all directories and subdirectories as specified by the path parameter. No need to write code to create each directory in the chain. Just do this:

  Directory.CreateDirectory(@"c:\MyApp\Env\Dev");

• System.IO.Path.GetDirectoryName returns the directory name from a fully qualified file name.
  

Powershell

• Round-robin game scheduling algorithm in Powershell. By Scott Hanselman. Check out my C# 2.0 algorithm in the comments section.
• Mitch Denny wrote How To: Host the PowerShell Runtime.
• Use Powershell array expression syntax @(…) allows you to force a scalar return value to be wrapped in a array, if it’s not already in an array. I learned about this the hard way while trying to figure out while Get-Childitem sometimes returns an array and sometimes a scalar. Bruce Payette wrote more about it here.

Windows Mobile / Pocket PC

• I needed a way to stream music and other media to my Windows Mobile phone (Samsung SCH-i760) and all the PCs around the house. Orb seems to be the answer. I’ve only had it running for a few days but it seems to be working great. I can stream music and photos (have not tested videos yet) to any PC in the house or anywhere on the net. I can also listen to my entire music library on my i760 phone anytime, anywhere through Verizon Wireless’s unlimited (with a catch… not to exceed 5GB) EDVO connection.

  

• I am a Google Mobile guy, but Yahoo! Go for Windows Mobile also looks very cool. I downloaded it to my Samsung SCH-i760 a few days ago. I am still checking it out but here are a few things I like:
  • Nice and responsive interface.
  • Built-in RSS Reader.
  • Street and satellite maps.

    Here are a few screenshots:

    

    

     

Software and Tools

• You can configure Notepad++ to always use spaces for tabs/indentation. The option is a little hidden. It’s in Settings/Preferences/MISC, under Tab Setting:

  

Something a Little Different

• Alien Prank Goes Bad (video).

How often do you see DataReader code that looks like this?

using (IDataReader dr = cmd.ExecuteNonQuery())
{
    while (dr.Read())
    {
        int orderId = dr.GetInt32(0);
        string customerId = dr.GetString(1);
        int employeeId = dr.GetInt32(2);
        DateTime orderDate = dr.GetDateTime(3);
        double freight = dr.GetDouble(4);

        // do stuff
    }

    dr.Close();
}

If that looks like your code, you are not alone :-). Try searching codesearch.google.com for the following:

lang:c# (reader|dr)\.GetInt32\(

With the above code, anytime the order of columns in the SQL statement or stored procedure changes, the code is broken. And if you have lots of columns to read from, it’s a real nightmare to maintain the indexes.

The next time you write another DataReader loop, consider doing it this way instead:

using (IDataReader dr = cmd.ExecuteNonQuery())
{
    int ORDER_ID = dr.GetOrdinal("OrderID");
    int CUSTOMER_ID = dr.GetOrdinal("CustomerID");
    int EMPLOYEE_ID = dr.GetOrdinal("EmployeeID");
    int ORDER_DATE = dr.GetOrdinal("OrderDate");
    int FREIGHT = dr.GetDecimal("Freight");

    while (dr.Read())
    {
        int orderId = dr.GetInt32(ORDER_ID);
        string customerId = dr.GetString(CUSTOMER_ID);
        int employeeId = dr.GetInt32(EMPLOYEE_ID);
        DateTime orderDate = dr.GetDateTime(ORDER_DATE);
        double freight = dr.GetDouble(FREIGHT);

        // do stuff
    }

    dr.Close();
}

Using GetOrdinal makes the code much more readable and maintainable. You are calling GetOrdinal just once for each column, any performance penalty is insignificant compared to the benefits. Be careful not to put the GetOrdinal code inside the while block as that will unnecessarily slow you down (about 3% according to this article).

I think this is useful and not well known enough to warrant its own blog post.

Did you know that there is a Visual Studio command called File.OpenContainingFolder? Asmita A Wankhede wrote about it, but he left a few important details out.

By default, this command does not have a shortcut, so you would have to assign one to it (try CTRL+SHIFT+ALT+O). Also, the "item" that this command works on is the currently opened item in the editor, not the selected item in the Solution Explorer. See my Visual Studio tips article for instructions on how to create new shortcuts (section 3 - Make New Shortcuts).

This works with both Visual Studio 2005 and 2008.

It’s 2008. Happy New Year!

Tips and Tricks

• I can’t believe I didn’t know about this Visual Studio command before: File.OpenContainingFolder. Asmita A Wankhede mentioned it, but he left a few important details out. By default, this command does not have a shortcut, so you would have to assign one to it (try CTRL+SHIFT+ALT+O). Also, the "item" that this command works on is the currently opened item in the editor, not the selected item in the Solution Explorer. See my Visual Studio tips article for instructions on how to create new shortcuts (section 3 - Make New Shortcuts).
   
• Aaron Lerch shared a tip on how to use Powershell to perform search-and-replace on an entire folder hierarchy.

.NET, C#, Programming

• Derik Whittaker’s article on Things to think about if you want to be a consultant lists some questions to ask and things to be aware of if you are thinking about becoming a consultant or contractor.
• I need to start using Log4Net soon at work and Emanuele Bartolesi’s walk-through on how to use Log4net in your ASP.net application will come in handy.
• Dare Obasanjo asked a thought-provoking question: Does C# 3.0 Beat Dynamic Languages at their Own Game?
• Aaronontheweb made 8 Bold Predictions for Web 2.0 in 2008. One of the predictions is that Google will have its first failure in 2008. I thought Google Answers was it.
• If you are learning WCF, check out Michele Bustamante’s That Indigo Girl. Via Is This Thing On.
• If you have done or are planning to do automated GUI testing, check out Automated GUI testing - Is it worth it? by Mladen Prajdić.
• Bruce Eckel wrote about the The Mythical 5% of top developers and shared tips on how you can be part of that exclusive club.
• For Oracle developers, ODAC 11g has been released. Via Mark A Williams.
• If like me, you have heard about SubSonic but don’t know much about it, Kent Sharkey’s Introduction to SubSonic (Dotnetslackers) provides a quick primer.

Software And Tools

• Did you know that something called Robocopy (short for Robust File Copy, not Robot Copy), is the new XCOPY? It’s a standard tool in Windows Vista and is also available as part of the Windows Resource Kit. Via Don Box’s Spoutlet on Pluralsight.

  

• I recently tried and liked GhostDoc very much. It’s a free Visual Studio add-in to help write XML documentation comments. Roland Weigelt wrote a nice intro article on GhostDoc on DotnetSlackers here.
• SyncBackSE is a great folder synchronization utility. It has tons of features… maybe even a little bit on the bloated side. It costs $30 for a single license. If you just want something simple, Microsoft’s free SyncToy may do the trick for you.

   

Gadgets

• From CES, it looks like Blu-ray will be the winner of the HD format war. No, the war is not completely over, but this was the landing at Normandy… so to speak. The loss is just too great for the HD-DVD camp to recover.

And Now, Something Different

• Richmond’s Lunar New Year Festival is on Jan 27.

Did you know Microsoft Outlook has supported type-ahead since Outlook 2003?

I didn’t. I upgrade my home PC to Outlook 2007 a few days ago and was pleasantly surprised to find type-ahead working. I fired up the old copy of Outlook 2003 and type-ahead worked in that version too. I am pretty sure it didn’t work in versions prior to 2003.

Type-ahead is great for using with the Move to Folder or Copy to Folder features. If you use Outlook to get your Gmail via IMAP, you’ll appreciate the type-ahead feature since you need to move messages a lot.

To see type-ahead working, in the Move Items dialog box (with a message selected, press CTRL+SHIFT+V), type the first few letters of any folder name. The current folder selection will move to the folder that matches what you type.