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.