Temporal tables are a new feature of SQL Server 2016. Temporal tables, also named system-versioned tables, allow SQL Server to automatically keep history of the data in the table. Temporal tables were introduced in the ANSI SQL 2011 standard and is n...

Available SQL Server 2016 SP1 editions. Enterprise. Access mission-critical capabilities to achieve unparalleled scale, security, high availability, and leading performance for your Tier 1 database, business intelligence, and advanced analytics workl...

Row Level Security (RLS) is a concept that provides security at the row level within the database layer, instead of at the application layer. RLS is accomplished by using a function and the new security policy feature that is being rolled out with S...

Dynamic data masking is one of the new Security Feature introduced in Sql Server 2016. It provides a mechanism to mask the data from non-privileged users. The users with sufficient permission will have complete access to the actual or un-masked data...

Among all of the new SQL Server 2016 Database Engine features Query Store stands out as a great addition to the performance tuning tools currently available out of the box.The Query Store feature helps you to track query plans, runtime statistics and...