Author Archives: rohitmssqlfun

CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage data, issues faced and other information. Vendor uses this information for market expansion, bug fixing and new features. But all this happen with user confirmation during or after installation. Microsoft is also doing it for … Continue reading →

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 →