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

AI: Blog a Day – Day 7: Vector and Vector Databases

By Vinay Thakur

Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...

AI: Blog a Day – Day 6: Embeddings – How AI Understands

By Vinay Thakur

Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...

The Book of Redgate: Mistakes

This is kind of a funny page to look at. The next page has...

Read the latest Blogs

Forums

Why End-User Testing Is Even More Important with AI

Comments posted to this topic are about the item Why End-User Testing Is Even...

Dynamic Unpivot

I have a table I didn't design that has tons of repeating groups in...

Writing as an Art and a Job

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing as an Art and...

Visit the forum

Question of the Day

String Similarity II

What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?

See possible answers