User Posts: Sachin Diwakar
Script : Disable all non sysadmin logins

Hello Reader, I am sharing a quick script to disable all non sysadmin logins for SQL Server. You can not disable windows groups so I tweaked this script to ...

SQL DBA Cheatcode : 15 Things about SQL Server Error logs

Today I am writing about some good facts about SQL Server Error logs.   SQL Server maintains its own error logs that contain messages describing ...

Learn Powershell with Vimal Lohani

Vimal Lohani sharing his knowledge and experience of Powershell in an exclusive series "Introduction to Windows PowerShell" SN Topic Description ...

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

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

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?

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


  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.


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

    You may follow us on twitter and Facebook.

  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.