April 13, 20232 min readHow to import JSON data into Excel ?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.
May 18, 20225 min readHow to audit records in Sql Server ?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.
August 3, 20214 min readSome very useful System Stored Procedure in SQL ServerSQL Server has some very useful system stored procedures to perform various activities in the database.
April 05, 20213 min readUpsert in SQL ServerLet us understand the usage of MERGE and USING in SQL to perform an UPSERT in SQL Server
April 4, 20213 min readGenerating SQL Scripts from ExcelIn this post we will look into how to generate SQL scripts from MS Excel.