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 Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins

by Vivek Johari

Vivek's SQL Notes

I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...

2010-01-02

24,843 reads

Sql Server- Difference between Stored Procedure and Function

by Vivek Johari

Vivek's SQL Notes

In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...

2009-12-22

2,178 reads

Difference between Delete and Truncate Command

by Vivek Johari

Vivek's SQL Notes

Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...

2009-12-17

1,254 reads

Sql Server - How to write a Stored procedure in Sql server

by Vivek Johari

Vivek's SQL Notes

Stored Procedure:-Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are...

2009-12-05

1,504 reads

Sql Server - Union and Union All

by Vivek Johari

Vivek's SQL Notes

Union and Union All, both are used to select data from one or more than one tables but still they...

2009-11-17

4,489 reads

IDENTITY Property in SQL Server

by Vivek Johari

Vivek's SQL Notes

IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...

2009-11-11

1,866 reads

Technology with Vivek Johari: How to make database offline or online

by Vivek Johari

Vivek's SQL Notes

Technology with Vivek Johari: How to make database offline or online

2009-10-19

670 reads

Blogs

A New Word: the Kinder Surprise

the kinder surprise – . the point in your early adolescence when you realize...

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...

Future IT Roles – Agentic Architect and AI Boom!!

By Vinay Thakur

These days everything is changing to AI World, IT roles are getting changed and...

Read the latest Blogs

Forums

Kantor BCA Finance pusat Tlpn/wa0853.7373-7551

Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran Lama, Kota...

BCA Finance WTC Mangga Dua Tlpn/wa0853.7373-7551

Tlpn/wa0853.7373-7551 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL,...

There's Too Much to Learn

By Steve Jones - SSC Editor

Comments posted to this topic are about the item There's Too Much to Learn

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers