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

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

About Mariano

I'm Ethan Mariano a software engineer by profession and reader/writter by passion.I have good understanding and knowledge of AngularJS, Database, javascript, web development, digital marketing and exploring other technologies related to Software development.