Mar 052013
 
Understanding, Analysing and Troubleshooting Deadlocks – Part3

In First Part Understanding, Analysing and Troubleshooting Deadlocks – Part1 we discussed what is Deadlock, How SQL Server engine behaves when a deadlock is encountered, how a victim is identified and why deadlocks occurs etc. In Second Part Understanding, Analysing and Troubleshooting Deadlocks – Part2 we discussed how to get Deadlock Graph from Error Log [Read More]

Feb 262013
 
Understanding, Analysing and Troubleshooting Deadlocks – Part2

In First Part Understanding, Analysing and Troubleshooting Deadlocks – Part1 we discussed what is Deadlock, How SQL Server engine behaves when a deadlock is encountered, how a victim is identified and why deadlocks occurs etc. After reading the error message people often think that either this is the only information SQL Server has for the [Read More]

Feb 122013
 
SQL Server Day | Gurgaon | 16-Feb-2013

SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this time we are coming again to Gurgaon. We bring you rock star speakers and panelists from the MVP community & Microsoft. This is yet another opportunity to learn maximum from SQLServerGeeks.com across India. There will be [Read More]

Feb 062013
 
Understanding, Analysing and Troubleshooting Deadlocks – Part1

A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock. In simple language, Deadlock is a situation when two or more processes are waiting to acquire lock on resource(s) which are already blocked by opposite participant [Read More]

Jan 172013
 
Learn SQL Server User Impersonation

As discussed in earlier Login Impersonation Blog Technically SQL Server and windows both can be configured to authenticate to another SQL instance\Windows Server against the current login account, this behavior is known as Impersonation. When one login\user acts on behalf of another login\user this behavior is also known as impersonation. Database Level We can easily [Read More]

Jan 162013
 
Learn SQL Server Login Impersonation

Technically SQL Server and windows both can be configured to authenticate to another SQL instance\Windows Server against the current login account, this behavior is known as Impersonation. When one login\user acts on behalf of another login\user this behavior is also known as impersonation. Server Level We can easily impersonate a session by explicitly mentioning a [Read More]

Dec 192012
 
Blessed with a Baby Girl

Hi Friends, If you are following me or my activities you might have missed me for last couple of weeks, I was actually busy with my family and now since everything is normal I want to share a good news. We have been blessed with a beautiful baby girl on 4th of Dec-2012. It was [Read More]

Nov 132012
 
Happy Diwali - Say no to Crackers

Hi Friends, A Very Happy Diwali To You & Your Family May God Give You All That You Want & Need In Your Life. Enjoy The Festival With Lots Of Light. And Say NO to Crackers. With the evolution of the lifestyle, there has been certain change in the way people celebrate Diwali, as more [Read More]