With the popularity of RESTful APIs JSON has become a popular format to store data. In this post we will see how we can import the json data into excel.

Do you know how to do audit in sql server ? Sql server 2016 had introduced temporal tables that helps in maintaining the history of the records.

SQL Server has some very useful system stored procedures to perform various activities in the database.

Let us understand the usage of MERGE and USING in SQL to perform an UPSERT in SQL Server

In this post we will look into how to generate SQL scripts from MS Excel.