Anil Singh | Code-sample.com

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 Colu...

What's new in SQL Server 2016, 2017 and 2018? Top 7 Features Added in the SQL Server 2016 - 1.      Query Store 2.      Polybase 3.      Stretch Database 4.      JSON Support 5.      Row Level Security 6.      Always Encrypted 7.      In-Memory Enhancements Query Store  Microsoft is maintain query store upgrading most of all versions  but  What happen in this version? Actually In this version Microsoft trying to maintains a history of query execution plans with query performance and quickly queries etc. PolyBase Microsoft is introduced Polybase,  This is data processing technique that is called SQL Server connector. This SQL connector provide the connectivity to Azure Blob Storage and Hadoop using database tables query and Its dealing to a lot of large text files. Stretch D...