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

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

10 Responses

  1. Ali says:

    Hi Bradely, thanks for the free training. Can you recommend same training but for Mysql?

    • 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.

  2. Mike says:

    How do I view Column Level Encrypted values decrypted in SSMS?

    • 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.

  3. Chase says:

    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.

  4. Avinash Pandey says:

    HI Brad,

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

    Thanks again.

  5. Yeneneh Abebe says:

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

Leave a Reply