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

“We love to debate minutiae”

By Brian Kelley

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

Windows logins for users migrated from DomainA to DomainB

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases

Comments posted to this topic are about the item How to Use sqlpackage to...

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?

See possible answers