kiran sabne
kiran sabne's Blog

kiran sabne's Blog

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

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

Understanding SQL Server PIVOT and UNPIVOT with example

May 14, 20225 min read

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

Track Data Changes in SQL Server with Change Tracking

Apr 10, 20228 min read

SQL Server provides three mechanisms to track data changes in the table objects. This mechanism is also a useful solution for implementing the audit...

Understanding Isolation levels in SQL Server

Apr 6, 20228 min read

A transaction is a group of T-SQL statements performing single or multiple operations on objects as a single unit. If any of the statements in the...

Auditing & Implementing Data Change Capture with Triggers in SQL Server

Apr 3, 20228 min read

Database Auditing is a process of tracking and logging all events and capturing data changes in database objects, it not only helps businesses but is...