I'm planning my first EDW using DV2. The immediate goal is to load data from several MS SQL 2014 banking applications, and much later Mongo. My client has selected MS SQL 2017 / perhaps 2019 for the EDW.
According to MS books online, MD5 and SHA1 have been deprecated as at SQL 2016. MS now only supports SHA256 and SHA512 on the SQL platform for the HASHBYTES() function. Also, I read Mongo may be changing its MD5 hashing.
What should I use for hashing?