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.
Continue ReadingLearn database in a simple and easy way.
In this article, I have tried to explain the SQL Join concepts with the help of the Interview questions which interview candidate faces regularly.
Continue ReadingPoint 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 to discuss the point in time restore for azure SQL database and its backup capabilities. […]
Continue ReadingCreating 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 of Azure […]
Continue ReadingWish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!
Continue ReadingSQL 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 […]
Continue ReadingMigrating 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 […]
Continue ReadingMigrating 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, […]
Continue ReadingDifference 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 […]
Continue ReadingSQL 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 […]
Continue ReadingAdvantages & 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 […]
Continue Reading