Practical usage of SQLCLR: Building QueryToHtml function

This article shows a few techniques with SQLCLR to to transform a query result into HTML.

Testing Simple Calculations and UDFs with tSQLt

This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.

How long do they last?

Reporting Services 2008/R2 Administration

Questions specific to SSRS 2008

SQL Server user defined function to convert MSDB integer value to time value

In a recent tip I outlined a process for converting a date, stored as an integer into a datetime data type. Date and time information for run history of SQL Server Agent jobs is stored within the msdb..sysjobshistory table as an integer data type, not as a datetime as one would expect. As promised, this tip picks up where we left off. On converting the integer-typed run_time into a format that is more user friendly for presentation purposes.

SQL Server UDF to pad a string

Unlike other relational database management systems that shall remain nameless, SQL Server's underlying coding language, T/SQL, does not have a built-in function for padding string values. I recently took it upon myself to create my own and as you'll see I got a little carried away

Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...

TSQL

SQL Server UDF to convert integer date to datetime format

This short tip shows how you can convert an integer date, such as those stored in msdb to a real datetime value.

Using schema binding to improve SQL Server UDF performance

SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.