Vivek Johari

Vivek Johari is currently a Senior CloudOps Engineer and
have more that 14 years of experience in database. He has Master
degree in Computer and also he is Microsoft certified Sql DBA
(MCTS)& Microsoft certified SQl BI professional(MCTS). He is also
Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has
the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work
basically involved designing and optimization of the Database.He has
also published many database articles on his blog Technologies with Vivek Johari.

Interests: SQL, database, Oracle, Big Data, Azure

Website: https://www.techmixing.com

Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins

by Vivek Johari

Vivek's SQL Notes

I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...

2010-01-02

24,835 reads

Sql Server- Difference between Stored Procedure and Function

by Vivek Johari

Vivek's SQL Notes

In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...

2009-12-22

2,176 reads

Difference between Delete and Truncate Command

by Vivek Johari

Vivek's SQL Notes

Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...

2009-12-17

1,250 reads

Sql Server - How to write a Stored procedure in Sql server

by Vivek Johari

Vivek's SQL Notes

Stored Procedure:-Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are...

2009-12-05

1,498 reads

Sql Server - Union and Union All

by Vivek Johari

Vivek's SQL Notes

Union and Union All, both are used to select data from one or more than one tables but still they...

2009-11-17

4,485 reads

IDENTITY Property in SQL Server

by Vivek Johari

Vivek's SQL Notes

IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...

2009-11-11

1,860 reads

Technology with Vivek Johari: How to make database offline or online

by Vivek Johari

Vivek's SQL Notes

Technology with Vivek Johari: How to make database offline or online

2009-10-19

666 reads

Blogs

Advice I Like: Praise

Don’t reserve your kindest praise for a person until their eulogy. Tell them while...

Prepping for Certification, Part 1 of ?

By Brian Kelley

I thought it would be good to put my thoughts down on how to...

How to Avoid Knowledge Stagnation

By MarlonRibunal

You want the short answer? Well, the only antidote to knowledge stagnation is probably...

Read the latest Blogs

Forums

is there a way to "detect" schema like changes on a server?

Hi, we have a few people who like to experiment on our prod sql...

Guidelines and Requirements

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Guidelines and Requirements

Copying Production Schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Copying Production Schema

Visit the forum

Question of the Day

Copying Production Schema

If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?

See possible answers