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,842 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,178 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,254 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,504 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,489 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,865 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

670 reads

Blogs

In-Person CISA Training – April 13-16, 2026

By Brian Kelley

I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...

EightKB 2026

By Andrew Pruski

EightKB is back again for 2026! The biggest online SQL Server internals conference is...

The FinOps Lifecycle: From Budgeting to Reporting

Working in DevOps long enough teaches you two universal truths: That’s exactly why I...

Read the latest Blogs

Forums

query to track time spent on individual tasks in SSIS

Hi everyone I am looking at building a query to determine how much time...

SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database

Comments posted to this topic are about the item SQL Server Transactional Replication from...

Hidden Heroes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hidden Heroes

Visit the forum

Question of the Day

Identities and Sequences I

When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?

See possible answers