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,270 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,992 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,701 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,207 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,740 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

729 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

774 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,971 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,566 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,054 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Telp BCA KCP Central Park Cs 0823-74977784

Wa:082374977784 Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren, Grogol...

Telp BCA KCP Mandala Raya Cs 0823-74977784

By Layanan_BCA_24jam

Wa:082374977784 Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers