Working with SQL and SQL Azure
Last couple of weeks I have been working on stored procedures and analyzing performances in SQL. I have been going through some interesting readings. Would like to share some of my learnings here. This would be updated on a regular basis.
Some of the key sites :
1. http://weblogs.sqlteam.com/ – This is a very good site which helped me in understanding various lock/synchorinization related things in SQL. The author is also very responsive.
2. http://blogs.msdn.com/b/benko/archive/2012/05/19/cloudtip-14-how-do-i-get-sql-profiler-info-from-sql-azure.aspx – To get SQL Profiler information from SQL Azure. Amazed to find this feature in Azure.
2. Tips & Tricks: YOU HAVE LOST ACCESS TO SQL SERVER. NOW WHAT?
Let me know if you have good references in the domain that would be of good help to me and readers.