Speaker – Devin Jaiswal (view bio)
Session – Data Encryption
- Dynamic Data Masking – Limit exposure of sensitive data by masking it to non-privileged users
- Row Level Security – Keep multi-tenant databases secure from unauthorized access by other users who share the same tables
- Always Encrypted – Client-side encryption of sensitive data using keys that are never revealed to the database system
- Encryption-at-rest (TDE) Server-side encryption of the database content on physical storage, protecting against offline media attacks
Speaker – David Stokes (view bio)
Abstract – Tools to Manage and Administer SQL Server (When you don’t have any $$$$)
SQL Server includes some pretty powerful and useful features for DBAs. In this session we will look briefly at some of those tools from Microsoft. However, the primary focus will be on those tools, reports and scripts that have been generously developed and donated to the SQL Server community…FOR FREE. Take heart the next time your manager says “that’s not in the budget”. We will briefly look at some of the functionality of these “freebies, some well know and others that are hidden gems.
Speaker – Carlos Chacon (view bio)
Session –Disaster Recovery From on Premises to Azure
Everyone says they have a disaster recovery plan; however, has that plan been tested? Planning for recovery by using the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure. We will focus on the IAAS offerings with an eye on SQL Server.
Speaker – Tim Radney (view bio)
Session – Common SQL Server Mistakes and How to Avoid Them
Making mistakes is natural, but learning from them and avoiding them in future takes effort. There’s no substitute for experience or the shared wisdom of others to help you learn what mistakes to avoid. In this session, Tim will share with you a ton of what he’s learned over the years from working and consulting at multiple Fortune-level companies. You’ll hear about real-world environments he has worked on where there was a high impact from administrators making mistakes in how SQL Server was configured and administered. You’ll learn many proven and accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smoothly as possible and you’ll leave with a checklist of items to take home to make sure your SQL Server environment is configured properly.
UPDATE – Tim’s presentation of this session to the DBA Fundamentals virtual chapter can be viewed on line here