Troubleshooting SSPI handshake error

I have seen lots of questions floating in the msdn forums about SSPI Handshake error, the main question is around error code 0x80090311 which is indicative of the authentication failure error. Apart from this, there are many other reasons for SSPI Handshake error to appear in error logs. I cover them here.

Read More >

SQL Server 2012 Denali: Discussion On Usage Scenario for “Extended Events” (Part-1)

In this blog, I am going to demonstrate how we can use the wait event category sqlos.wait_info* to track the wait resources the queries running in a particular session undergo.

Read More >

SQL server: Denali now tunes out of the plan cache

If you ever used SQL server Database Engine Tuning Advisor then you know you have few options as a source of analysis workload, here they are.

Read More >

SQL server: Create missing indexes with unmessing names

If you do any performance tuning , and everyone does, then you’ll come to a point where you want to know if your tables have sufficient indexes to serve the queries fast, here’s how.

Read More >

In ‘Movember’, Mo Bros stand together to fight Prostate Cancer

The 60s are NOT back but during the month of November , some gents , including myself, will grow a stache to raise the awareness of prostate cancer, an insidious disease that afflicts one in seven males.

Read More >
Page 22 of 22« First Page...10...1819202122