February 26, 2014 at 10:13 am
Wondering if there are some general security or HIPAA related reasons why I would want to upgrade to Microsoft SQL Server 2012 from 2008.
Thanks for your time.
S
February 26, 2014 at 10:34 am
If you are planning to use \already using SQL Server Auditing, then definitely you should consider upgrading to SQL Server 2012. There are some good improvements both in Security and Auditing too ..
Check them here
--
SQLBuddy
February 26, 2014 at 10:55 am
There is stronger encryption, but you can implement better algorithms using the CLR, so that might not be a reason.
Overall, I'm not sure there are compelling reasons outside of Audit, which was enhanced.
February 26, 2014 at 11:00 am
Stronger encryption?
February 26, 2014 at 11:08 am
Certificate length increased, hashing algorithms improved. I don't think the Symmetric algorithms changed, and it looks like the asymmetric ones are the same.
February 26, 2014 at 11:10 am
Excellent. I have not found that anywhere in the MS documentation.
Non-urgent ask: If you come across that could you share the link? Thanks again for your help Steve!
February 26, 2014 at 11:23 am
No good links.
If you look here: http://msdn.microsoft.com/en-us/library/ms187798%28v=sql.100%29.aspx
and here: http://msdn.microsoft.com/en-us/library/ms187798%28v=sql.110%29.aspx
you'll see length differences.
Same for Hashbytes in BOL. I'm surprised they didn't add this to the "What's New", but it's a big product.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply