SQL Developer and Backend Engineer. Love to research and work on complex and critical development and data engineering. Like to improve my database skills.
This post demonstrates the integration of external Rest APIs with Azure SQL Database and Azure API Management Service. By utilizing the system-stored...
System-Versioned Temporal Tables, also known as History Tables are a built-in feature that keeps track of data changes in SQL Server. Unlike regular...
This post is to understand and demonstrate TRY CATCH in SQL Server, we will also see, how to trigger and handle custom exceptions with example. ยท When...
Intro Database Normalization is a concept & design technique we follow to efficiently organize data and design proper schema, to avoid redundant &...
Recently I had a requirement, wherein I had to import the data from one of the internal applications to the SQL Server for further processing. We had...
PIVOT and UNPIVOT are relational operators for converting table expressions into one another. If we want to turn the unique row values of a column...