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,842 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,865 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

Advice I Like: Rewards from Work

The greatest rewards come from working on something that nobody has words for. If...

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...

Why your data still can’t answer a simple question

By Joyful-Craftsmen

Every organization I talk to has the same problem dressed up in different clothes....

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Comments posted to this topic are about the item The day-to-day pressures of a...

Analysis Services Model w/ Direct Query and (Default Veritpaq)

Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...

Don't Panic

By Grant Fritchey

Comments posted to this topic are about the item Don't Panic

Visit the forum

Question of the Day

Identities and Sequences IV

When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?

See possible answers