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

.NET

    1. Introudcing Fluent ADO.NET

    2. Native JSON in IE8,Firefox 3.5 plus Json.net

ASP.NET

    1. 13 ASP.NET MVC extensibility points you have to know

Design Pattern

    1. Creating SOLID Code: Refactoring the SOLID episode on DI to use StructureMap

JQuery

    1. JQuery Search box and ASP.net MVC-Autocomplete jquery plug-in

SQL SERVER

    1. RANK() VS DENSE_RANK() With an Example using SQL SERVER2005/2008

    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

    1. 5 blogs every ASP.NET programmer Should know

    2. Software Startup Lesson- Being a software startup in a recession

March 14th-16th Links:ASP.NET Task,SOLID,Regular Experssion,ReSharper,SQL SERVER...

ASP.NET

    1. Scheduled ASP.NET Task Manager- Yoann.B 

    In this article,I'll take about scheduled Task Manager in a ASP.NET Environment.We often need to make scheduled tasks running in background but it's not very simple to make it with asp.net.I based my article on StackoverFlow article which uses ASP.NET Cache to schedule tasks.

C#

    1. Creating SOLID Code: Liskov Substitution Principle

    2. Regular Expressions in C#- Practical Usage

Continous Intergration,NAnt,NUnit,NCover

    1. Setting up Continuous Integration for your Application with Team City

    2. Building a Nant Script-Part1,Part2,Part3

    3. Creating an Automated Build for your Application

ReSharper

    1. Becoming a ReSharper Samurai-Part1,Part2,Part3

SQL SERVER

    1. Select Top n Rows From A Table For Each Group

     P.S. : Use ROW_NUMBER() clause and PARTITION BY clause

Other

    1. The Bare Minimum-(Project Manager)

    Regardless of which software development methodology and hierarchy(等级制度)you use,there's 1 core practice I think every team should use: estimation(估计) and tracking.

    What do you need to do?

    The first thing you need to break-down(分离) tasks and assign them to people.The next thing you need to do is put an estimate,in hours or days,on each task.This can either be done together by the team(preferred)or you can let each developer estimate his or her own tasks.

    All of these things can be done using a modern bug-tracker.We currently use Redmine.

    2. 6 Things Every ASP.NET Developers Should To Know by 2010

    1) MSBuild/NANT/Build Automation

    2) WCF,WPF and WF

    3) Silverlight and Expression

    4) JQuery

    5) W3C Design Compliance & "Table-less Design"

    6) AZure

    3.Developing With Source Code Control Best Practices Part1

    1) Never check in changes that can't be built.

    2) Check in related changes atomically.

    Atomically(原子性)means all related changes are checked in at the same time.

    3) Make use of shelving.

    4) Get All Current code and build before checking in.

    4. Developing with Source Code Control Best Practices Prat2

March 2th－6th Links:Design Patterns,Observer Pattern,Decorator Pattern

ASP.NET

    1. ASP.NET hang in IIS7.0

ASP.NET MVC

    1. ASP.NET MVC Domain Driven Design- Part1

c#

    1. String Concatenation made easy

    2. Snippet: Check for Internet Connectivity(c#)

    3. Back to Basics: Interfaces

    WHAT IS AN INTERFACE?

    Interface is a contract that implementer must follow.In other words,an interface says what class must defined.Importantly,an interface doesn't specify(or care) how the implemention is actually achieved. As we move forward we'll see how helpful this can be to us.

    An interface can define zero or more members(methods or propties) and a class can implement zero or more interface.Interface members always have public.An interface with zero member is called marker-interface,they don't require implementer to do anything.

    An raise exist of interface is to provide developers with a language-level tool that allows classes to be decoupled from each other.

    4. Creating SOLID Code : Open/Closed Principle(OCP)

    5. C# 4.0: Named Arguments

Design Patterns

    1. The Decorator Pattern

    The decorator pattern can be used to make it possible to extend (decorate) the functionality of a class at runtime.

    

Web

    1. JSONView: JSON browser from within Firefox

    2. YSlow and ASP.NET: 100 points "A" grade is possible

English

    1. legacy: 继承，遗产

    2. merciless: 殘忍的

    3. pair with: 搭配

    4. violation: 违反，违背

    5. proper: 适当的，正确的

    6. crucial: 关键的，决定性的

    7. snippet: 小片，片段

    8. badminton: 羽毛球

    9. decouple:

    10. overlap: 重叠

February 26th-27th Links:SQL SERVER,ASP.NET PERFORMANCE

C#

    1. Creating SOLID Code: Sigle Responsibility Principle- Episode-Codebetter.com 

ASP.NET

    1. 10 ASP.NET Performance And Scalability(可升级性) Secrets

    2. Some ASP.NET Optimizations And Best Practices-- Yoann.B

    3. Remove default HttpModules in ASP.NET

    4. Don't Run Production ASP.NET Apllications with debug='true' enabled- ScottGu

    5. ASP.NET Page Life Cycle Overview-Microsoft MSDN

    6. Send Mail With ASP.NET And Gmail

    7. Simple Mail Template Processing Implementation- Yoann.B

IIS

    1. IIS5,IIS6,IIS7 compare with process

SQL SERVER

    1. Find Relationship of Foreign Key and Private Key using T-SQL -pinaldave

    The query statement is related Table : sys.foreign_keys,sys.foreign_key_columns,sys.objects

    2. SQL SERVER Cheat Sheet-2008

    3. SQL SERVER Rules of Third Normal Form and Normalizatoin Advantage -3NF

    Third Normal Form(3NF) is most preferable normal form in RDBMS.Nomalization is the process of designing a data model to efficiently store data in database.The rules of 3NF are mentioned here:

    1) Make a sperate table for each set of related attributes, and give each table a privary key.

    2) If an attribute deponds on only part of a muil-valued key. remove it to a separate table.

    3) If an attribute don't contribute(有助) to a description of the key, remove it to a separate table.

    Normalization is very close to concept of Object Oriented schema's and it stores one data at only one place by removing all the redundant(多余的) data. Normalization comes at cost of performance.

    PS: 1NF: 数据库表中的字段都是单一属性，不可再分.

           attribute1   attribute2  attribute3(attribute3.1,attribute3.2...)

           2NF: 数据库表中不存在非键字段对任一候选关键字段的部分函数依赖.

           (studentId, courseName)->(studentName,age,grade,credits(学分))

           but

           (courseName)->(credits)

           (studentId)->(studentName,age)

           3NF: 数据表中不存在非关键字段对任一候选关键字段的传递函数依赖。

          (studentId)->(name,age,college,colleagePhone,colleageLocation)

   but

          (studentId)->(colleage)->(colleagePhone,colleageLocation)