Category Archives for "Intermediate"

Interview with Alessandro Alpi on Database Life Cycle Management

Database Life Cycle

I recently had the opportunity to interview Alessandro Alpi, a SQL Server MVP, regarding SQL and ALM (Application Life cycle Management).  In this interview we talk about the tool and importance of managing your code and static data with version control software such as Git.  In addition we talk about testing. All these topics struck […]

Continue reading

Use SQL Server to Sort Alphanumeric Values

Sort Alphanumeric Values with SQL Server Recently a reader asked me how to sort an alpha numeric field in SQL in natural order.  Alphanumeric values are commonly found and don’t sort naturally using numeric methods. When we have a numeric fields we expect values to be sorted in ordinal order, for example: 1,2,5,7,10,11,15,20,21 However when […]

Continue reading