Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Bret Lowery

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

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,350 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,157 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,242 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,719 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 | 8,015 reads
   Items 1 to 5 of 5