Here’s a decent article on calculating the age of a person (or anything else) written by Lynn Pettis. Discusses some pitfalls with leap years.
Using and Managing SQL Server Aliases
I know that not many people I have met in my SQL Server experience have used SQL Aliases. In many ways it is one of the most useful features of SQL Server. Roman Rehak wrote a great article about SQL Server Aliases. You have to be registered to see the full article, but some of the highlights are discussed below. … Read More
Great Script for Accessing IIS Configuration Properties
Need to extract information from IIS such as IP Addresses, Host Headers, Log Directories and lots more. This great little script from David Wang does a great job of this. It saved me hours and hours of work going through all my IIS servers manually. Thanks David!
Useful way to reformat an ASP.NET File Upload control
The guys over at QuirksMode.org have come up with an interesting way to get around the default styling of a File Upload control See the details here: http://www.quirksmode.org/dom/inputfile.html
So what do you do with all those IIS log files?
You are responsible for one or more Windows web servers and you have all these IIS log files that you want to make some sense out of. If you have some basic SQL skills Microsoft is making available a utility called LogParser which does a great job getting in there and allowing you to query the files directly using some … Read More
Outlook 2007 Preview Pane made useful…
I finally had upgraded to Outlook 2007 about a month ago and one of the features I found myself using a lot was the Preview feature for attachments. It was great for the PDF and the typical office documents, but there were no preview handlers for files such as WAV. I have a VOIP line that emails me the voice … Read More
Command Line FTP Client with PASV support
I ran into a problem scheduling the transfer of a file via FTP today. The server was behind a firewall that required me to use PASV FTP support. Unfortunately the command line version of FTP that comes with Windows 2003 was not able to support this configuration (at least I could not figure out how to make it support it). … Read More
Easy method to download a portion of a web site
I have this client that posted several hundred files on their internal web site that I needed to download to my laptop for testing purposes. I started downloading them one by one and thought that there must be a better way without installing some big application to do this. With a little Google searching I found a great open source … Read More
Helping block spam with T-SQL
Found a great article on blocking spam using T-SQL code. It is especially useful for blog posts and other community related sites that accept user input. Could even be used on form comments to help block all those guys that submit endless forms on your sites.
Oops… Forgot to add the attachment to your email?
You know you have done it before. The second you hit send you realized you forgot to attach the all important photo, spreadsheet or document. Here is a way to delay the sending of the email so you can grab it before it goes out to everyone you sent it to. We are going to assume you are using Outlook, … Read More