THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql » SQL CLR   (RSS)
  • Find a Hash Collision, Win $100

    Margarity Kerns recently published a very nice article at SQL Server Central on using hash functions to detect changes in rows during the data warehouse load ETL process.  On the discussion page for the article I noticed a lot of the same old arguments against using hash functions to detect change.  After having this same discussion ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 17, 2010
  • Mission Accomplished: NJSQL Saturday Event

    Thanks to all those who made the NJSQL Saturday event held in Iselin, NJ today a success! Those lucky enough to attend were given a sneak preview of one of the best young presenters out there--MVP Jacob Sebastian--who will also be speaking at PASS.  I have to hand it to Jacob: he gave one of the best presentations on a SQL Server topic ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on October 24, 2009
  • Let's Hash a BLOB

    In my last post I talked about how to work around a couple of the limitations of SQL Server encryption by using SQL CLR and the .NET Framework to encrypt a BLOB value (up to 2.1 GB in size), using any supported algorithm you choose. In the example I used AES to encrypt data using a passphrase. SQL Server 2008 also allows you to generate ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 12, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement