Mehedi's Earth

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]

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]

Technically, SQL Server does not support multiple IDENTITY Columns in a single table. Can we still achieve this? If yes, how? [More]

Let's discuss some more interesting and unusual use of IDENTITY function. Can we use negative value in identity column? [More]

SATURDAY, AUGUST 22, 2020 AT 5 PM – 8 PM
Software Performance Scalability & Productivity t [More]

Step by step installation of SQL Server 2019 ML Services and a Python example will be covered here for windows local machine. [More]

Did you ever wondered how to INSERT values in IDENTITY column or fill the gap of missing value of ID [More]