An Implementation of the FNV1a Hash Algorithm for SQL Server
Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing
2012-02-20
5,991 reads
Bret Lowery
TSQL function to detect SQL Agent job state
This article has a T-SQL function to detect the SQL Agent job state.
2012-02-07
9,600 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
2011-07-21
1,487 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.
2011-07-18
17,752 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.
2011-06-23
10,755 reads
Blogs
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Forums
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers