Mehedi's Earth

Recently, I was in need to generate a report to find out how many customer calls daily within 10 AM [More]

It is a common challenge for T-SQL developers to remove special ASCII characters. Let's discuss more user [More]

Catch me at APAC Data Community on APAC DataSession2020 Bootcamp

Event Date - 12 Dec 2020, Saturday [More]

I would like to share three good things with you [More]

This is the second part of series of article on SQL Server ML Services. In first part, we have focused on the internal architecture. [More]

 
Please join the Virtual PASS SQL SQLSaturday 1009 on 26-09-2020. I am speaking on ML Services [More]

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]