Author Archives: vivekjohari

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.

SQL Joins Tricky Interview Questions

Posted on April 17, 2019 by vivekjohari

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 reading →

Posted in SQL Server | 32 Comments

Point In Time Restore for Azure SQL Database

Posted on January 8, 2019 by vivekjohari

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

Posted on December 27, 2018 by vivekjohari

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

Merry Christmas

Posted on December 24, 2018 by vivekjohari

Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!

Posted in Festive Greetings | Tagged | 32 Comments

SQL Triggers – An Introduction

Posted on December 8, 2018 by vivekjohari

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

Posted on November 25, 2018 by vivekjohari

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

Posted on November 19, 2018 by vivekjohari

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

Difference between Stored Procedure and Trigger

Posted on November 1, 2018 by vivekjohari

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 … Continue reading →

Posted in Imp SQL Difference, SQL Server, SQL Stored Procedure | Tagged , , , | 15 Comments

Advantages of SQL Stored Procedure

Posted on November 1, 2018 by vivekjohari

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 … Continue reading →

Posted in SQL Server, SQL Stored Procedure | Tagged , , | 32 Comments

Advantages & Disadvantages of SQL Trigger

Posted on November 1, 2018 by vivekjohari

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 … Continue reading →

Posted in SQL Server, SQL Triggers | Tagged , | Leave a comment