Why I Train

It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings from former participants who have taken the time to get back to me I have mentioned one such email below. Hi Jayanth,  This is Raja from Cognizant…

Kyu and A?

Hi Jayanth, QUESTIONHope you are doing good.My question is :Is there a way 2 select from tables with no timeout when u r inserting data into them via BCP/bulk insert with tablock? does nolock work on select statement tables works?   ANSWER yes, it’s called optimistic concurrency. If you enabled the above feature you will…

A new video on DB mirroring

Well it’s not new exactly it was created many years back and I somehow never uploaded it. Yesterday a former client came back asking about DB mirroring and I realized that there was a video that I should upload. So here it is. https://www.youtube.com/watch?v=unufO3gBXVg Think of this video as the last hurrah to DB mirroring…