Upgrading SQL Server with the least amount of downtime - Brecht Vuylsteke
Did you ever hear : “This SQL Server is critical and cannot be offline for an extended period of time” and thought to yourself, what if i could do an upgrade with a minimum of downtime?
If so, than this session might just be the thing for you. During the session I will demonstrate how critical SQL Servers can be migrated to the most recent version with a minimum of downtime (Spoiler alert, some downtime will be required)
During the session I’ll cover the following subjects:
- Why upgrade?
- Several ways to minimize downtime during a SQL migration.
- How does one perform such an upgrade with minimal downtime?
- Potential mistakes made during a SQL Server upgrade.
Hacking SQL Server - Thomas Vandezande
During my session I’ll attempt to provide you some insights to critically overthink security measures provided for SQL. This will provide you with the mindset to see flaws in security implementations and protect your own data.
Using this knowledge we’ll take a deeper look into SQL Transparant Data Encryption. We’ll dive into the architecture of TDE and determine if we can think of a way to make the implementation obsolete. Ie, can we find a way to decrypt the data on a remote machine? If so, how can we protect ourselves (and our data) from it?