SQLCLR

SQLServerCentral Article

How to implement SHA-2 in SQL Server 2005 or 2008 with a CLR assembly

  • Article

SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.

4.82 (22)

You rated this post out of 5. Change rating

2013-10-07

6,241 reads

External Article

CLR Performance Testing

  • Article

Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.

2011-08-01

2,863 reads

Blogs

Measuring and Improving SQL Server Query Plan Cache Efficiency

By

Measuring and Improving SQL Server Query Plan Cache Efficiency The query...

Communicate to the Individual

By

I may think I'm trying to reach the crowd, but I'm really trying to...

Monday Monitor Tips: Searching Permission Changes

By

During a demo of Redgate Monitor Enterprise to a customer, they asked about how...

Read the latest Blogs

Forums

The Technical Debt Anchor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Technical Debt Anchor

Getting the Updated Column List

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Updated Column List

SSRS: An error occurred during local report processing. The definition of ...

By sgmunson

Here's the complete error: An error occurred during local report processing. The definition of...

Visit the forum

Question of the Day

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()

See possible answers