Deadlock information from "system health" extended events

In SQL 2012 and above versions we can reterive deadlock information without enabling trace flags. Steps as below.

1) Go to Management -> Extended Events -> Sessions -> system_health

2) Right click on “package0.event_file”

3) Select “View Target Data..”

4) Click on “Filters” from task bar as below

5) Apply filter on Name field with “xml_deadlock_report”

6) Select on any deadlock based on timestamp, select deadlock tab for more info.

Fixing an SSRS Password Error while Changing Credentials

While applying the domain accounts suddenly an error arose.

“The password is not valid. Please retype the password”,

This appeared whenever a domain account name was entered in user name field. I tried the other options to reset the error and allow me to test the connection but was repeatedly prompted for credentials with the same error even if the correct credentials are entered.

Refer my post below for more details

http://www.sqlservercentral.com/articles/SSRS/155071/