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.

How to pass Microsoft Certification Exams

Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view, it simple to crack Microsoft certification exams if you have worked hard on basic concepts and implemented most of the … Continue reading

Posted in Miscellaneous, SQL Advanced, SQL Server | Tagged , | 15 Comments

Interview questions for database developer

Technical Round Database Interview Questions 1) What are the different types of Trace flags which we used for detecting the Deadlock? 2) What are the different types of database backups? 3) How do you perform the Error handling in SQL … Continue reading

Posted in Interview Questions | Tagged | 32 Comments

My Best LinkedIn Articles

Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation. 7 Bad Management Traits That Will Make Your Employees Quit 5 Employee Motivation Tactics To Boost Morale and Productivity Failure the Key … Continue reading

Posted in Miscellaneous | Tagged | 21 Comments

My Best Technical Sites and Blogs

Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the list of tech sites which I used to refer most of the times for learning technologies and finding the solutions … Continue reading

Posted in Miscellaneous, SQL Server, SQL Tips | Tagged | 6 Comments

SQLTea – New SQL tutorial app in Google play store

SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial app SQLTea  ( Native android app) for SQL learning which includes articles from this blog. This application includes  1) Articles … Continue reading

Posted in Interview Questions, Miscellaneous | Tagged , | 18 Comments

How to restore database backup in SQL SERVER

In this article, I am going to explain the process of  Database restoration using the SQL Server Management Studio. In this article, I will try to explain this process in a simple way so that a database developer having little … Continue reading

Posted in SQL Advanced, SQL Database Restoration, SQL Server | Tagged , | 30 Comments

How to take Database backup in SQL SERVER

Introduction This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable by the database programmer having little knowledge of DBA. For taking the database backup, we need to follow the given … Continue reading

Posted in SQL Database Backup, SQL Server | Tagged , | Leave a comment

Database Creation using SQL Sever Management Studio (SSMS)

In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command. In this article, I am going to explain the steps of creation a database using SQL Sever Management Studio (SSMS) … Continue reading

Posted in SQL Basic, SQL Server | Tagged , | 22 Comments

Database Creation using Create Database command

In SQL Server, database can be created by 2 ways:-  Using Create Database command  Using SQL Sever Management Studio (SSMS). In this article, I am going to explain the database creation using the command CREATE DATABASE. Syntax for creating a … Continue reading

Posted in SQL Basic, SQL Server | Tagged , | 31 Comments

IN clause in SQL Server

With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can use the subquery to get the multiple values in the IN clause or we can have predefined values. In this … Continue reading

Posted in SQL Basic Concepts, SQL Server | Tagged , | 32 Comments