Sachin Diwakar | DBA THINGS - Part 37
User Posts: Sachin Diwakar
0
March towards SQL Server : Day 13 – SQL DBA Interview Questions Answers – Database Backups and Restore-4
1

http://liveforyounow.com/blog/the-benefits-of-vitamin-b/?replytǚ,_474,_respond,_521_) Here I am posting fourth and last series of Backup/Restore interview questions. I am trying to cover most of the known errors and some concepts too. You ...

0
March towards SQL Server : Day 12 – SQL DBA Interview Questions Answers – Database Backups and Restore-3
0

see url Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Day 10 and Day 11 1) What is the ...

0
March towards SQL Server : Day 11 – SQL DBA Interview Questions Answers – Database Backups and Restore-2
0

  Continuing my Blog series on the Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to ...

0
March towards SQL Server : Day 10 – SQL DBA Interview Questions Answers – Database Backups and Restore-1
1

  This blog contains series of most commonly asked Interview Questions regarding one of the important DBA tasks- Database Backups and Restore. ...

0
March towards SQL Server : Day 9 – SQL DBA Interview Questions Answers – All about SQL Server System Databases and Recovery Model
1

This blog is about the interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are ...

0
March towards SQL Server : Day 8 – SQL DBA Interview Questions Answers – All about SQL Server Tools and Executables
0

This blog is all about the SQL Server related tools and executables which are used by all level of DBAs for various tasks. 1) What is SSMS? SSMS stands ...

0
March towards SQL Server : Day 7 – SQL DBA Interview Questions Answers – All about SQL Server Agent and Its Components
0

This blog contains Question answers about the most frequently used tool by a Database Administrator i.e. SQL Server Agent. I tried to cover all the questions ...

0
March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services
0

This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about ...

0
March towards SQL Server : Day 5 – SQL DBA Interview Questions Answers – Data File and Transaction Log File Architecture
0

This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not ...

0
March towards SQL Server : Day 4 – SQL DBA Interview Questions Answers – Database Architecture and Database Properties
0

This article comprises of Questions answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, ...

0
March towards SQL Server : Day 3 – SQL DBA Interview Questions Answers – SQL Server Architecture
0

I am writing this blog based upon the Experience and knowledge which I gained after reading lot of Articles, Blogs, and Microsoft Documentation on SQL Server ...

0
March towards SQL Server : Day 2 – SQL DBA Interview Questions Answers – Security Permissions
0

1) What is Authentication and Authorization? What is the difference between both? Authentication is the process of verifying who you are. Logging on to a ...

0
March towards SQL Server : Interview Question & Answer series
7

March towards SQL Server. This is a series of interview questions & answers on a new topic every day for SQL DBAs. Special thanks to Parvinder Pal for ...

0
March towards SQL Server : Day 1 – SQL DBA Interview Questions Answers – Installation
3

I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. I have planned to segregate the ...

0
SQL DBA Training Session 5 : SQL Server Cluster
0

Here comes another free training session on 'Setting up cluster on SQL Server 2012 version' This training is different from our other trainings that we ...

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.