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,864 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,829 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,363 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
14,227 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,620 reads
Blogs
Altering a Computed Column in a Temporal Table in Azure SQL
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...
Basic OFFSET–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Calgary Data User Group with Deborah Melkin and Andy Yun
Next week on Wednesday is the Calgary Data User Group’s second event for 2021,...
Forums
SQL2016 to Access2016 Linked server issue
Hi all We've got an issue with a linked server to an Access...
Future of SQL Server
I am becoming a little disconcerted by the lack of news about the next...
Changing Data Drive Allocation Unit Size on Existing Installation
I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup...
Ask SSC