What are temporal tables in SQL and how to use them for historical data tracking?
Temporal Tables in SQL Server Temporal Tables (also known as system-versioned tables) are a feature in SQL Server. They allow…
Best Practices in SQL Coding
For any programming language, just writing the code is not well enough. It should be written using the best practices…
Securing data in SQL Server
This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access…
Understanding CDC in SQL Server
In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to…
Advantages of SQL Stored Procedure
SQL Stored procedure are the set of logically group of SQL statement which are grouped to perform a specific task.…
SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used…
T-SQL script to find the growth size of database files
Below query can be used to see the growth size of database files. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE…
How to restore database backup in SQL SERVER
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In…
How to take Database backup in SQL SERVER
Introduction This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable…
Database Creation using SQL Sever Management Studio (SSMS)
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command.…