February 20th Links:SQL SERVER,OAUTH

ASP.NET

1. Creating RSS using ASP.NET --Kevin Miller

     note: using system.ServiceMode.Syndication namespace (introduced in .NET3.5)

SQL Server

1 . SQL Server2005 Management Studio tips

   tip1: you can organize all your connects in amazing ways. To get the window just go to View-> Regisered Servers.

           tip2:if u don't remeber the query syntax.E.g. adding a new column,inser script etc.SQL Server has a feature called Template Explorer(Hit CTRL+ALT+T).

2. SQL Server 2008 interview Questions and Answer -PDF Download --(有墙)pinaldave 

VSTS2008,Test

1. Top 10 Favorite Performance Counter in Web Site Load Testing Using VSTS 2008

     note : there are four parameters that are categorized as Request,Pages,Tests,Error

1) Request : 

Avg Req/Sec(high),Avg Req Passed/Sec(high)

2) Page:

Avg Page Time/Sec(low)

3) Test:

Total Test(high)

4) Scenaro - User Load(high)

5) Errors - Errors/sec(low)

6) Processor - %Processor Time(low)

7) Memory - Available Mbytes(high)

9) Physical Disk - Crrent Disk Queue Length(low)

10) Network interface - output Queue Lenght(low)

2. Measure Your Database Table Schema Synchronization Safety While Using VSTS 2008

OAUTH

1. OAUTH无痛入门指南

2. OAUTH on asp.net mvc projects