RSS

Monthly Archives: April 2013

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.

 
Leave a comment

Posted by on April 20, 2013 in Uncategorized