JSON in SQL Server

Now SQL Server extends built-in support to the popular data exchanging format JSON. It exposes couple of functions for verifying, retrieving and updating JSON string. Let's carefully check them. [More]

Exploring IDENTITY Cache

IDENTITY is widely used for generating the sequential value mainly for primary key. In some cases like failure of database or restarting of database might result in gap between the sequential value. Today we will have hands on experience on the IDENTITY Cache, it's limitation and way around. [More]