User Posts: Sachin Diwakar
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
4

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
10

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
6

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 ...

0
SQL DBA Cheatcode Part 3 : Few Important Queries for any DBA
2

In continuation of our DBA Cheatcode series :-   I started this series on Queries\T-SQL commands that we use in our day to day operations or those ...

0
10 Interesting things that ‘CAN NOT’ be done in SQL Server
0

I was just thinking about few interesting facts about SQL Server properties which are good to be known for a SQL Server DBA. You can not add data and log ...

0
How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?
0

How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

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
SQL DBA Cheatcode Part 2 : Few Important Queries for any DBA
0

Hi Friends, From last few days, I was thinking about writing a series on Queries\T-SQL commands that we use in our day to day operations or those queries ...

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
How to enable remote connection to SQL Instances from single SQL Server Management Studio?
0

Problem : All SQL Server Instances in the Environment are not able to connect from central SQL  Server management Studio. Resolution: Below steps need to be ...

0
SQL DBA Cheatcode Part 1 : Few Important Queries for any DBA
0

Hi Friends, From last few days, I was thinking about writing a series on Queries\T-SQL commands that we use in our day to day operations or those queries ...

0
How to get access on SQL Server if you don’t have “sa” password or sysadmin access?
0

PROBLEM DBAs need to have sysadmin access on SQL Server to support Databases effectively. There may come situations where DBAs neither have sysadmin access ...

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.