Profile

Cover photo
jainendra verma
Worked at DELL
Attended RGPV
Lived in INDIA
819 followers|60,064 views
AboutPostsPhotosVideos+1's

Stream

jainendra verma

Shared publicly  - 
 
SQL Server -How to move the “system database” files in SQL Server
It’s Very Simple 10 steps to
do this. In
this example System database files existing in C: Drive and I will move it in
D: Drive. Step1- Check the D drive is access.
Right click on D drive and go to Properties, go to security tab and find the Administrator
“...
1

jainendra verma

Shared publicly  - 
 
 
दुनिया का सबसे बड़ा सिद्ध साइबर अपराधी।
क्या यही है आम आदमी की पहचान?
 ·  Translate
2 comments on original post
1

jainendra verma

Shared publicly  - 
 
SQL Server: Everything about SQL Server Database Mirroring step by step and all Question and Answer of SQL Server Database mirroring
SQL Server: Everything about SQL Server
Database Mirroring step by step and all Question and Answer of SQL Server
Database mirroring. Friends believe me it’s very easy and anybody can create the mirroring and
work on it. For testing I am creating mirroring
...
1

jainendra verma

Shared publicly  - 
 
SQL Server : Complete DBCC commands for Performance Tunning in SQL Server
SQL Server : Complete DBCC commands for Performance Tunning in SQL Server. Using below queries we can tune the DB. /*Returns size
and fragmentation information for the data and indexes of the specified table
or view*/ SELECT * FROM sys . dm_db_index_physica...
SQL Server : Complete DBCC commands for Performance Tunning in SQL Server. Using below queries we can tune the DB. /*Returns size and fragmentation information for the data and indexes of the specified table or view*/ SELEC...
1

jainendra verma

Shared publicly  - 
 
TOP 10 FEATURES OF SQL SERVER 2012
1. Column store index 2. Pagination. - get results into part. 3. Contained database - when user will login at that time it will check databases access  for logging user. 4. Sequence objects- it similar to Oracle sequence object.  It used for creating identi...
1. Column store index 2. Pagination. - get results into part. 3. Contained database - when user will login at that time it will check databases access  for logging user. 4. Sequence objects- it similar to Oracle sequence obje...
1

jainendra verma

Shared publicly  - 
 
SQL Server: Best practice to Move database from one Location to another location.
Most of  SQL Server professional may know the how to move the database
form One location to another location. And most of the professional use the
"detach and attach" method but.. "Is it best
practice?"   NO!! WHY? – If your database file size
is1TB or arou...
1

jainendra verma

Shared publicly  - 
 
SQL Server : Important Commands for SQL Server DBA
--To check for
Blocked Processes: Sp_who2     --To find all
the log files and the percentage space used of those log files in an instance: dbcc sqlperf ( logspace )    --To list all
the files and their details in a particular database: exec sp_helpfile --To...
1

jainendra verma

Shared publicly  - 
 
SQL Server - How to resolve TempDB get FULL issue.
Please find the complete details to troubleshooting and resolving If the TempDB database get full:-   Description : The LOG FILE FOR DATABASE 'tempdb' IS FULL.  Back up the TRANSACTION LOG FOR the DATABASE TO free  up SOME LOG SPACE   Reason for temp DB ful...
Please find the complete details to troubleshooting and resolving If the TempDB database get full:-  Description: The LOG FILE FOR DATABASE 'tempdb' IS FULL.  Back up the TRANSACTION LOG FOR the DATABASE TO free  up SOME LOG ...
1

jainendra verma

Shared publicly  - 
 
SQL Server- How many IP Addresses used in SQL Server Clustering?
2 IP for heartbeat network (1 per node) 2 IP for public network (1 per node) 1 IP for Windows Cluster. 2 IP for SQL Server Virtual Network Name (SQL instance on each node) 1 IP for MSDTC (this is optional however required if you use distributed transaction ...
1

jainendra verma

Shared publicly  - 
 
SQL Server: Important DMV scripts for troubleshoot the issue in SQL Server
Please find the below important DMV scripts for troubleshoot the issue in SQL Server.   sys.dm_exec_requests sys.dm_exec_sql_text sys.dm_os_waiting_task sys.dm_os_wait_stats sys.dm_exec_sessions   sys.dm_tran_locks --Here is a
sample script that shows wait ...
1

jainendra verma

Shared publicly  - 
 
SQL SERVER – Tips of Linked Server in SQL Server
        Linked Server is providing facility to access / connect data to other Data source like MS Access, Oracle, My SQL etc. To access other data source into SQL server instance. We can use Linked server option. To creating Linked Server we have to follow ...
        Linked Server is providing facility to access / connect data to other Data source like MS Access, Oracle, My SQL etc. To access other data source into SQL server instance. We can use Linked server option. To creating ...
1
People
Have him in circles
819 people
Vishram Singh's profile photo
Kaiyum Mia's profile photo
Vinit Thakur's profile photo
DrKalpit jangid's profile photo
Gauraw Tiwari's profile photo
Mayursinh Mangrola's profile photo
Sumit Gupta's profile photo
ARUN VARPE's profile photo
vikram singh's profile photo
Work
Employment
  • DELL
    Sr. DBA
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
INDIA - Delhi
Links
Contributor to
Story
Tagline
Wel come my fnd :-)
Introduction

Jainendra Verma is a IT professional and working with Microsoft. I have 4.0 years of extensive experience in Analysis, Design, Development, Implementation, Testing, Maintenance, Troubleshooting and supporting huge production database and application in the client server environments as a Sr. SQL Server DBA. Proficient in the Microsoft SQL Server 2005, 2008 and 2012.

Please find my written articles of SQL Server on blog at SQL-INTEGRITY.

My words For this Blog "My goal is only that to provide some technical information to SQL Server Professional nothing else". Thanking you.

Education
  • RGPV
    IT
Basic Information
Gender
Male
Looking for
Friends, Dating, A relationship, Networking
Relationship
Single
Other names
JAI, JAANU, JAINENDRA
jainendra verma's +1's are the things they like, agree with, or want to recommend.
Shiridi Saibaba Live Darshan 2
market.android.com

This is version 2 SHIRIDI SAIBABA LIVE DARSHAN with bug fixes.Enjoy the live darshan of Lord Sri Shiridi Saibaba right from your mobile wher

Jainendra Verma is Sharing SQL Server Hint's & Tips on SQL Integ...
sqlintegrity.blogspot.com

SQL server concept such as T-SQL, Backup & Recovery, Performance Tuning, MDV, Maintenance, database issue & problem, SSAS, SSRS & SSIS

Bride - Hindi /Madhya Pradesh / Bundelkhand / Chattisgarhi - Hindu: Kurm...
www.jeevansathi.com

Looking for an ideal Hindi /Madhya Pradesh / Bundelkhand / Chattisgarhi Hindu: Kurmi kshatriya Hindu Bride in Bhopal, India? Your dream Life

SQL Server – How to see the SQL Server ERROR Log.
sqlintegrity.blogspot.com

SQL server stored the error log, which occurred in run time. Some time we need to see the error log to get the solution for Client and gener

NEW JOKES, Story & QUOTES *
newjokeandquote.blogspot.com

A long time ago, there was a huge apple tree. A little boy loved to come and play around it everyday. He climbed to the tree top, ate the ap

Health Fitness Talks 26
health-fitness-talks.blogspot.com

अगर आपको सच में गोरा होना है तो प्रकृति से जुड़िये जिससे आप सच में गोरे हो जाओगे। अधिकतर लोग गोरे होने के लिए क्या क्या नहीं करते अलग-अलग cr

Healt Fitness Talks 6
health-fitness-talks.blogspot.com

Computers have become indispensable in work place. Professionals spend more time working at computer workstations. The combination of fixed

Health Fitness Talks 25
health-fitness-talks.blogspot.com

चिकनगुनिया का इलाज ! मित्रो कुछ दिनो पहले चिकनगुनिया नाम की बीमारी बहुत तेजी से अपने देश मे फैली !! लाखो की संख्या मे लोग इससे प्रभावित हुये

Health Fitness Talks 18
health-fitness-talks.blogspot.com

पौष्टिक और स्वादिष्ट और सस्ता होगा ग्रीष्म ऋतु में जब शरीर में अतिरिक्त उष्णता बढ़ जाने से कुछ व्याधियाँ उत्पन्न होती हैं, तब दिन में एक बार

Health Fitness Talks 17
health-fitness-talks.blogspot.com

स्वस्थ रहने के लिए ४ नियम: १- खाना खाने के एकदम बाद पानी नहीं पीयें. कम से कम १ घंटे तक. खाना खाने से ४० मिनट पहले तक खूब पानी पी सकते हैं.

BETUL DETAILS , Madhya Pradesh
betuldetails.blogspot.com

बाल संस्कार का बीज रोपण अवश्य करे. सनातनी बाल संस्कार का बीज रोपण अवश्य करे " शिशु के जन्म से लेकर उसके वयस्क होने तक उसे शिक्षित एवं संस्का

Health Fitness Talks 16
health-fitness-talks.blogspot.com

ऐसी कुछ 103 चीज़े आयूर्वेद में बाताई गई है । जो एक साथ कभी नहीं खानी चाहिए । मित्रो आयूर्वेद के अनुसार कभी भी दो विरुद्ध वस्तूये एक साथ नहीं

Health Fintness Talks 9
health-fitness-talks.blogspot.com

Many of you like drinking a glass of lemonade to beat the strong heat during summers and for cosmetic benefits during winters but there are

Health Fitness Talks 13
health-fitness-talks.blogspot.com

गाजर में विटामिन और मिनरल्स / Benefits Of Carrot गाजर में विटामिन और मिनरल्स बहुत मात्रा में मिलते हैं।इसमें विटामिन और मिनरल्स बहुत मात्रा

Health Fitness Talks 14
health-fitness-talks.blogspot.com

नाश्ते में थोड़ा सा अंकुरित खाने के कुछ अनोखे फायद हेल्थ बनाने के लिए अधिकतर लोग भोजन में सलाद भी शामिल करते हैं क्योंकि माना जाता है कि खीर

Jainendra Verma is Sharing Hints And Tips On Health-Fitness-Talks
health-fitness-talks.blogspot.com

अगर आपका पेट ख़राब है और दस्त हो गया है , बार-बार आपको टॉयलेट जाना पड़ रहा है तो इसकी सबसे अच्छी दावा है जीरा | अध चम्मच जीरा चबाके खा लो और

Health Fitness Talks 10
health-fitness-talks.blogspot.com

Loose Motion / Stomach Loose motion and Other Stomach Disease अगर आपका पेट ख़राब है और दस्त हो गया है , बार-बार आपको टॉयलेट जाना पड़ रहा है

History of betul
betuldetails.blogspot.com

Biography. Taytu Betul (or Taitu) was born in or around 1851, the third of four children in an aristocratic Ethiopian family that was relate