Creating a Formatted HTML Table for Email with T-SQL

We haven’t talked tech in a while on our blog but since a good percentage of our readers consists of programmers and database administrators, we feel the need to sneak in an article or two every once in a while. … Read More

Are scalar User-Defined Functions Ever a Good Idea?

Are scalar User-Defined Functions Ever a Good Idea? In SQL Server, you have the ability to create a user-defined function that can perform an operation directly inline as a part of a query. For example, consider an ordering system, which … Read More