Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


NEW FEATURES IN SQL SERVER 2016 | Complete List

In this post we shall check out all the new features Microsoft introduced in SQL Server 2016

# New Feature URL
     
1 DROP IF EXISTS https://msbiskills.com/2018/01/06/new-t-sql-features-in-sql-server-2016-i/
2 STRING_SPLIT() https://msbiskills.com/2018/01/07/new-t-sql-features-in-sql-server-2016-ii-string_split/
3 CREATE OR ALTER https://msbiskills.com/2018/01/08/new-t-sql-features-in-sql-server-2016-iii-create-or-alter/
4 DBCC CLONEDATABASE(Service Pack 1) https://msbiskills.com/2018/01/08/new-t-sql-features-in-sql-server-2016-iv-dbcc-clonedatabase/
5 DATEDIFF_BIG() https://msbiskills.com/2018/01/09/new-t-sql-features-in-sql-server-2016-v-datediff_big/
6 STRING_ESCAPE() https://msbiskills.com/2018/01/09/new-t-sql-features-in-sql-server-2016-vi-string_escape/
7 USE HINT query hint argument https://msbiskills.com/2018/01/10/new-t-sql-features-in-sql-server-2016-vii-use-hint-query-hint-argument/
8 TRUNCATE TABLE WITH ( PARTITIONS ( … ) ) https://msbiskills.com/2018/01/11/new-t-sql-features-in-sql-server-2016-viii-truncate-table-with-partitions/
9 Session_Context() https://msbiskills.com/2018/01/11/new-t-sql-features-in-sql-server-2016-ix-session_context/
10 Row Level Security coming soon….
11 Always Encrypted coming soon….
12 Stretch Database coming soon….
13 Temporal table https://msbiskills.com/2018/01/21/new-t-sql-features-in-sql-server-2016-xi-temporal-tables/
13.1 Temporal table:HIDDEN COLUMN https://msbiskills.com/2018/03/08/new-t-sql-features-in-sql-server-2016-temporal-table-hidden-column/
14 Built in JSON Support https://msbiskills.com/2018/01/22/new-t-sql-features-in-sql-server-2016-xiv-json-support-in-sql-server-2016/
15 Dynamic Data Masking https://msbiskills.com/2018/01/23/new-t-sql-features-in-sql-server-2016-xviii-dynamic-data-masking/
16 QueryStore coming soon….
17 Polybase https://msbiskills.com/2018/01/25/new-t-sql-features-in-sql-server-2016-xix-polybase/
18 R-Integration coming soon….
19 FormatMessage() https://msbiskills.com/2018/01/11/new-t-sql-features-in-sql-server-2016-x-formatmessage/
20 OPENJSON Function https://msbiskills.com/2018/01/22/new-t-sql-features-in-sql-server-2016-xii-openjson-function-sql-server/
21 ISJSON Function https://msbiskills.com/2018/01/22/new-t-sql-features-in-sql-server-2016-xiii-isjson/
22 JSON_VALUE Function https://msbiskills.com/2018/01/22/new-t-sql-features-in-sql-server-2016-xv-json_value/
23 JSON_MODIFY Function https://msbiskills.com/2018/01/23/new-t-sql-features-in-sql-server-2016-xvii-json_modify/

Enjoy !!! Keep Learning

Pawan Khowal 

Http://MSBISkills.com