Profile

Cover photo
Vivek Johari
Attended Guru Gobind Singh Indraprastha University
Lives in Delhi
886,778 views
AboutPostsPhotosVideos+1's

Stream

Vivek Johari

Shared publicly  - 
 
From today onwards I have added a new section in my blog "Question of the Week". In this section, I will be going to ask SQL puzzle twice a week from all of you and after two days will gives the answer for that Question. So k...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
For any programming language, just writing the code is not well enough. It should be written using the best practices. This article will try to explain the disadvantages of writing code without using Best Practices and latter...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
SQL Server - Convert() function
Convert () function in SQL Server to convert an expression from one data type to another data type Syntax for CONVERT function CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Convert functions is usually used with date/time data type to conver...
Convert () function in SQL Server to convert an expression from one data type to another data type Syntax for CONVERT function CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Convert functions is usually use...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
SQL Script to find the list of all the jobs failed yesterday
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all the jobs which are failed yesterday. SELECT DISTINCT
CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11)) ...
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all the jobs which are failed yesterday. SELECT DISTINCT CAST(CONVERT(datetime,CAST(run_d...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
SQL Script to find the tables created from a given date
Below is the SQL query which can be used to find out the tables which are created or modified on or from a given date. SELECT         [name] as Tablename        ,create_date        ,modify_date FROM         sys.tables where cast(create_date as date)>='Given...
Below is the SQL query which can be used to find out the tables which are created or modified on or from a given date. SELECT         [name] as Tablename        ,create_date        ,modify_date FROM         sys.tables where...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we can use to find out that. SELECT      t.NAME AS TableName,     i.name as indexName,     sum(p.rows) as RowCount...
1
Add a comment...
In his circles
532 people

Vivek Johari

Shared publicly  - 
 
Basic Concepts Database Creation   Database Creation using Create Database command   Database Creation using SQL Sever Management Studio (SSMS)   How to take Database backup in SQL SERVER   How to restore database backup in ...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
SQL Script to find the missing indexes
Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the missing indexes. Once you create these indexes, it will help in improving the Performance. SELECT db_name(d.database_id) dbn...
Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the missing indexes. Once you create these indexes, it will help in improving the Performance. ...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
**
select convert(varchar(40), getdate(), 0) select convert(varchar(40), getdate(), 101) select convert(varchar(40), getdate(), 102) select convert(varchar(40), getdate(), 103) select convert(varchar(40), getdate(), 104) select convert(varchar(40), getdate(), ...
select convert(varchar(40), getdate(), 0) select convert(varchar(40), getdate(), 101) select convert(varchar(40), getdate(), 102) select convert(varchar(40), getdate(), 103) select convert(varchar(40), getdate(), 104) select ...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
SQL Script to search stored procedures containing a given text
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the stored procedures which contains a  particular given text as input. SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(...
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the stored procedures which contains a  particular given text as input. SELECT OBJECT...
1
Add a comment...
 
SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used to find out the size of all the databases created on the server.  ;WITH DBSize (SqlServerInstanceName, DatabaseName, DatabaseSize, DBLogSize, TotalDBSize) AS (...
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used to find out the size of all the databases created on the server.  ;WITH DBSize (SqlServerInstanceName, DatabaseName, Database...
1
Add a comment...

Vivek Johari

Shared publicly  - 
 
T-SQL script to find the growth size of database files
Below query can be used to see the growth size of database files. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE @ec INT; DECLARE @bfn VARCHAR(1000); DECLARE @efn VARCHAR(10); -- Get the name of the current default trace SELECT @filename = CAST(...
Below query can be used to see the growth size of database files. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE @ec INT; DECLARE @bfn VARCHAR(1000); DECLARE @efn VARCHAR(10); -- Get the name of the current de...
1
Add a comment...
People
In his circles
532 people
Work
Occupation
Analyst / SQL DBA (MCTS SQL BI, MCTS SQL DBA) & OCP
Skills
SQL Server, ORACLE, SSIS, SSRS, SSAS, ASP, .Net
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Delhi
Previously
dwarka
Story
Tagline
OCP / MCTS / ANALYST / Technical Blogger
Introduction
Currently working as a Analyst and have around 8.5 years of experience in database. Have done Masters in Computer .  Have extensive experience in database designing ,Database Optimization, SSIS, Designing complex Reports using SSRS, Database Server Maintenance. Currently, working in an Indian MNC .Have done many certifications which Includes Microsoft certified Sql DBA in Sql server 2008 (MCTS), Microsoft certified BI professional in Sql server 2008 (MCTS), Oracle certified profession DBA in ORACLE 10g (OCP),certified profession DBA in ORACLE 9i (OCP). Also Guest author at Sqlservercentral.com, BeyondRelational.com. and Toadworld.com
Education
  • Guru Gobind Singh Indraprastha University
    MCA, 2003 - 2006
  • University of Delhi
    BSc(Hons) Mathematics, 2000 - 2003
  • Oracle
    OCP (DBA) in Oracle 10g and 9i, 2009 - 2009
  • Microsoft
    MCTS (Sqlserver DBA and Sql server BI), 2011 - 2011
Basic Information
Gender
Male
Relationship
Single
Vivek Johari's +1's are the things they like, agree with, or want to recommend.
Interview Questions
www.techmixing.com

Interview Questions on SQL Server -Part-1 Interview Questions On SQL Server -Part 2 Interview Questions on SQL Server -Part 3

SQL Tips
www.techmixing.com

How to remane a Table in Sql Server? How to change the database collation? How to find duplicate values in a table? How to make database off

Question of the Week
www.techmixing.com

From today onwards I have added a new section in my blog "Question of the Week". In this section, I will be going to ask SQL puzzle twice a

Articles Index
www.techmixing.com

Basic Concepts Database Creation Database Creation using Create Database command Database Creation using SQL Sever Management Studio (SSMS)

SQL Script to find the missing indexes
www.techmixing.com

Performance tuning in SQL is regular exercise and index creation is an important part of it. Below script will help in finding the missing i

SQL Server - Convert() function
www.techmixing.com

Convert () function in SQL Server to convert an expression from one data type to another data type Syntax for CONVERT function CONVERT ( dat

SQL SERVER - Data types
www.techmixing.com

In relational database, we store data in tabular form where data is divided into columns. Each column has a name and a data type which shows

SQL Script to find the list of all the jobs failed yesterday
www.techmixing.com

One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all th

SQL Script to find the databases size
www.techmixing.com

Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used to find out the size of all the databases

SQL Script to find the tables created from a given date
www.techmixing.com

Below is the SQL query which can be used to find out the tables which are created or modified on or from a given date. SELECT [name] as Tabl

SQL Script to search stored procedures containing a given text
www.techmixing.com

Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the

T-SQL script to find the growth size of database files
www.techmixing.com

Below query can be used to see the growth size of database files. DECLARE @filename NVARCHAR(1000); DECLARE @bc INT; DECLARE @ec INT; DECLAR

SQL Script to find the last executed commands on the SQl Server
www.techmixing.com

Sometimes we needs to find out the last executed commands on the database server. Below is the SQL script share by one of my friend Ken Wats

T-SQL script to find the highly populated tables in database
www.techmixing.com

Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we can use to find out that. SE

How to pass Microsoft Certification Exams
www.techmixing.com

Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view, it simple to crack Microsoft certi

Script to find the Fragmentation of indexes
www.techmixing.com

Below is the script to find the fragmentation of the indexes created on a database. use master SELECT OBJECT_NAME(OBJECT_ID), index_id,index

Script to find all the running queries/jobs on the Database Server
www.techmixing.com

Below is the query to find out all the Queries and their details like SSID etc. running on the SQL Server from all databases. It helps in fi

SQL Tea
market.android.com

App contains basic & advanced concepts of SQL with lots of examples. It helps in better understanding of SQL server. App includes Normalizat

My Best LinkedIn Articles
www.techmixing.com

Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation. 7 Bad Management Traits That Will Mak