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
4,620 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
8,681 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,336 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
12,968 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
9,343 reads
Blogs
Last Week Reading (2020-07-12)
By Kamil
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....
Daily Coping 10 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 9 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Creating a Dimension with no Primary Key
Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and...
Code signing a dll with certificate for use in SQL Server 2016
I have a dll that will perform some webservice calls function. in order to...
Find whether a clustered index is actually unique
Hi I have a table that has a clustered index on it The...
Ask SSC