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!
James is a highly acclaimed author renowned for his extensive experience in the realm of data development and architecture, offering valuable insights to the data industry through his compelling literary works. Residing in the charming city of Oxford, he embarked on an illustrious academic journey at Oxford University, where he delved into the intricate world of computer science. This foundation served as the catalyst for his exceptional career.
After completing his studies, James embarked on a professional path that led him to renowned technology giants. He first honed his skills as a data developer at Microsoft, where he showcased his prowess in designing and implementing robust data solutions. His innovative contributions played a pivotal role in enhancing data management processes, solidifying his reputation as a meticulous and forward-thinking professional.
Seeking new challenges and broader horizons, James embarked on a transformative journey at Amazon Web Services (AWS). In this influential position, he leveraged his profound understanding of data architecture to shape cutting-edge solutions for clients. His leadership and technical acumen enabled businesses to harness the power of cloud computing and revolutionize their data management practices, further solidifying his status as an industry authority.
