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

All authors

All authors

Blogs

Speaking at the TechnoSecurity and Digital Forensics East Conference

By

The Techno Security & Digital Forensics Conference (East) runs from June 3-5, 2025, this...

Techorama 2025 – Slides

By

You can find the slides for my session Building the €100 data warehouse with...

Query Hints and Estimated Plans

By

I’m working on an update to my Query Performance Tuning book for SQL Server...

Read the latest Blogs

Forums

SQL Cookbook: Query Solutions and Techniques for All SQL Users

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Cookbook: Query Solutions and...

SQL Server 2022 Query Performance Tuning

By Grant Fritchey

Comments posted to this topic are about the item SQL Server 2022 Query Performance...

Architecting Power BI Solutions in Microsoft Fabric

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Architecting Power BI Solutions in...

Visit the forum

Question of the Day

CONCAT_WS

What output do the queries produce? 

SET CONCAT_NULL_YIELDS_NULL ON;
SELECT CONCAT_WS ('-', NULL, NULL);
SET CONCAT_NULL_YIELDS_NULL OFF;
SELECT CONCAT_WS ('-', NULL, NULL);

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy