Web Site Offer for August

We are having a special deal for the month of August. Get a complete web site developed for your business for only $899 (regularly $1,299) This special deal includes all the following: Unique, fully customized template that will be unique to your business. Up to 5 Content Pages Blogging support Basic Search Engine Optimization Comprehensive content management system to allow … Read More

How to Setup LogMeIn Secondary Users

LogMeIn is a platform that we use internally for our own computers as well as all our clients. One of the most useful features of the LogMeIn offering is the ability to setup a secondary user to allow access to one or more computers in your account.  It is pretty easy to setup this feature. By creating Secondary Users in … Read More

Creating Insert Statements for SQL Server

Ran across an interesting approach to generating insert statements for SQL Server 2005 (and other variants).  If uses a less well known function called master.dbo.fn_varbintohexstr. The approach that was taken was to use the fn_varbintohexstr function to encode the data so you did not need to use cursors or any fancy parsing to handle unicode and quotes in the generated … Read More

Clearing Email History Lists in Outlook

One of the great features of Outlook (but also sometimes annoying) is that it remembers all the email addresses of the people that you send email to or receive email from.  This makes it really easy for composing emails except for when you get an email address that is spelled incorrectly in that list.  That can be extremely frustrating. Turns … Read More

ASP.NET AJAX Control Toolkit Samples

Most of you probably have already experimented with the Control Toolkit, but just in case you never ran across it, take a look at these Toolkit samples If you have any questions about them, drop me a comment here.

Calculating Age in T-SQL

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.

Resetting the IDENTITY counter in SQL Server T-SQL

You’ve been there before.  You are busily testing your import routines and running up the Identity column in your main import table.  Before you know it the value is in the multi-millions and you just want to reset it back to 1.  The way to accomplish this is to use the DBCC CHECKIDENT command. For example: DBCC CHECKIDENT (SalesForce, reseed, … 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