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,240 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,970 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,681 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,179 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,720 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

712 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

764 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,956 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,544 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

SQL Server Database Migration Pitfalls

By Peter Skoglund

SQL Server Database Migration Pitfalls (and How to Fix Them) Database migrations are where great...

Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant

By Monica Rathbun

Every Scooby-Doo episode has one thing in common — there’s always a fake ghost....

Regression Testing: DAX User Defined Functions

By Joyful-Craftsmen

User Defined Functions is a new feature in PowerBI currently in public preview. There...

Read the latest Blogs

Forums

Large posts full of code not allowed anymore?

Several times now, I've seen a post asking for a solution. I've replied, and...

Data > Hype

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Data > Hype

Create and Read the Analysis Services Flight Recorder

By Pablo Echeverria

Comments posted to this topic are about the item Create and Read the Analysis...

Visit the forum

Question of the Day

Slipstream parameters

What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?

See possible answers