Government Mandates and Programming Languages

A recent SEC proposal (which, at over 600 pages, I haven’t read in any detail) includes the following: “We are proposing to require the filing of a computer program (the “waterfall computer program,” as defined in the proposed rule) of the contractual cash flow provisions of the securities in the form of downloadable source code […]

Detect Unicode Usage in SQL Column

One optimization you can make to a SQL table that is overly large is to change from nvarchar (or nchar) to varchar (or char).  Doing so will cut the size used by the data in half, from 2 bytes per character (+ 2 bytes of overhead for varchar) to only 1 byte per character.  However, […]

Sql Table Refactoring Challenge

I’ve been working a bit on cleaning up a large table to make it more efficient.  I pretty much know what I need to do at this point, but I figured I’d offer up a challenge for my readers, to see if they can catch everything I have as well as to see if I’ve […]

Determine All SQL Server Table Sizes

I’m doing some work to migrate and optimize a large-ish (40GB) SQL Server database at the moment.  Moving such a database between data centers over the Internet is not without its challenges.  In my case, virtually all of the size of the database is the result of one table, which has over 200M rows of […]

PowerShell Control over Nikon D3000 Camera

My wife got me a Nikon D3000 camera for Christmas last year, and I’m loving it but still trying to wrap my head around some of its features.  For instance, when you plug it into a computer via USB, it doesn’t show up as a drive like most cameras I’ve used to, but rather it […]

Clone a VirtualBox Machine

I just installed VirtualBox, which I want to try out based on recommendations from peers for running a server from within my Windows 7 x64 OS.  I’ve never used VirtualBox, so I’m certainly no expert at it, but I did want to share my experience with it thus far.  Specifically, my intention is to create […]

VS2010 Launch Presentations

Last week I was in Vegas to present at the DevConnections / VS2010 Launch event. The show was well-attended and everybody I spoke to agreed it was educational and enjoyable. My three talks were all on Wednesday, 14 April 2010, including one at 8am for which I was impressed to see a large turnout in […]

Adding Attributes to Generated Classes

ASP.NET MVC 2 adds support for data annotations, implemented via attributes on your model classes.  Depending on your design, you may be using an OR/M tool like Entity Framework or LINQ-to-SQL to generate your entity classes, and you may further be using these entities directly as your Model.  This is fairly common, and alleviates the […]