IsNumericEx UDF - Data type aware
The built-in SQL Server ISNUMERIC() function determines if character expression can be converted to one of the numeric types. The ufn_IsNumericEx() function accepts the second parameter - the data type to convert to and checks also for characters illegal for that data type. It doesn't check if the numeric value is in the range for specified data type though.
How does SQL Server Management Studio move columns?
SSMS (SQL Server Management Studio) does not use any kind of wizardry as one might think. It creates a new table, moves the data, drops the original table and renames the new table to the original name.
View log usage in SQL2005 using Dynamic Management objects
SQL Server 2005 introduces a number of Dynamic Management objects. One of these is dm_os_performance_counters which gives you access to SQL Server Performance Counters that were only available through Performance Monitor. Several of the counters are related to the log so we can see the log usage for databases from within SQL Server.
Variable column widths, string lengths in printf-style functions
I have been programming in C for quite some time, but until recently I was not aware that you could specify column widths and string limits using variables. I have neither seen this functionality used in any projects until I started working with OpenSER.
Strextract UDF - Retrieves String Between Two Delimiters
The ufn_StrExtract() UDF for SQL Server is similar to the VFP StrExtract() function.
Proper UDF - Capitalize String as Proper Names
The ufn_Proper() UDF for SQL Server is similar to the VFP Proper() function. It additionally allows to specify a set of delimiters.
Alines UDF - String Split
The ufn_Alines() UDF for SQL Server is similar to the VFP Alines() function but w/o additional parameters.
Tomcat 4.1 and JSP taglibs
I just spent over an hour trying to figure out why I kept getting:
org.apache.jasper.JasperException: This absolute uri (http://java.sun.com/jstl/core) cannot be resolved in either web.xml or the jar files deployed with this application.