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,790 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,769 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,357 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
13,939 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,500 reads
Blogs
2020 Advent of Code–Day 1
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Forums
How to find index usage by stored procedure?
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
Odd things with Report Builder (also tried VS 2019)
This is kinda hard to explain, maybe I can make sense of it. So...
PBM policy to check empty passwords
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...
Ask SSC