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 for getting optimise performance ....
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 and breaches....
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 tables, providing detailed information about...
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. Stored procedure are better than...
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 to find out the size...
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 @ec INT; DECLARE @bfn VARCHAR(1000);...
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 this article, I will try...
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 by the database programmer having...
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. In this article, I am...
Database Creation using Create Database command
In SQL Server, database can be created by 2 ways:- Using Create Database command Using SQL Sever Management Studio (SSMS). In this article, I am...