Temporal Tables in SQL Server

A system-versioned temporal table is a type of user table designed to keep a full history of data changes and allow easy point in time analysis. This type of temporal table is referred to as a system-versioned temporal table because the period of validity for each row is managed by the system (i.e. database engine). […]

Pages and Extents

Pages and Extents are core concept of data storage in SQL Server. A Page is a 8Kb space allocated in physical drive to be used by SQL Server. Managing these 8Kb Pages would have been difficult and so to help in it we have Extent which is a collection 8 Pages. As stated before a […]

What & How of SQL Server

I always love to geek out in everything I do, If I read or learn something new I always try to learn it’s internals for better understanding of the topic. This has its own pros and cons, pros being if you know the internals of something then you will have better understanding of the topic […]

Log Shipping Internals

Log shipping is the oldest Disaster Recovery feature provided by SQL Server. The best part is that it is very easy to implement. Check here for the steps to be followed. It creates three jobs for: Backup the log at primary, Copy the backup file to secondary and the last one to Restore the backup. […]

TDE: Transparent Data Encryption

TDE is encryption of the database, by using which we can encrypt the database at rest. The ‘rest’ here means that the data files, log files and the backup files are encrypted at the storage level. When SQL Server requires to read this data it gets decrypted and stored in the memory and so once […]

Always Encrypted

Majority of my current projects are clients of Insurance industry, and similar to any sector which handles and stores personal data they also follow stringent security policies. Audits are regular thing in any organization and in one of the internal audits it was decided to hide the confidential data like Social Security Number from everyone […]