SQL Learnings

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.

How to:

1. Truncate all the tables in a database

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.