The original version of this code comes from here. That version, however, didn’t handle NULLs and just inserted empty strings or zeros. In the comments there was an updated version by spider_pat that supported NULL values but had a couple of problems, namely it only had one column to INSERT…
Tag: T-SQL
SQL Server Encryption Overview
I was doing some work that required that some parts of the database were encrypted and couldn’t find an all-in-one location for information. If that’s what you’re looking for, this ain’t it either. I will, however, briefly explain how to create symmetric and asymmetric keys that use passwords. First off,…
SQL Server 2008 Express Asymmetric Encryption
First off, if you’ve got SQL Server 2008 Enterprise Edition I’d recommend that you look at TDE. SQL Server 2008 Express Edition doesn’t support TDE so instead we need to find another way to encrypt our data. The method that I’m talking about here is asymmetric encryption using a password…
Make sure your SQL queries are using the proper index
I’ve got a live table with 98 million rows that I’m normalizing. Unforuntately all full batch updates tend to lock the system for a very long so I wrote a VB.Net program to perform updates in smaller batches. The program pulls 10,000 records that haven’t been updated by using the…