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 […]
SQL Joins Tricky Interview Questions
In this article, I have tried to explain the SQL Join concepts with the help of the Interview questions which interview candidate faces regularly.
Point In Time Restore for Azure SQL Database
Point In Time Restore for Azure SQL Database Contents Introduction Automatic Backups Backups Retention Period Point In Time Database Restoration
Azure – Creating an Azure SQL Database
Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select
Merry Christmas
Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!
SQL Triggers – An Introduction
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool Contents Introduction Microsoft Database Migration Assistant
How to migrate SQL Database to Azure SQL Database using SSMS Export/Import
Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents Introduction Creating the .bacpac file using SSMS Export Importing
How to migrate SQL Database to Azure SQL Database using SSMS Export/Import Read Post »
Difference between Stored Procedure and Trigger
Difference between Stored Procedure and Trigger SQL Stored Procedure & SQL Triggers, both are the important objects of
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.
Advantages & Disadvantages of SQL Trigger
Advantages & Disadvantages of SQL Trigger Introduction Triggers are database objects which are needed to perform some predefined action for
How to migrate SQL Database to Azure SQL Database using SSMS deploy
Migrating SQL Database to Azure SQL Database using SSMS Deploy In the previous articles, we had introduction about
How to migrate SQL Database to Azure SQL Database using SSMS deploy Read Post »
How to connect with Azure SQL Database
This article gives the Step by Step process of how to connect with Azure SQL Server. Images has been added at every step to make understanding of the concept easy and in a better way.
Azure Pricing Models and Service Tiers
Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU? Example Different Service Tiers in DTUs base
DBA, SQL Server
SQL Script to find the database & their files details on a SQL Server
SQL Script to find database details Sometimes we need a SQL Script which can give the below information about the
SQL Script to find the database & their files details on a SQL Server Read Post »