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 Triggers - An Introduction

by Vivek Johari

Vivek's SQL Notes

Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...

2011-11-10

1,252 reads

SQL Server Functions- An Introduction

by Vivek Johari

Vivek's SQL Notes

SQL FUNCTION: -
Function in a database can be defined as the code segment consisting of a logical group of SQL...

2011-08-02

2,974 reads

Cursor in sql server

by Vivek Johari

Vivek's SQL Notes

Sometimes our application required a database object which allows manipulation of data from a set of rows on row by row basic...

2011-07-21

2,689 reads

ACID Rules in Sql Server

by Vivek Johari

Vivek's SQL Notes

ACID Rules
ACID Rules:- It is a concept for evaluation of databases and their architecture.
A:- (Atomicity) – Atomicity states the principle of All...

2011-05-28

4,191 reads

DML, DDL, DCL, TCL in SQL Server

by Vivek Johari

Vivek's SQL Notes

Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...

2011-05-28

11,722 reads

Renaming a column in Sql Server

by Vivek Johari

Vivek's SQL Notes

We often need to change the name of a column of a table to a new name. We can do...

2010-09-06

715 reads

Thanks for supporting this blog and make it successful

by Vivek Johari

Vivek's SQL Notes

Hi friends
Thank you very much for supporting this blog. It really give me lots of encouragement to share my knowledge...

2010-09-02

767 reads

Difference Between Having and Where Clause in Sql Server

by Vivek Johari

Vivek's SQL Notes

Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there...

2010-01-31

11,959 reads

Group by.....Having Clause

by Vivek Johari

Vivek's SQL Notes

Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns.
The syntax...

2010-01-31

2,547 reads

How to find duplicate values in a table

by Vivek Johari

Vivek's SQL Notes

Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a...

2010-01-31

4,039 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