2009年4月11日星期六

April 12th-13th Links:SOLID,ASP.NET MVC,SQL SERVER

.NET

ASP.NET

Design Pattern

JQuery

SQL SERVER
    The RANK() Function in SQL SERVER returns the position of a value within the partition of a result set, with gaps in the ranking where there are ties.
    The DENSE_RANK() function in SQL Server returns the position of a value within the partition of a result set,leaving no gaps in the ranking where there are ties.

Other

2009年4月10日星期五

April 10th-11th Links:Velocity,C#,SQL SERVER,ReSharper

.NET
    How to optimize passing complex data to the server

ASP.NET
    1) Favicon
    2) Titles And Meta Data
    Your page title is more important element for SEO and is also important so that users know what's on the page.Make sure it changes on every page and relate to that page's content.
    3) Cross-Bowser Checks
    4) Proofread
    5) Links
    6) Graceful Degradation
    7) Validation
    8) RSS Link
    The common conversion is to put a small RSS icon in the browser's address bar.
    9) Analytics
    10) Sitemap
    Adding a sitemap.xml file to your root directory allows the major search engines to easily index your website
    11) Defensive Design
    The most commonly overlooked defensive design element is the 404 page.
    12) Optimize

C#

Javascript

Velocity
    1) High Availability
    2) Notifications
    3) Local Caching
    4) Management & Monitoriting
    5) Better Integration

WEB

IE
    1) IE8 Opens More Connections Per Host Name
    2) IE8 Has a New Process Model
    3) All IE8 Tabls,Window and Pop-ups Belong To Same Browser Session
    4) The IE8 Process Model is Configurable
    5) Compatibility Workarounds for IE8
    6) New Built-in Developer Tools For IE9
    7) How to Use HttpWatch with IE8

ReSharper

SQL SERVER
    1. Logical Query Processing Phases- Order of Statement Excution
    1) FROM -> ON -> OUTER -> WHERE -> GROUP BY-> CUBE|ROLLUP->HAVING->SELECT->DISTINCT->ORDER BY->TOP

Other
    neXpert is an add-on to Fiddler which automates the classic performance best practice checks and produces a HTML report on the issues found in a Fiddler capture.
    3.4 Great Tools to use visual Studio

2009年4月2日星期四

April 1th Links:JQuery,TFS,VSS,Silverlight,SQL SERVER

JQuery
    Lazy loading is a well-known design pattern that is intended to prevent redundant processing within your application.

SQL SERVER

Silverlight

Other
    This chapter explains the fundamental difference between Visual Source Safe(VSS) and VSTS Team Foundation.

2009年3月26日星期四

March 27th Links:ASP.NET,JAVASCRIPT,C# Using,Delegate,SQL SERVER

ASP.NET
    where compilation seems to mysteriously( 不可思议的) pause for 30+ seconds(or even minutes),before continuing each time you do a build or F5 of the project.VS2005 Web Sites will copy the assembly picked into the \bin directory of the project as well as(by default) add a .refresh file into the \bin directory that contains a relative path string that points back to the original assembly path location.When you build the solution,VS will automactically check those assembiles with .refresh files to see if a newer version of the assembly is available,and if so automatically re-copy the assembly and re-compile the solution using it.
    1) So Which Project Option Builds Faster?
    When doing full builds of projects,the VS2005 web application project options will complie projects much faster that the vs2005 web site

C#

JAVASCRIPT

SQL SERVER

.NET Framework

Other

English
    1. fledged: 成熟的
    2. unobtrusive: 不打扰的
    3. scratch the surface: 冰山一角

2009年3月25日星期三

March 25th-26th Links: C#,Silverlight,Effective Web Developer,HTML Editor

ASP.NET

C#
    Definition: Extension Methods allows us to define new methods on existing types,which can be either .NET type or use defined class.We can define new methods without extending or deriving existing type.
    Restrictions: If there is an already existing method with same signature as extentsion method in a type. Than, extension method will be ignored and never called.Fist,it looks for inbuilt method.if it won't find a match,it will look for extension method.if it is not there,it will throw an error.

Javascript

JQuery

Silverlight

Other
    ASP.NET
    IDE: Visual Studio 2008 Express
    Unit Testing: NUnit
    Mocking: Rhino Mocks
    ORM: NHibernate
    MVC: ASP.NET MVC
    Javascript: JQuery

2009年3月21日星期六

March 22th-23th Links: .NET Framework,Silverlight,SQL Server

1. .NET
    3) What is .NET RIA Services?

2. Silverlight
    Here's the source to the WriteableBitmap sample I showed at Mix.The sample uses WriteableBitmap to take a "snapshot" of the running video to make a thumbnail

3. SQL Server
    1) Index Maintenance 
    if your indexes are less than 30% fragmented(碎片) than you can run a DBCC INDEXDEFRAG else rebuild.

English
    1. Resemble:相似,像
    2. Encounter:遇到,偶遇
    3. Revealed:透露,显示
    4. overlap: 重复,重叠
    5. rectangle: 长方形,矩形
    6. ellipse: 椭圆
    7. replicate: 折叠,复制