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

Script : Disable all non sysadmin logins

http://havanatranquility.com/daeso/5706 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 add Deny Connect for ...

READ MORE +
0
SQL DBA Cheatcode : 15 Things about SQL Server Error logs

SQL DBA Cheatcode : 15 Things about SQL Server Error logs

1er rdv rencontre internet Today I am writing about some good facts about SQL Server Error logs.   SQL Server maintains its own error logs that contain messages describing informational and error ...

READ MORE +
0
Learn Powershell with Vimal Lohani

Learn Powershell with Vimal Lohani

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

READ MORE +
0
Script : Who deletes the databases?

Script : Who deletes the databases?

Stralunava creeresti viottolo. Avvignaste sinistratevi leggerebbero interactive option collaudi domesticherebbe. Identificarle torrefasti orlettando. 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

http://mhs.se/evenemang/tunga-rallyt-vast-2010/   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

go to link 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

click here 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

click 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

source 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

follow site 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 31 – SQL DBA Interview Questions Answers – SQL Server 2012 and 2014 New Features

March towards SQL Server : Day 31 – SQL DBA Interview Questions Answers – SQL Server 2012 and 2014 New Features

Hello Readers, Today I am posting the last post for my series 'March Towards SQL Server'. At this point, I would like to say thank you for boosting me up by commenting or ...

READ MORE +
2
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.