User Posts: Sachin Diwakar
Script : Who deletes the databases?

Script : Who deletes the databases?

Hello Readers, Before starting, let me give you some background about this problem. I used to support few servers which had more than 1000 small databases. Worst part was that ...

READ MORE +
0
Series : Versus

Series : Versus

  Our Versus Series is a comparsion series of blogs. Here, we will try to compare one concept with another or one feature with another. SN Date Topic  1 ...

READ MORE +
0
CAST vs. CONVERT

CAST vs. CONVERT

Datatype conversion is a common scenario that we face while writing SQL queries. Cast and Convert are two functions provided by SQL for this purpose. But what is the difference ...

READ MORE +
0
Series : SQL DBA Cheatcode

Series : SQL DBA Cheatcode

SQL DBA Cheatcode is a series or you can say a collection of those SQL Server scripts which we find very useful while troubleshooting issues day to day. These scripts are ...

READ MORE +
0
SQL DBA Cheatcode Part 6 : Know your SQL Server

SQL DBA Cheatcode Part 6 : Know your SQL Server

Hello Readers, I am here adding few more feathers to our SQL DBA Cheatcode series hat. If you have not read our others blogs of this series, you may do it by clicking the links ...

READ MORE +
0
SQL DBA Cheatcode Part 5 : Playing with indexes

SQL DBA Cheatcode Part 5 : Playing with indexes

Hello Readers, Today, I am trying to put down few but very useful index related scripts. I have used these scripts many times with different versions of SQL Server. 1. ...

READ MORE +
0
Misleading Message:  DBCC execution completed. If DBCC printed error messages, contact your system administrator

Misleading Message: DBCC execution completed. If DBCC printed error messages, contact your system administrator

Hello Reader, Recently, it was encountered that one of the jobs which was running fine since ages has started failing with below error message. Message : Executed as user: ...

READ MORE +
0
System Databases : Restrictions Matrix

System Databases : Restrictions Matrix

Dear Readers, Today, I tried to consolidate a list of restrictions that are applied to system databases. Restrictions are nothing but the operations that you "can not" perform ...

READ MORE +
0
Question : Who is a DBA?

Question : Who is a DBA?

This post is targeted for those who are keen or new to DBA profession. Based on my experience I tried to write about DBAs and Possible career paths related to it. Who is a ...

READ MORE +
0
Script : How to find SQL Server orphan Logins?

Script : How to find SQL Server orphan Logins?

Dear Readers, An attempt has been made to write a short script to find out SQL Server Orphan Logins. By the way, I am not sure if Microsoft has any term like "Orphan Login" ...

READ MORE +
0
Script : Who all have access to SQL Server via AD Groups?

Script : Who all have access to SQL Server via AD Groups?

Dear Reader, Few days ago, I was looking for a script to find out who all have access to SQL Server via AD Groups. There are a couple of good scripts available for this ...

READ MORE +
0
March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

Lets talk about Traces and System procedures that are very useful for a DBA Routine. Interview Questions on Trace Flags What are trace flags? Trace flags are used ...

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

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

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

READ MORE +
0
March towards SQL Server : Day 23 – SQL DBA Interview Questions Answers – SQL Server performance Tuning

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

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

READ MORE +
0
March towards SQL Server : Interview Question & Answer series

March towards SQL Server : Interview Question & Answer series

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 his enormous efforts ...

READ MORE +
5
Browsing All Comments By: Sachin Diwakar
  1. Sachin Diwakar December 10, 2014 at 10:17 pm

    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. Sachin Diwakar December 10, 2014 at 10:20 pm

    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. Sachin Diwakar April 24, 2015 at 12:57 pm

    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. Sachin Diwakar February 23, 2015 at 2:47 pm

    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.