SQL Developer Blog
kiran sabne

kiran sabne

3 followers

SQL Developer and Backend Engineer. Love to research and work on complex and critical development and data engineering. Like to improve my database skills.

In-Memory OLTP for Faster SQL Server: Your Complete Guide

Dec 9, 20245 min read

In today's data-driven world, speed and performance are crucial for staying ahead. SQL Server's In-Memory OLTP (Hekaton) is a great feature that helps...

Integrating Azure SQL Database with External REST APIs using sp_invoke_external_rest_endpoint and Azure API Management

Oct 30, 20234 min read

This post demonstrates the integration of external Rest APIs with Azure SQL Database and Azure API Management Service. By utilizing the system-stored...

Implementing History Table or System Version Temporal Table to Track Data History

Aug 1, 20238 min read

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...

Handling Exceptions with Try-Catch in SQL Server

Apr 3, 20239 min read

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...

Understanding Database Normalization

Feb 10, 202310 min read

Intro Database Normalization is a concept & design technique we follow to efficiently organize data and design proper schema, to avoid redundant &...

Making REST-API call from SQL Server procedure

Sep 23, 20223 min read

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...