Everything SQL related and then some
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…
At a training recently I was explaining how to do as well as prevent SQL injection and figured I should make a blog about it since very few DBA and developers understand it. Some of it has to do with the fact that we all test for functionality and performance and the rest as to…
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 get…
Those who know me also know I am an ardent supporter of Microsoft. These guys came up with Mobile OS, tablets, MP3 players and much more; long before they became coveted items of self-indulgence. But one thing Microsoft has also been able to do is take a seemingly bright idea and then turn it into…
Back in Hyderabad for one of my favourite clients and trainings. Got a ton of new stuff in MSBI I want to train on.
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…
In this blog we are going to look at how to configure Email subscriptions in SSRS. Subscriptions like its names suggests is a way for the user to be able to get alerts or subscribe to a particular report , somewhat similar to the way they can subscribe to and RSS Feed. The idea being…