Skip to Content

And they say you can’t go home again.. On the 28th of April I will be returning back to my old home of Nashville to speak at the Nashville SQL Server User’s Group. (And where I moved to was very near the home I lived in when I was in high school.)

The session I will be doing is a one off session of demos of some of the new T-SQL features that are in SQL Server 2016 SP1, using code that I have culled from the blogs I have done here on Temporal, Row Level Security, Dynamic Data Masking, and a few queries to demonstrate JSON and some of the other new features like CREATE OR ALTER, DROP … IF EXISTS, etc.

Here is the abstract:

A Survey of New T-SQL Features in SQL Server 2016 (SP1)

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.

Leave a Comment