User Posts: Sachin Diwakar
0
March towards SQL Server : Day 27 – SQL DBA Interview Questions Answers – All About Indexes
0

Lets not forget to talk about our 'best friend' for performance - Indexes. I know this is redundent information but the whole idea is to collect everything ...

0
March towards SQL Server : Day 26 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 4
0

Here I am posting final post on SQL Server Performance Tuning concepts. I hope you must have read our previous posts on Performance Tuning. If not, have a ...

0
March towards SQL Server : Day 25 – SQL DBA Interview Questions Answers – SQL Server Performance Tuning – 3
0

Here goes another post on Performance Tuning concepts. You may want to take a quick look at previous post on this topic. Performance Tuning Part 1 ...

0
March towards SQL Server : Day 24 – SQL DBA Interview Questions Answers – SQL Server performance Tuning – 2
0

Dear Readers,   In this blog, I am taking a different approach. It’s very common that interviewer promptly asks another question from your ...

0
March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning
1

Dear Reader, Today, I thought of writing interview questions on SQL Server Performance Tuning. I tried my best to touch upon many areas however ...

0
March towards SQL Server : Day 22 – SQL DBA Interview Questions Answers – REPLICATION Part II
0

Readers,   Replication is a vast topic and there are many questions and scenario based issues which a DBA can face. So, today's series of Interview ...

0
March towards SQL Server : Day 21 – SQL DBA Interview Questions Answers – REPLICATION
0

Dear Readers, Now as we have already crossed two third of the month and covered a lot of topics till date, Now lets get a deep insight about another very ...

0
March towards SQL Server : Day 20 – SQL DBA Interview Questions Answers – Always ON – 2
1

I hope you enjoyed my last post on Always On. Here goes the final post on Always On feature.   What is availability group wizard? Availability ...

0
March towards SQL Server : Day 19 – SQL DBA Interview Questions Answers – Always ON
0

After completing successful 18 Day – here comes the most awaiting and demanding series of interview questions and answers on Always On Feature. 1. What is ...

0
March towards SQL Server : Day 18 – SQL DBA Interview Questions Answers – SQL Server Cluster -2
1

If you have enjoyed reading Day 17 Questions about Cluster. Here is another post on SQL Cluster services and on its components and features.   ...

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

Today I am writing a Blog Series on one of my Favorite topic – SQL Server Cluster.  This will include all the possible Questionnaire which are asked in the ...

0
March towards SQL Server : Day 16 – SQL DBA Interview Questions Answers – Database Mirroring – 2
0

  Continuing with my previous post of Interview Questions series on Database Mirroring, this is the second blog on Database Mirroring. 1) What ...

0
March towards SQL Server : Day 15 – SQL DBA Interview Questions Answers – Database Mirroring – 1
0

Next topic to High availability Questions Answers series is about Database Mirroring. This is very interesting topic and consists of very wide range of ...

0
March towards SQL Server : Day 14 – SQL DBA Interview Questions Answers – Log Shipping
0

This blog is about one of the High Availability feature supported by Microsoft SQL Server- Log Shipping. What is High Availability in SQL Server? A ...

0
Database Permissions extraction script
0

Dear DBAs, Few days back one of my junior colleague reported me that while performing database refresh, he extracted the permissions of database before ...

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.