If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

CLR functions that perform string manipulation and substring extraction perform very well in SQL Server. By Joe Kunk; 10/11/2011; Recently I encountered a problem in a stored procedure that was caused ...

PowerShell has a data type called an enum, which is a way to set a variable for a number of predefined constants. There are many useful features of enums in PowerShell, but the one that I've found I ...