Management studio/Visual studio will take care all, if need third party tools, can use Redgate,Idera, foglight.

Thank you Dev_. Where do I find SQL server Audit/Trace/History/Log etc.

Management studio—u can get it all.Are u started learning Sql for new it career ?If yes don’t do it, market is tough, few of my friends in bench for 6+ months.

In the generation of No Sql u r doing sql. Learn redshift and dynamo dB

Dev How do you know the market is tough? Why are you discouraging people who is willing to learn something? There is nothing wrong learning SQL. Probably your friend isn't smart enough to get the job.

Thanks all.