Bio: Jamie Wick is the Systems & Database Engineer for The College of William & Mary and has been working with databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Master’s degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is a volunteer & speaker at regional SQL events (User Groups/SQLSaturdays), helps run the Richmond SQL Server Users Group and SQLSaturday RVA events, and is an avid photographer.
Session Title: Automated SQL Server Installation and Configuration Using PowerShell
Abstract: Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of SQL Server (2016).
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.