Next Meeting: Fri, Apr 28 2017
NashSQL April Meeting: Louis Davidson
Event Type: In-Person
Online Meeting URL: None
TEKsystems is the nation’s leading IT staffing and services firm. Here in Nashville we support over 80 different clients within Applications Services. We focus on delivering consistent employment opportunities, continual communication throughout contracts, and advancing consultant careers through contract opportunities as well as direct hire roles. We build a recruiting force committed to building relationships with IT professionals here in Nashville and offer opportunities both locally and nationally. Here at TEKsystems Nashville we look to serve our professionals with consistent communication, strategic partnership, and career advancement. We are grateful to have the opportunity to partner with the IT professional community and are always looking to improve our relationships and partnerships.
UTC : Fri, Apr 28 2017 16:30 - 18:00
Event Time : Fri, Apr 28 2017 11:30 - 13:00 Central Daylight Time
Your Local Time: Fri, Apr 28 2017 16:30 - 18:00
8 City Blvd
A Survey of New T-SQL Features in SQL Server 2016 (Sp1)
Louis Davidson, Data Architect drsql.org
Last year, Robert Verell gave a presentation to the group on 2016 features where he gave examples of the new features in SQL Server 2016 at the product level. Our promise then was to give deeper dive sessions on the features, so this presentation is demo filled on the T-SQL features that are new for 2016. The features covered will include:
Temporal Tables - The new table structures and syntax that let you capture history of all changes to a table, allowing you to query the table as it existed at a certain point in time in a very straightforward manner.
Row Level Security - A mechanism to filter a user's access to data at the row level, in a manner that your code (stored procedures and views included) will honor with no changes to your existing code.
Data Masking - Lets you define a pattern to mask a column's output in your T-SQL statements to obfuscate sensitive data.
JSON - Allows you to format the output of a query as a JSON document (much like the FOR XML clause does for XML).
New Syntax and Commands - Even if you don't use any of these new features in your coding, I will also show a selection of new functions and syntax constructs that you will definitely want to know about.
Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 10 years and has written five books on database design. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.