Webinar Followup: End to End Security with SQL Server 2016
Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Saint Augustine, FL. Bradley is a former consultant, trainer, and has coauthored 6 SQL Server and Power BI books, most recently Learn Microsoft Fabric. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. Bradley gives back to the community through speaking at events such as the SQLBits, Fabric Community Conference, PASS Community Data Summit, SQL Saturdays, Code Camps, and user groups across the country including locally at the Jacksonville SQL Server User Group (JSSUG). He is a contributor on SQLServerCentral.com and blogs on his personal site, BradleySchacht.com.
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can click here to watch the recording of the webinar if you missed it. In this follow up I wanted to post the scripts I used and link to a few resources. Here is a link to the scripts/deck from my presentation: End to End Security with SQL Server 2016 Here is a link to the recording of the session (free to view): http://pragmaticworks.com/Training/Details/End-to-End-Security-with-SQL-Server-2016 I cannot take credit for the scripts and demos for everything that I used. As mentioned in the webinar a portion of the content was derived from a blog post that Jamey Johnston did and can be found here: http://blog.jameyjohnston.com/oil-gas-sql-server-security-demo/ He did an awesome job creating a end to end demo of masking, RLS and Always Encrypted along with a pretty cool data set. My session wasn’t solely objects from his blog post but I did use some pieces and want to make sure he gets credit for the work!
