Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag HASHBYTES Rss

   Items 1 to 7 of 7   
 

HASHBYTES

By twin devil 2014/01/21 | Category: hashbytes
Rating: (not yet rated) |  Discuss |   Briefcase | 1,560 reads

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

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.  Read more...
By Stan Kulp 2013/10/07 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 3,564 reads

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,749 reads

An in-depth look at change detection in SQL Server - Part 02

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...
By Nakul Vachhrajani 2013/02/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 6,023 reads

An in-depth look at change detection in SQL Server - Part 01

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.  Read more...
By Nakul Vachhrajani 2013/02/12 | Source: SQLServerCentral.com | Category: change detection
Rating: |  Discuss |   Briefcase | 2,905 reads

Hashing

By Steve Jones 2012/01/24 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,435 reads

HASHBYTES can help quickly load a Data Warehouse

Data warehouse loads can be time consuming - this method can be used in some instances to help speed things up.  Read more...
By Magarity Kerns 2010/04/14 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 13,397 reads
   Items 1 to 7 of 7   
 
Tags
t-sql (5)    
checksum (3)    
sql server (3)    
binary_checksum (2)    
change detection (2)    
conflict resolution (2)    
rowversion (2)    
assembly (1)    
data warehousing (1)    
encryption (1)    
hashes (1)    
hsa_256 (1)    
hsa_512 (1)    
indexes (1)    
security (1)    
sha-2 (1)    
sha-256 (1)    
sha-384 (1)    
sha-512 (1)    
sqlclr (1)