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
Select row_number() over (order by OrderDate desc) as RowNum,
SalesOrderID, CustomerID, OrderDate
Order by OrderDate Desc
In the second example in 3.1.2
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