Find Login in Active Directory

Find Login in AD

Many times we require to know if particular login is a part of ad user group. Or...

When Date Modified changes for Sql mdf/ldf files

*This is related to physical file size of a MDF or LDF file not internal allocation.
One of our user asked...

Good Bye 2011

Good Bye 2011

Hey there, this year is going to an end and just want to recall what all happened this...

Basics QA on Extended Event

Basics QA on Extended Event

 
 
I am learning Extended Event so this is my first blog on extended event, There is...

Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to...

spid in Killed/Rollback cannot kill

We come across a situation where we have to kill one spid which was running for quite some time, so...

Download: Troubleshooting a day – Nov 2011

As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here....

Day 30: More Fatal Errors and BUGs

Day 30 More Fatal Errors and BUGs
For sql server 2000 and earlier you may get 5242 and 5243 corruption in...

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Error 823: IO error OS cannot read the data
Error: 823,...