Mass Transit Railway (MTR) is the the main mass transit system used in Hong Kong, operated by the MTR Corporation.

I was tasked with helping to setup our Spread cloud email marketing platform to be used on-premise, to allow them to send emails to their users. My duties were to upgrade the database and website to use SQL Server's Always Encrypted feature. I performed the following tasks:

• Setup SQL Server database to use Always Encrypted
• Testing all existing web pages to find which needed to be updated to support Always Encrypted
• Updating all SQL queries/Stored Procedures in order to support Always Encrypted (including noting which queries needed to be deprected, such as queries using the LIKE operator, as this type of search cannot be performed on encrypted data)
• Updating any webpages, including removal of deprecated features (such as certain searches which would translate into an SQL query), to ensure proper functionality with Always Encrypted
• Compiling the website & updating the test and staging environments