Top Interview Questions on SQL NULL value
Technology with Vivek Johari
by vivekjohari
1y 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
Visit website
SQL Joins Tricky Interview Questions
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
Point In Time Restore for Azure SQL Database
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
Azure – Creating an Azure SQL Database
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
Merry Christmas
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
SQL Triggers – An Introduction
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
How to migrate SQL Database to Azure SQL Database using SSMS Export/Import
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
Difference between Stored Procedure and Trigger
Technology with Vivek Johari
by vivekjohari
2y 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
Visit website
Advantages of SQL Stored Procedure
Technology with Vivek Johari
by vivekjohari
2y ago
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 Stored Procedure which we are going to discuss in this article. Advantages of SQL Stored Procedure 1) One of the main benefit of using the Stored procedure is that it  reduces the amount of information sent to the database server. It can become more impor ..read more
Visit website

Follow Technology with Vivek Johari on Feedspot

Continue with Google
OR