Frequently Asked Questions
For Data Vault Modeling, Methodology, Architecture and Implementation. I will do my best to answer questions here as they come up. Feel free to post NEW questions, please read the proper category descriptions to keep them in the right place.
Have a Question? Submit one HERE.
Data Vault Implementation
HashBytes and MD5 Deprecated in SQLServer 2016
I found this information in SQL Server 2016 documentation.
Beginning with SQL Server 2016, all algorithms other than SHA2_256, and SHA2_512 are deprecated. Older algorithms (not recommended) will continue working, but they will raise a deprecation event.
Would using this have a performance impact? Would you recommend using either of the supported algorithms as a DV standard?