Technology with Vivek Johari
382 FOLLOWERS
Learn database in a simple and easy way.
Technology with Vivek Johari
3M ago
The post Happy New Year 2024 appeared first on Technology with Vivek Johari ..read more
Technology with Vivek Johari
2y ago
Top Interview Questions on SQL NULL value Introduction
In this article, I am going to explain NULL value in SQL and the frequently asked top SQL interview questions on SQL NULL value
SQL NULL value
In SQL, NULL is defined as unknown value or yet to be define value. For example, if an user has appeared for 5 exams and he got marks for 4 exams but last exam result is still awaited, we can’t place 0 value in last exam column. In this case we put NULL value in the last column and later replace it with the actual marks.
Also since NULL value is considered as unknown, we can’t compare one NULL ..read more
Technology with Vivek Johari
3y ago
SQL Joins Tricky Interview Questions Introduction
SQL Joins is always an important topic of SQL Server. In most of the SQL interviews, questions are asked about SQL Joins irrespective of the number of years experience one have. If the candidate has knowledge about SQL Joins concepts and join columns contains unique values, these SQL joins questions are not difficult to answer. But in case of some interviews, interviewers may make it trickier by asking SQL joins puzzles (queries) where these join columns may contains either duplicate values or NULL values which makes the result interesting and ..read more
Technology with Vivek Johari
3y ago
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 to discuss the point in time restore for azure SQL database and its backup capabilities. Azure SQL Database is a database as a service offered inside the Microsoft Azure. By database as a service,
Azure is responsible for taking care of database software, automatic backups, high availability, operating system & its hardware ..read more
Technology with Vivek Johari
3y ago
Azure SQL Database CreationCreating 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 SQL Database
Azure SQL Database Overview Page
Summary
Read More
Introduction
In my previous articles on Azure, I give introduction about Azure SQL & its pricing model & various Service Tiers. In this article, I will tell ..read more
Technology with Vivek Johari
3y ago
Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!
Merry Christmas
The post Merry Christmas appeared first on Technology with Vivek Johari ..read more
Technology with Vivek Johari
3y ago
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 Alter Table
DDL Trigger for Drop Table
Nested Triggers
Recursive triggers
How to find the Triggers in a database
How to Disable a trigger
How to enable a trigger
How to drop a trigger
Real life Example
Advantages of SQL Triggers
D ..read more
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool
Technology with Vivek Johari
3y ago
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 SQL Instance
Summary
Introduction
In my previous articles on migrating On premise SQL Database to Azure SQL Database, I have already discussed two migration methods using SSMS Deploy & SSMS ..read more
Technology with Vivek Johari
3y ago
How to migrate SQL Database to Azure SQL Database using SSMS Export/ImportMigrating 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, we discuss the SSMS deploy method as a step by step process. This article will tell how to migrate SQL Database to Azure SQL Database using SSMS Export/Import d ..read more
Technology with Vivek Johari
3y ago
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 set of logically group SQL Statement but they are needed to perform some predefined action for automatic execution whenever users try to execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are defined on Tabl ..read more