Visual Studio 2010 COM object error

I randomly started getting a, “COM object that has been separated from its underlying RCW cannot be used” error when trying to view a project’s properties in Visual Studio 2010: This StackOverflow question seems to indicate that it could be caused by one of my add-ins. The first step was to disable add-ins and see if the problem resolves. Go to Tools -> Options. Then Environment -> Add-in / Macros security and uncheck “Allow Add-in components to load.

Creating Custom Cultures in .NET

Our application receives a culture name (e.g. en-US, de-DE, ja-JP) as user input and in response returns customized content. The problem is that there is a specific use case for Japanese (ja-JP) in which the content needs to be different than the other Japanese use cases. We want to leave all the other use cases alone. We have chosen to solve this is by creating a new culture to represent the this special case - CultureAndRegionInfoBuilder does exactly that.

F12 Developer tools disabled in IE8

For some reason I couldn’t pull the up the F12 Developer tools in IE8. The menu item was grayed out. Here’s how I got them back: Start up gpedit.msc Go to Computer Configuration -> Administrative Templates -> Windows Components -> Internet Explorer -> Toolbars Right click on Turn off Developer Tools -> Edit I set it Disabled. You could try enabling then disabling it if just disabling it doesn’t work.

Misc SQL Statistics Queries

View statistics for a table: <p> Each statistics shows when it was last updated and if no_recompute is on: </p> <p> <a href="http://i1.wp.com/www.joelbeckham.com/wp-content/uploads/2012/02/2012-02-09_111618.gif"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="2012-02-09_111618" border="0" alt="2012-02-09_111618" src="http://i2.wp.com/www.joelbeckham.com/wp-content/uploads/2012/02/2012-02-09_111618_thumb.gif?resize=416%2C42" data-recalc-dims="1" /></a> </p> <p> &#160; </p> <p> Database properties has a setting called "Auto Update Statistics": </p> <p> <a href="http://i2.wp.com/www.joelbeckham.com/wp-content/uploads/2012/02/2012-02-09_112136.gif"><img style="background-image: none; border-right-width: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="2012-02-09_112136" border="0" alt="2012-02-09_112136" src="http://i2.

GUID vs Int

Here’s an interesting insight to follow up on a discussion I had the other day about using GUIDs vs Ints as primary keys. The database I work on uses Int’s for its primary keys. The largest table has accumulated 14 million rows since inception (2005). At its current size, if we switched the primary keys to Guids, it would add about 1.2 GB to the database (taking into consideration the indexes as well as foreign key references).

I just noticed that at some point all of my page titles became blank and the tag in the markup was empty. The reason is because the tag wasn’t marked as a server-side tag for ASP.NET, so it didn’t have access to update the tag.