Category Archives: SQL Server

Creating a System-Versioned Temporal Table – There are three ways to create a system-versioned temporal table with regards to how the history table is specified: 1) Creating a temporal table with an anonymous history table Creating a temporal table with an anonymous name. This is easiest way to create it when you do not concern … Continue reading →

Kronothon2.0 – The only difference between Success and Failure is one’s attitude. Register here to win cash prizes up to 5 Lakhs – http://kronos.hackerearth.com/kronothon-2/ #Work4Kronos #MyWorkInspired #Kronothon2.0 #Coding #Ideas #Win #Engineer #MBA #Register #Hackerearth #codathon #casestudy #Ideathon #hackerearth #Challenge #Ilovecoding #excitement#Innovation

System-versioned temporal tables is new database feature of SQL Server 2016. Another improved version of table level auditing with some new features after trigger, CT & CDC. System-versioned temporal tables stores data of table data modification history. Temporal is a database feature that was introduced in ANSI SQL 2011. Most common usage for temporal tables … Continue reading →

Dynamic Data Masking (DDM) is new feature of SQL Server 2016. DDM helps in preventing unauthorized access to sensitive data. DDM enables only privilege users to have complete data. Un-privilege users will have access of MASKED data only. As an example, a call center support person may identify callers by several digits of their social … Continue reading →