RSS

SQL Learnings

20 Apr

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.

Advertisements
 
Leave a comment

Posted by on April 20, 2013 in Uncategorized

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: