Click here to Skip to main content
13,554,130 members

Articles by Vivek Johari (Article: 1, Technical Blogs: 8, Tip/Tricks: 2)

Article: 1, Technical Blogs: 8, Tip/Tricks: 2

RSS Feed

Average article rating: 4.69

Database
SQL
Posted: 20 Aug 2010   Updated: 20 Aug 2010   Views: 154,360   Rating: 4.69/5    Votes: 32   Popularity: 7.05
Licence: The Code Project Open License (CPOL)      Bookmarked: 64   Downloaded: 0
This article is written to describe all the different types of Sql Joins

Average blogs rating: 4.11

Posted: 23 Apr 2018   Updated: 23 Apr 2018   Views: 2,230   Rating: 4.14/5    Votes: 4   Popularity: 2.29
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Through this article, we are going to discuss three important interview questions of SQL
SQL Server
Posted: 20 Aug 2010   Updated: 20 Aug 2010   Views: 103,510   Rating: 5.00/5    Votes: 11   Popularity: 5.21
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
This post will show you how to make database offline or online.
Posted: 20 Aug 2010   Updated: 29 Aug 2010   Views: 53,040   Rating: 3.92/5    Votes: 11   Popularity: 4.25
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Identity property in SQL Server
Posted: 12 Nov 2010   Updated: 12 Nov 2010   Views: 1,736,441   Rating: 4.80/5    Votes: 114   Popularity: 9.88
Licence: The Code Project Open License (CPOL)      Bookmarked: 81   Downloaded: 0
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.
Posted: 16 Nov 2010   Updated: 16 Nov 2010   Views: 39,970   Rating: 4.29/5    Votes: 12   Popularity: 4.73
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
Introduction to SQL Server Views
Posted: 16 Nov 2010   Updated: 16 Nov 2010   Views: 31,260   Rating: 4.43/5    Votes: 6   Popularity: 3.37
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
This article will try to show how to find duplicate values in a table.
Posted: 17 Nov 2010   Updated: 17 Nov 2010   Views: 64,030   Rating: 4.54/5    Votes: 6   Popularity: 3.57
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Basic information about the different ways of creating a table
IoT on Azure
General
Posted: 23 Apr 2018   Updated: 23 Apr 2018   Views: 2,120   Rating: 1.80/5    Votes: 2   Popularity: 0.30
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU?

Average tips rating: 4.11

Programming Tips
General
Posted: 26 Nov 2010   Updated: 26 Nov 2010   Views: 9,680   Rating: 3.50/5    Votes: 3   Popularity: 0.95
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
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
Posted: 26 Nov 2010   Updated: 26 Nov 2010   Views: 8,250   Rating: 4.71/5    Votes: 5   Popularity: 3.22
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
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.
No reference articles have been posted.

Vivek Johari
Database Administrator
India 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


Advertise | Privacy |
Web01 | 2.8.180515.1 | Last Updated 23 May 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid