Articles by Vivek Johari (Articles: 5, Technical Blogs: 10, Tip/Tricks: 2)

Articles: 5, Technical Blogs: 10, Tip/Tricks: 2

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.31

Database Development
SQL Server	SQL Joins 20 Aug 2010 Updated: 20 Aug 2010 Rating: 4.40/5 Votes: 33 Popularity: 6.57 Licence: CPOL Views: 182,662 Bookmarked: 67 Downloaded: 0 Please Sign up or sign in to vote. This article is written to describe all the different types of Sql Joins
Hosted Services
Azure	How to Migrate SQL Database to Azure SQL Database using SSMS Export/Import 19 Nov 2018 Updated: 19 Nov 2018 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: CPOL Views: 6,613 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents
	How to Migrate SQL Database to Azure SQL Database using SSMS Deploy 25 Nov 2018 Updated: 25 Nov 2018 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 5,630 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.
	SQL Triggers – An Introduction 8 Dec 2018 Updated: 10 Dec 2018 Rating: 4.78/5 Votes: 17 Popularity: 5.88 Licence: CPOL Views: 14,629 Bookmarked: 31 Downloaded: 0 Please Sign up or sign in to vote. This article “SQL Triggers – An Introduction” will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work.
	Point In Time Restore for Azure SQL Database 8 Jan 2019 Updated: 8 Jan 2019 Rating: 2.38/5 Votes: 4 Popularity: 1.44 Licence: CPOL Views: 10,892 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. This article discusses the step by step process of point in time restore for Azure SQL database, Azure automatic backups as well as database backups retention period.

Average blogs rating: 4.10

	How to Make Database Offline or Online [Technical Blog] 20 Aug 2010 Updated: 20 Aug 2010 Rating: 5.00/5 Votes: 11 Popularity: 5.00 Licence: CPOL Views: 137,419 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. This post will show you how to make database offline or online.
All Topics
	Azure Pricing Models and Service Tiers [Technical Blog] 23 Apr 2018 Updated: 23 Apr 2018 Rating: 1.80/5 Votes: 2 Popularity: 0.54 Licence: CPOL Views: 6,082 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU?
Database Development
SQL Server	IDENTITY Property in SQL Server [Technical Blog] 20 Aug 2010 Updated: 29 Aug 2010 Rating: 4.17/5 Votes: 11 Popularity: 4.17 Licence: CPOL Views: 59,380 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Identity property in SQL Server
	Sql Server - How To Write a Stored Procedure in SQL Server [Technical Blog] 12 Nov 2010 Updated: 12 Nov 2010 Rating: 4.80/5 Votes: 114 Popularity: 9.78 Licence: CPOL Views: 1,959,071 Bookmarked: 82 Downloaded: 0 Please Sign up or sign in to vote. Stored Procedure in SQL Server can be defined as the set of logically group of SQL statement which are grouped to perform a specific task. This article will describe the Stored Procedure in SQL Server and their benefits.
	Introduction to SQL Server Views [Technical Blog] 16 Nov 2010 Updated: 16 Nov 2010 Rating: 4.29/5 Votes: 12 Popularity: 4.63 Licence: CPOL Views: 48,111 Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. Introduction to SQL Server Views
	How to Find Duplicate Values in a Table [Technical Blog] 16 Nov 2010 Updated: 16 Nov 2010 Rating: 4.43/5 Votes: 6 Popularity: 3.45 Licence: CPOL Views: 36,560 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. This article will try to show how to find duplicate values in a table.
	Different Ways to Create a Table and Insert Data into the Table [Technical Blog] 17 Nov 2010 Updated: 17 Nov 2010 Rating: 4.54/5 Votes: 6 Popularity: 3.53 Licence: CPOL Views: 80,813 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Basic information about the different ways of creating a table
Hosted Services
Azure	Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool [Technical Blog] 24 Nov 2018 Updated: 24 Nov 2018 Rating: 4.86/5 Votes: 4 Popularity: 2.92 Licence: CPOL Views: 8,073 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. 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
	Azure – Creating an Azure SQL Database [Technical Blog] 27 Dec 2018 Updated: 27 Dec 2018 Rating: 3.00/5 Votes: 4 Popularity: 1.81 Licence: CPOL Views: 4,112 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. 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 Elastic Pool Option Step 7: Choose Service Tier for
Programming Languages
SQL	Interview Question – Is Clustered Index on Column with Duplicate Values Possible? [Technical Blog] 23 Apr 2018 Updated: 23 Apr 2018 Rating: 4.14/5 Votes: 4 Popularity: 2.49 Licence: CPOL Views: 4,040 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Through this article, we are going to discuss three important interview questions of SQL

Average tips rating: 4.11

Database Development
SQL Server	SQL Server - How to create LinkedServer using SMO [Tip/Trick] 26 Nov 2010 Updated: 26 Nov 2010 Rating: 4.71/5 Votes: 5 Popularity: 3.30 Licence: CPOL Views: 11,110 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Nice tip Kanasz :) You can also create the linkedserver through SQL SERVER MANAGEMENT STUDIO by following the following pathClick on the Server ObjectsRight click on the Linked servers under the Server Objects and select the New linked Server option.
Programming Languages
SQL	COUNT of DISTINCT Rows in SQL Server [Tip/Trick] 26 Nov 2010 Updated: 26 Nov 2010 Rating: 3.50/5 Votes: 3 Popularity: 1.67 Licence: CPOL Views: 12,650 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Nice tip :)But if you have any column say empid which have the unique constraint then it is better to use the following SQL queryselect count(distinct empid ) from employees

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Vivek Johari

	Database Administrator
	India

I am currently working as a Senior DBA and have around 11 years of experience in database.

Degree:-
Master Degree in Computer(MCA)

Work experience:-
Designing of the database.
Database Optimization.
Writing Complex Stored Procedures,Functions,Triggers etc.
Designing and developing SSIS & DTS packages.
Designing SQL Reports using SSRS.
Database Server Maintenance.

Certification:-
Microsoft certified Sql DBA in Sql server 2008 (MCTS).
Microsoft certified BI professional in Sql server 2008 (MCTS).
Oracle certified profession DBA in ORACLE 10g (OCP)
certified profession DBA in ORACLE 9i (OCP)

My other publication
Technical Blog:- Technologies with Vivek Johari

Moderator and Blogger at BeyondRelational.com

Guest Author and Blogger at sqlservercentral.com

Articles by Vivek Johari (Articles: 5, Technical Blogs: 10, Tip/Tricks: 2)

Articles: 5, Technical Blogs: 10, Tip/Tricks: 2

Average article rating: 4.31

Database Development

Hosted Services

Average blogs rating: 4.10

All Topics

Database Development

Hosted Services

Programming Languages

Average tips rating: 4.11

Database Development

Programming Languages

Average reference rating:

Average project rating: