Upcoming Presentation: End to End Security with SQL Server 2016

Each week Pragmatic Works hosts a free training session. The topics include SQL Server internals, Business Intelligence, cloud services and even big data. On Tuesday May 2nd, 2017 I will be presenting the free training session on SQL Server 2016 security. Check out the details below. Hope to see you there.

Topic: End-to-End Security with SQL Server 2016
Abstract: It only takes one data breach to lose trust and credibility with your customers. While previous versions of SQL Server have been very secure, SQL Server 2016 has added some major security features. From built-in row-level security to dynamic data masking to ensuring data is always encrypted at rest, in flight and in the application, this is the most secure release of SQL Server ever! In this session, you will learn how to leverage these new features independently for specific-use cases or working together for solid end-to-end security. The best part of all these features is that they require minimal or no downstream application changes!
Registration link: http://pragmaticworks.com/Training/Details/End-to-End-Security-with-SQL-Server-2016

About the author

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

11 comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.

    • I don’t deal with MySQL except as the backend for my website since that’s what the WordPress templates use. It has a lot of similarities in the language syntax to what you see in T-SQL in SQL Server, so it’s easy enough for me to get around.

    • On the Additional Connection Parameters section of the connection dialog (accessible after clicking the Options button in the bottom right) add column encryption setting=enabled. You will need to make sure the certificate for the encrypted fields is available on your computer before connecting.

  • Bradley, your presentation yesterday was excellent and very helpful. I’m working on upgrading our SQL Server instances to 2016 and knowing some of the new security available is great. Looking forward to reviewing the slides from the presentation that will be made available on your site. Thanks for all your effort!

    • Thank you for joining! I’m glad you enjoyed it. Liz has the recording up and I will have a post out tomorrow morning at 9AM eastern with a link to the recording as well as the slide deck and sample code.

  • HI Brad,
    Thanks a lot for the presentation, it is very good. Could you please share the scripts used in the presentation.
    Thanks again.

  • Hi Bradely, thanks for the free training. Fantastic as usual. I was wondering where your scripts are?
    Thanks again.

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me