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,851 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,262 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,493 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,871 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

Red Flags in Your Query (T-SQL Tuesday #200)

When I'm looking at a query, I bet it's bad if I see... a...

T-SQL Tuesday #200: When I Look at a Query …

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...

Reflections on the Life of a DBA

By MarlonRibunal

The DBA life is fraught with pain. Those battles that we endure are mostly...

Read the latest Blogs

Forums

A Quick Second Opinion

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Second Opinion

Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload

Comments posted to this topic are about the item Five Intelligent Query Processing Features...

Checking the Error Log I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking the Error Log I

Visit the forum

Question of the Day

Checking the Error Log I

On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?

See possible answers