Excellent Article with a good overview of develoment features.

I somewhat aggree with Alan too: the examples have typos unless the author did modify his AdventureWorks database.

In the first example in 3.1.1

Select row_number() over (order by SalesOrderDate desc) as RowNum,OrderID, CustomerID, SalesOrderDateFrom Sales.OrderHeaderOrder by SalesOrderDate Desc

Should read:

Select

row_number() over (order by OrderDate desc) as RowNum,

SalesOrderID

, CustomerID, OrderDate

From

Sales.SalesOrderHeader

Order

by OrderDate Desc

In the second example in 3.1.2

State.StateProvinceID

should read

StateProv.StateProvinceID

Since I made a mistake myself trying to point to the mistakes in the second example  I guess it is not the author's fault that the names are complex