November 2018 - Technology with Vivek Johari

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

November 25, 2018December 28, 2018 vivekjohari33 Comments

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 […]

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

November 19, 2018February 10, 2019 vivekjohari27 Comments

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, […]

Difference between Stored Procedure and Trigger

November 1, 2018 vivekjohari15 Comments

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 […]

Advantages of SQL Stored Procedure

November 1, 2018 vivekjohari32 Comments

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 […]

Advantages & Disadvantages of SQL Trigger

November 1, 2018November 1, 2018 vivekjohariLeave a Comment

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 […]

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

November 1, 2018February 10, 2019 vivekjohari2 Comments

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 […]