Posts

Showing posts from August, 2013

Query Azure WADLogsTable

Image
  When you have Azure WADLogTable loaded with tons of records, queries takes longer time to return results by using TimeStamp.   WADLog Table index by partition key and if I query by partition key I see logs are returning way faster. Partition key is datetime in ticks, you can get datetime in ticks by converting datetime string into ticks. I’m lazy to open VS just to get datetime in ticks and use LINQPad tool for these kind of quick conversions. It’s kind of opening notepad and writing C# statements. Code to get datetime in Ticks:   DateTime dt = new DateTime( 2013 , 08 , 29, 0,0,0 ); long l = dt.Ticks;  Console.WriteLine(l); //gives 635133312000000000   Once you have datetime string in ticks prefix 0 , use that value to query the table & you can start see logs immediately.   Query to Table – PartitionKey gt '0635133312000000000' If you want to see errors in log file use query with level = 2.  PartitionKey gt '06

How to do UnitTest (Database Test) SQL Server with Visual Studio 2012

http://msdn.microsoft.com/en-US/library/bb381703(v=VS.80).aspx http://sqlwithsanil.com/2012/07/08/database-unit-testing-made-easy-with-visual-studio-team-systems/ http://weblogs.asp.net/gunnarpeipman/archive/2013/02/07/using-database-unit-tests-in-visual-studio.aspx

Azure Scenario based examples

http://www.windowsazure.com/en-us/develop/net/end-to-end-Apps/