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

Database Performance Tips You Won’t Want To Miss

In a data-driven web application, poor database performance can needlessly burden your server or, worse, make your website slow enough that your user gives up and goes somewhere else. So we have put together some of the common pitfalls we … Read More