Snipplr - Scooter

(VB.NET) Force SSL

Wed, 21 Sep 2011 03:15:28 GMT

The technique that I had used for years in classic ASP didn't seem to work reliably in ASP.NET, so I switched to this based on articles on various blogs. Request and Response are fully qualified because I had trouble getting System.Web.HttpContext.Current to import in App_Code. Place the function in an App_Code library, import the library on your page, and call ForceSSL() at the top of Page_Load().

(Windows Registry) Change Excel macro security to medium

Sat, 06 Aug 2011 06:36:41 GMT

The below is for Excel 2003, but you can probably target Office 2007 or 2010 by changing the version to 12.0 or 13.0 respectively. At the company where I am currently working, Excel addins are used extensively by various departments. By default, Excel has macro security set to high, but some users are too dumb to read the message that tells them to change the macro security to medium, so I've added the following to our collection of registry tweaks applied during logon to take care of this automatically.

(Windows Registry) Symantec Antivirus Corporate Edition security settings

Sat, 06 Aug 2011 06:33:03 GMT

When you install Symantec Antivirus Corporate Edition, the default settings are not very secure. The following registry script will increase the security settings to a more reasonable level. This is for version 10; I suspect the settings for version 11 and 12 are stored in a similar registry location, and finding the location was the hardest part.

(SQL) Rename SQL Server Instance

Fri, 27 May 2011 01:05:17 GMT

When upgrading your SQL Server, it can sometimes be easier to rename the new server to match the old server rather than update all the workstations to point to the new server. The name of the SQL Server instance also needs to be changed. The following script will take care of this, but the last part which updates the SQL Agent jobs only works against the master server in a multi-server environment. If you're upgrading your master server, or your only server, it will work fine.

(VB.NET) Temperature Class

Wed, 11 May 2011 09:31:48 GMT

This class is intended to reside within the app_code folder in your ASP.NET web site. It facilitates the storage and conversion of temperature values. See the linked blog post for usage example.

(Windows Registry) Increase maximum signature length in Outlook Web Access

Thu, 06 Jan 2011 03:31:02 GMT

When editing your signature in Outlook Web Access, you may have seen this error message: > Your signature exceeds the maximum size allowed. > Please reduce its length or formatting before attempting to save again. This registry tweak will increase the maximum signature length from the default 4 KB to 16 KB. Feel free to change this to a lower number if you prefer, but 16 KB is apparently the maximum possible. This registry tweak needs to be applied on the Exchange server itself.

(ASP) Calculate monthly and/or annual salary

Sat, 11 Sep 2010 06:22:51 GMT

Requires my [WorkingDays](http://snipplr.com/view/39873/number-of-working-days-in-a-month/) function.

(VB.NET) Add and strip slashes

Sat, 11 Sep 2010 06:16:59 GMT

VB.NET implementation on the PHP functions by the same name, but with support for more problematic characters.

(ASP) Number of working days in a month

Thu, 02 Sep 2010 07:52:25 GMT

Returns the number of working days in a month. Does not take holidays into consideration. I needed this function for the purposes of calculating employee annual salary, and holidays are paid days anyway. Requires my [MonthDays](http://snipplr.com/view/5390/number-of-days-in-a-month/) and [isLeapYear](http://snipplr.com/view/5388/check-if-a-year-is-a-leap-year/) functions.

(SQL) Get the current date without the time in SQL Server

Mon, 15 Feb 2010 11:49:18 GMT

Quite often I need to select all records in a table where the date is equal to today. The GETDATE() function in Transact-SQL returns the date and the time. The time vlaue can be stripped off by subtracting each part (hour, minute, second, millisecond).

(DOS Batch) Get list of drive letters and labels

Fri, 04 Sep 2009 17:12:22 GMT

Someone on Serverfault was asking for a Batch script to get a list of drive letters and their associated labels on a windows system. This is my suggested answer.

(ASP) Dynamic Array Class

Sat, 30 May 2009 20:37:52 GMT

I want to do a little more work on this, but as far as I know everything should be working fine.

(ASP) Prime Numbers

Sat, 23 May 2009 11:17:50 GMT

A library of functions related to prime numbers.

(PHP) Chemistry Library

Sat, 16 May 2009 12:53:49 GMT

A collection of chemistry-related functions: lookup element symbol by atomic number, lookup element name by atomic number, determine electron configuration by atomic number. Requires my [proper case function](http://snipplr.com/view/6325/proper-case/)

(ASP) Chemistry Library

Sat, 16 May 2009 12:53:03 GMT

(PHP) Fuel consumption

Sat, 09 May 2009 11:00:43 GMT

(ASP) Fuel consumption

Sat, 09 May 2009 11:00:22 GMT

(ASP) Regular Expressions

Sat, 02 May 2009 11:23:40 GMT

(PHP) Social Insurance Numbers

Sat, 25 Apr 2009 12:25:22 GMT

Functions for formatting and validating Social Insurance Numbers. Requires [luhn()](http://snipplr.com/view/12893/luhn-algorithm/).

(ASP) Social Insurance Numbers

Sat, 25 Apr 2009 12:24:42 GMT

Functions for formatting and validating Social Insurance Numbers. Requires [luhn()](http://snipplr.com/view/12892/luhn-algorithm/).