Featured Article

SQL Script: – How to find the last access date of a database

By | March 29, 2018

SQL Script to find database last access date Sometime we create databases on Test/ Development database servers for temporary uses for short duration and  forgot to delete them after the work got completed. As a part of house keeping activity, we need to find out when a database is last accessed in order to find… Read More »

Featured Article

Difference between Subquery, Nested Subquery and Correlated Subquery

By | September 29, 2009

Difference between Subquery, Nested Subquery and Correlated Subquery Query Query can be defined as a way to inquire the data from the database. It is used to extract the data from one table or multiple tables depending upon the user needs. Suppose we have a two tables Student and courses whose structure is given below:-… Read More »

SQL Triggers – An Introduction

By | December 8, 2018

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 for Update Instead of Triggers DDL Triggers DDL Trigger for Create Table DDL Trigger for… Read More »

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool

By | November 25, 2018

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 project Migrating the database using the Migration project type Verifying the migrated database on Azure… Read More »

How to migrate SQL Database to Azure SQL Database using SSMS Export/Import

By | November 19, 2018

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 Azure SQL Database. In the previous article on migrating SQL Database to Azure SQL Database,… Read More »

Difference between Stored Procedure and Trigger

By | November 1, 2018

Difference between Stored Procedure and Trigger     SQL Stored Procedure & SQL Triggers, both are the important objects of SQL. SQL stored procedure are the set of logically group of SQL statements which are a group to perform a specific task. Trigger are also similar to SQL Stored procedure as they can also be a… Read More »

Advantages of SQL Stored Procedure

By | November 1, 2018

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 the inline SQL queries as they help in securing the database from SQL Injection. It also help in increasing the performance of the Database. There are many other Advantages of SQL… Read More »

Advantages & Disadvantages of SQL Trigger

By | November 1, 2018

Advantages & Disadvantages of SQL Trigger Introduction Triggers are database objects which are needed to perform some predefined action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are helpful since it can help in maintaining the integrity of the data in database tables… Read More »

How to migrate SQL Database to Azure SQL Database using SSMS deploy

By | November 1, 2018

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 the Azure SQL Databases. Now, in next step, we will discuss about the SQL database… Read More »

Azure – Creating an Azure SQL Database

By | October 25, 2018

    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 Elastic Pool Option Step 7: Choose Service Tier for database Step 8: Deployment… Read More »

Azure Pricing Models and Service Tiers

By | April 24, 2018

  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 migrating our database from SQL Server to Azure Database, we want to know what are… Read More »