The below is to understand how we can handle JSON data in prior versions of SQL Server 2016. Sample JSON data is: {“accountNumber”: 2020112,
Category: RDBMS
Logical vs Physical Computed Columns
Many people have asked me about the difference between using and not using ‘PERSISTED’ in a computed column; and how do we know whether the
Disk Space Usage For Analysis
The following implementation helped me in analyzing the disk space usage. There are many ways to get the available disk space in the server and
Adding Multiple Columns With Default Value
Almost a decade before, I came across a requirement where I needed to add multiple columns in a table with default value. It took a
SQL Server – Replicate Function
SQL Server “Replicate” Function repeats a character expression to a specified number of times. It is equivalent to or alternative of Oracle’s RPAD function. Let’s’
Alert on Scheduled SQL Jobs – Missed to enable
During the deployments, windows patching or any other activity, DBAs often disable the jobs to avoid data corruption and jobs failure. Once the activity is
Big Data & SQL 