FogBugz is a great web-based project management and bug tracking application that we use to keep track of our customer's projects.  I'm often suprised by the quality and modern feel of this app, despite running in classic ASP*.  So I was pleasantly suprised again when I found they'd come out with an API and Visual Studio 2005 Plugin.  Installation was simple, and the result is a very Team System-ey integration between our helpdesk and development environment. 

*As a side note, it's actually written in a proprietary language, Wasabi, which has driven some to (perhaps rightly) question the owner.

Here's one feature of ASP.NET 2.0 you may not have heard of- I certainly hadn't until it hit the blogs again recently.  If you drop a file named app_offline.htm in your web application's root folder, then all requests to that application will only return that file.  

Very handy for scheduled downtime, bringing down your app for updates, etc.  Scott Guthrie mentions the trick here, as well as a minor issue to be aware of when designing your app_offline page.

One novel way to implement this is to integrate it into your deployment process.  For example, a simple batch file like this:

copy C:\MyCompany\app_offline_updating.htm C:\InetPub\wwwroot\Demo\ProjectName\app_offline.htm /y

xcopy C:\MyCompany\ProjectName*.* C:\InetPub\wwwroot\Clients\Demo\ProjectName\ /s /q /y

del C:\InetPub\wwwroot\Clients\Demo\ProjectName\app_offline.htm

The batch file can be run manually, or even better- as part of your continuous integration process.  With a little javascript or meta-tag to do automatic refreshes, this is a great way to avoid errors and communicate downtime to users.

If you're not familiar with Cruise Control .NET, it's a continuous integration server for .NET projects.  What's a continuous integration server?  Well, think of it as a free developer.  It's job description is not enviable:

• Wait for new code to be checked in by the other developers and make sure it can be compiled.
• Check the code for best practices.
• Run unit tests to make sure nothing is broken.
• Perform any last minute tasks
• Notify team members of the latest changes.
• Alert the appropriate people if something fails.

If you think about it, this is really a fitting analogy.  FXCop ensures your code conforms to a large chunk of MS Patterns & Practices.  With NUnit, you write tests to check some part of your code.  This is the same as asking another developer to double-check everything for you.  Finally, MSBuild and CC.NET tasks pick up a ton of other tedious tasks such as deploying a setup package, notifying people of changes, updating the company website, etc.

What this means is that the real developers can focus on the fun stuff: writing code, while "the new guy" does the grunt work.

I'm posting this mostly because I know I'll forget, but hopefully it'll come in handy for others as well.  One tricky problem in programming is to search by date range against data that also has a date range.  Sounds simple, but this can quickly get confusing.  You must take into account the start and end date of the search criteria, as well as the start and end date of the data.  You must also consider cases where the start date is in the given range, but the end date is not, or visa-versa.  Then there are cases where neither are in the search range.  See, confusing. (Ryan Farley has a good illustration of it all, and is where I finally found my answer)

It helped me to think of it in terms of a timeline, and the search as simply finding the records where the search range intersects with the record range.  As one of the commenters on the above post pointed out, it's easier to exclude the records that don't match. In a SQL, it'd look something like this:

SELECT * FROM Reservations WHERE (NOT((ReservationEnd < @StartDate) or (ReservationStart > @EndDate)))

In plain english: Get the records where the reservation does not end before the start date, or start after the end date.

One other gotcha.  Be sure, when passing the start and end dates into your SQL query from .NET, that you're considering time as well.  Typically, you'll want to search from 12AM to 11:59PM:

Dim startDate As DateTime = New DateTime(CurrentDate.Year, CurrentDate.Month, 1, 0, 0, 0)
Dim endDate As DateTime = New DateTime(CurrentDate.Year, CurrentDate.Month, DateTime.DaysInMonth(startDate.Year, startDate.Month), 23, 59, 59)

This is something I downloaded a while back, and use sporadically, but every time I do, I'm amazed.  In a single right-click menu it gives you access to just about any tool a good web developer needs when browsing their app.  Turn off styles/javascript/cache/images/etc for testing.  Switch CSS Media types, edit css on-the-fly.  Outline divs, tables, links, etc.  Validate using a variety of tools- even localhost sites.   The one humble menu item that spurred me to post this, though, is 'Resize To... 800x600'.  Perfect for testing your app on that ginormus monitor.

http://chrispederick.com/work/webdeveloper/

It'll be pushed down in Windows Update on Nov. 1, but IE 7 is out of beta now, and can be downloaded here:

http://www.microsoft.com/windows/ie/default.mspx

It'll be interesting to see who switches back and who stays with FireFox.  The main factors for my switch to FF were tabbed browsing and RSS, both of which have been added. 

I was reminded again today how freaking awesome ClickOnce is.  Awesome to the developer, because you run a little wizard and get a deployment package, installation page,  and auto-update (and rollback) functionality.  Awesome for the user because you click a button to install an app, (maybe another to grant it permissions), and get notified whenever it updates.

To bad it doesn't work natively with FireFox.  Fortunately there's a plugin for it until Microsoft gets it working.  The first article also mentions a workaround you can use on your installation page.

There's a ton of free content on MSDN and elsewhere, but these professional courses usually cost about $50 each, and cover a specific task or topic in-depth.  Enjoy!