SQL Server 2016 vs 2017 vs 2018

What's new in SQL Server 2018?

Added TSA-Grade Security -
1.     Added Table level security, restricts, user permissions on table data and table names
2.     Self-Destructing Transactions
3.     Indirect Checkpoint Performance Improvements
4.     Edible Result Sets
5.     Renaming SQL Server Agent to Cortana
6.     Full text search, now available for all supported Linux
7.     Online index build and rebuild support for non-clustered column-store indexes
8.     Added New SSMS
9.     Added Scented Error Messages
10.  Eventual Consistency
11.  Added Duraflame Transaction Log
12.  Access Storage Engine
13.  Added MAIM command
14.  Added Twitch Tntegration for Video Replay
15.  Azure Power Enterprise Server
16.  New DAX IN function
17.  Clustered Columnstore Indexes now support LOB columns (nvarchar(max), varchar(max), varbinary(max))
18.  Added New string functions CONCAT_WS, TRANSLATE and TRIM
19.  Full support for JSON functions
20.  Database Engine - New compatibility level 140
21.  Enhancements to In-Memory Tables & SPs
22.  Added sp_spaceused, sp_rename, CASE, TOP (N) WITH TIES
And So On..

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.