Tag Archives: CodeProject

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 Step by Step process for Point In Time Database Restoration Summary Read More Introduction In this article we are doing … Continue reading

Posted in Azure, Azure Database Restoration | Tagged , , , | 39 Comments

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 Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose … Continue reading

Posted in Azure | Tagged , , | 29 Comments

SQL Triggers – An Introduction

SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax of the After trigger Example of After Trigger for Insert Example of After Trigger for Delete Example of After Trigger … Continue reading

Posted in Most Imp SQL Concepts, SQL Advanced, SQL Server, SQL Triggers | Tagged , , , , | 33 Comments

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 (DMA) tool Migrate SQL Server database To Azure SQL Instance using DMA tool Detecting the compatibility issues using Assessment Type … Continue reading

Posted in Azure, Migration to Azure SQL Database | Tagged , , , , | 33 Comments

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 the .bacpac file using SSMS Import Summary Introduction There are many ways of migrating the On premise SQL Database to … Continue reading

Posted in Azure, Migration to Azure SQL Database | Tagged , , , | 27 Comments

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 the Azure SQL Database, Azure Service Tiers and pricing models, Creation of Azure SQL Database & How to connect with … Continue reading

Posted in Azure, Migration to Azure SQL Database | Tagged , , , | 2 Comments

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 pricing model Standard Service Tier Levels Premium Service Tier Levels DTU Calculator How DTU Calculator work Conclusion Introduction When we start … Continue reading

Posted in Azure | Tagged , , , , | 32 Comments

Interview 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 we create clustered index on a column containing duplicate values?  2) Can we create a Primary Key on a table on which a … Continue reading

Posted in Interview Questions, SQL Advanced, SQL Indexes | Tagged , , , | Leave a comment

While loop in SQL server

While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code block. So we use while loop in SQL Server to repeat execution of a SQL Code block or a SQL Statement … Continue reading

Posted in SQL Basic Concepts, SQL Server, SQL While loop | Tagged , , , | 13 Comments

Ranking Functions in SQL Server

Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition. For example, suppose we want to give rank to sales man according to their sales amount in a particular month/year. … Continue reading

Posted in SQL Ranking Function, SQL Server | Tagged , | 30 Comments