Point In Time Restore for Azure SQL Database Contents Introduction Automatic Backups Backups Retention Period Point In Time Database Restoration
Continue readingTag: CodeProject
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
Continue readingSQL Triggers – An Introduction
SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax
Continue readingMigrating 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
Continue readingHow 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
Continue readingHow 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
Continue readingAzure Pricing Models and Service Tiers
Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU? Example Different Service Tiers in DTUs base
Continue readingInterview question – Is Clustered index on column with duplicate values possible?
Through this article, we are going to discuss three important interview questions of SQL which are given below:- 1) Can
Continue readingWhile loop in SQL server
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code
Continue readingRanking Functions in SQL Server
Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition.
Continue reading