Good to see your book is in O'Reiley, Grant! I will have to give it a read. Hard to find good DB books here in Norway in English...

Pluralsight offers (or did when I joined) a free 30 days for video trial courses....they just bought another company (forget the name) and there are now more for the "Pro"...

I would recommend, among other free sites like here, that you pay for good training ones like pluralsight and O'Reiley books on-line. I saw, for example, they have over...

The best backups are not stored on the same...

Call me greedy, but I work somewhat as a DBA, DB developer and VB programmer for our finance department. Not that I am an expert at any but know...

Have you looked into TDE: http://www.infotechguyz.com/SQLServer2012/TransparentEncryptioninSQLServer2012.html

from BOL: "GO is not a Transact-SQL statement; it is a command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code editor."

That is nice!!!!

Yup, you nailed it hunchback .... the previous sheets I got did not have any nulls and I forgot that....just found out they only need this task to be done...

Ah!! Right...and since we have so few nulls I didn't think of that...for now, I might just take the easy way out as I get the files in Excel...

Actually they have helped but I think the new solution (basically creating a list in C# or a temp table) and populating it with all "version 1" data (or whatever...