Sachin Diwakar | DBA THINGS - Part 40
User Posts: Sachin Diwakar
0
How to create Drop and Recreate Script of all Indexes in a database?
0

I found this interesting script once so thought of sharing with everyone. Special thanks to the Unknown-Creator of this script.  This script generates the ...

0
What are naming standards/conventions for SQL Server? (1/5)
0

I think it will be good idea to setup some naming standards throughout your database servers’ farm. Most of us already have these standards in place. And if ...

0
Common Human Errors as DBA (Part 3)
0

  In continuation of the series of “Common Human Errors as DBA” – here I am posting Third Part of it. You may check others here. Part 1 & Part 2 ...

0
Is tempdb configured correctly?
0

Let’s learn about tempdb and some of the best practices about tempdb. Before doing this, let’s talk about tempdb and its usage. A Tempdb is a system ...

0
Common Human Errors as DBA (part 2)
0

You must have read my previous post (Part-1) about Common Human Errors as DBA and how to avoid them. Here is another post of the same series. Third error - ...

0
Database Engine Instances (SQL Server): A Quick Refresher
0

SQL Server instance of the Database Engine is nothing but a copy of the sqlservr.exe executable that runs as an operating system service. This means for each ...

0
Hide Your Real Data  – Data masking/ Data Scrambling/ Data Obfuscation
0

Data masking/ Data Scrambling/ Data Obfuscation – is the task for hiding actual data before sharing it with Users, UAT Testers, Vendors, Developers or anyone ...

0
Common Human Errors as DBA (part 1)
0

“Human Error” is not a new word. Most of the time if there is screwed up done by any one – these golden words are used. For sure, these are the Human Errors ...

0
About Vivek Garg
0

Blogger Name Vivek Garg Qualification & Experience Bachelor of Technology in computer science. Worked as Production DBA with TCS for clients belonging ...

0
About Vaibhav Gupta
0

Blogger Name Vaibhav Gupta Qualification & Experience Bachelor of Engineering B.E. (HONS) in computer science. Worked with top MNCs like Dell, HCL ISD ...

0
About Sachin Diwakar
0

Roles handled in past SQL DBA Team member SQL DBA Shift Leader SQL DBA Team Lead Trainer & Mentor (Learning & Development) SQL DBA Specialist ...

0
Database Accidents : Unwanted Restore
0

Number of times, while working as a DBA many accidents happen. Most common of them is when a database is restored without checking if a backup is available or ...

0
SQL DBA Training Session 4
0

When – Sunday, 11th Jan 2015 Time – 2 PM GMT (London Time) Duration – 2 Hours. Mode – Google Hangout. Who can attend : Those who have ...

0
DBAThings.com & SQL DBA Community integration
0

Guys, I am happy to share that Admin of SQL Server DBA (India) – A special group of DBAs, has shown his great trust and allowed me to serve this community as ...

0
About Amit Kumar
0

Blogger Name Amit Kumar Qualification & Experience MBA in System information technology from VMU, India. Worked with MNCs like ACS, Vertex and ...

Browsing All Comments By: Sachin Diwakar
  1. Database fundamental book is what we read in Graduation but we never cared and never understood the importance of this book. Lets read it again now!

  2. You can read PayPal FAQs if there is any doubt.

  3. Sachin Diwakar April 23, 2015 at 7:09 am

    I think its always a good idea to create a report. This kind of report must be delivered to DBA’s Distribution list for weekly/monthly review.

  4. Sachin Diwakar June 16, 2015 at 10:37 am

    Looks like copy paste issue. Script runs fine. I just tried it and even I can see that variables are there.

    Pls try again..

  5. Sachin Diwakar June 7, 2015 at 8:11 pm

    I agree with you Varun – thats how it should be.

  6. Hi Balram,

    Can you please post your career summary at our Forum?
    https://www.facebook.com/groups/sqlserverdbaindia

    Many SQL DBAs/HRs are connected using this forum, definetly you will get help.

    Regards
    Sachin

  7. Sachin Diwakar April 9, 2015 at 9:06 pm

    Point taken

  8. Sachin Diwakar March 25, 2015 at 5:08 pm

    Hi Devesh,

    I am not sure if I can answer your questions. While hiring – everyone thinks of hiring the best resource.

    Thanks.

  9. Sachin Diwakar March 11, 2015 at 9:03 am

    You may follow us on twitter and Facebook.
    https://twitter.com/DBAThings
    https://www.facebook.com/dbathings

  10. Sachin Diwakar March 9, 2015 at 10:18 am

    Thanks for your inputs.

  11. Hi Shivam,

    Can you please let me know what exactly you are looking for other than below?

    mdf, ndf, ldf are the file extensions used for data and log files of a database. SQL Server holds exclusive lock on these files.

    We will try to create a write up on this topic.