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

SQL Server 2017 Database Engine - 1.     New string functions are CONCAT_WS , TRANSLATE , and TRIM , and WITHIN GROUP 2.       CLR assemblies 3.       In-memory enhancements 4.       Resumable online index rebuild 5.     IDENTITY_CACHE 6.       ADMINISTER DATABASE BULK OPERATIONS is now visible in sys.fn_builtin_permissions 7.       Automatic database tuning 8.       Graph database capabilities 9.       A sp_configure option called clr strict security is enabled by default to enhance the security of CLR assemblies. 10.   Setup now allows specifying initial tempdb file size up to 256 GB per file 11.   modified_extent_page_count 12.   SELECT INTO T-SQL syntax now supports loading a table into a FileGroup other than the user's default by us...

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