Moving to SQL-Articles.com

After a long I have decided to move to SQL-Articles.com main website itself instead of having another blog for me. Main website is also owned by me however Sugesh, Deepak , Lexx will also be posting their article.  I posted my articles in SQL-Articles.com main website and also in this blog. Right now I decided not to duplicate my efforts in both the websites, so I planned to start posting my articles only in main website. You can subscribe to that RSS feed there which will also provide you the articles posted by my friends which will help you to learn much more. Read more »

VN:F [1.9.17_1161]
Rating: 3.0/5 (2 votes cast)
VN:F [1.9.17_1161]
Rating: +1 (from 3 votes)

What happens when permission is revoked in middle of work?

This is one of the question asked by my friend and it seems very simple. I had a discussion with him and said that whatever the transaction it has started it will succeeded, however what I told him is not correct. I told him I’ll test it out and the answer which I gave it to him is partially correct. If the transaction gets completed with in begin tran (before commit or rollback) you can close the transaction even if the permission is revoked however if the transaction is not completed within begin tran then it will fail stating that the user don’t have access. Read more »

VN:F [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

What’s happening in Chennai this June?

Does the title make you to think what’s gonna happen. It’s all related to technical so don’t go out of scope :-) . Coming 18th we have Community Tech days going to happen in Chennai. This time we have 5 sessions and all the 5 sessions are taken by Microsoft speakers itself. Read more »

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

Tech-Ed India 2011

I know this is too late to give a write up on what I learn and enjoyed at Tech-Ed 2011. Tech-Ed is one of the technical education and networking place where lots and lots of technical stuffs are running around everywhere. If you have lots of thirst on technical on Microsoft products, you can enter into any of the session and learn it.

Read more »

VN:F [1.9.17_1161]
Rating: 3.7/5 (3 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 2 votes)

Troubleshoot backup \ restore issues with trace flag 3004

I faced an issue during restoration of very large db in our development database \ server. Issue is restoration takes very long time even though we had latest hardware and recent version of SQL Server (it’s SQL 2008 Ent. Ed). So to troubleshoot it I have used the trace flag 3004 which print all internal things happen during backup and restoration operation.

Read more »

VN:F [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)