This month’s T-SQL Tuesday topic was about Encryption and since August tends to be a busy month, at least for me, I was not all that shocked when the participation was a little light. Never fear, the participation may have been light but the quality of the posts were far from it.
- Rob Farley (@rob_farley) graced us with two post the first discussed the differences between TDE and the new SQL Server 2016 feature Always Encrypted and the second showed us that you could still access data in dropped tables if TDE is turned on using the DBCC PAGE command.
- Kenneth Fisher (@sqlstudent144) wrote about our awesome first names and how to recover from a forgotten database master key.
- Jason Brimhall (@SQLRNNR) discussed how we can now, with SQL Server 2014, compress our encrypted data.
- Steve Jones (@wayOutwest) talked about the importance of data type casting when you encrypt and decrypt data.
- Aaron Bertrand (@AaronBertrand) also provided two posts, the first discussed the limitations of Always Encrypted and the second explored it’s performance impact.
- Jens Vestergaard (@vestergaardj) discussed encryption key management in Reporting Services.
Thanks to all those who participated in this month’s T-SQL Tuesday! If you are reading and wondering how you can participate in the party, then be on the look out for next months topic by following the hashtag #tsql2sday on twitter.
Thank you all for allowing me to be your host and happy reading!