Registration Link:- https://cincypass.pass.org/?EventID=15596
On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks.
Matt Gordon, Architect Insight Digital Innovation
Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
First released in SQL 2016 with many restrictions, SQL 2019 greatly enhances Always Encrypted. It is a complex feature with no shortage of subtle gotchas, and this session will reveal many of them.
Should Always Encrypted be used instead of TDE? What’s an “enclave”, and what are the requirements for using one? Are there any storage or performance implications when deploying Always Encrypted?
We’ll answer these questions and many more in this in-depth dialog, and you’ll gain a thorough understanding of what to consider when deploying Always Encrypted with secure enclaves in SQL 2019.