SQLServerCentral - Guest Columnist: Bret Lowery

TSQL function to detect SQL Agent job state

This article has a T-SQL function to detect the SQL Agent job state. Read more...

By Bret Lowery 2012/02/07 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 8,196 reads

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing Read more...

By Bret Lowery 2012/02/20 | Source: SQLServerCentral.com | Category: sqlclr

Rating:

|

Discuss |

Briefcase | 4,011 reads

URI Parser: A set of 20 CLR functions for URI parsing

A set of 20 functions for URI and URL parsing, using .NET's native System.Uri parser Read more...

By Bret Lowery 2011/07/21 | Source: SQLServerCentral.com | Category: sqlclr

Rating:

|

Discuss |

Briefcase | 1,210 reads

XLSExport: A CLR procedure to export proc results to Excel

A CLR procedure utilizing the NPOI library to export the results of a passed stored procedure to an Excel spreadsheet. Read more...

By Bret Lowery 2011/06/23 | Source: SQLServerCentral.com | Category: sqlclr

Rating:

|

Discuss |

Briefcase | 8,488 reads

JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server

One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics. Read more...

By Bret Lowery 2011/07/18 | Source: SQLServerCentral.com | Category: sqlclr

Rating:

|

Discuss |

Briefcase | 6,518 reads