Knowing the row number for a row in a result set has many uses. Paging through result sets is one example. In previous versions of SQL Server getting the row number for a result set was less than straightforward, using temporary tables or incremental counts based on a hopefully unique column were common solutions. SQL …

As well as the usual ever increasing list of "how to" or "what to" tech books that I try to read, I also like to read a bit about the history of Computing. It is always worth looking at the past as well as the future. Currently I am reading High Stakes, No Prisoners, which is about the very early …

Looks like the SQL Server 2005 samples, stuff like AdventureWorks etc., is now hosted on CodePlex. Link to notice on Microsoft.

Still recovering after a long day at DDD6. A good 19 hours from start to finish. Looking forward to DDD Scotland in May 2008, 100 is alot better than 300+ miles. This was probably the best DDD I have attended. I avoided the Silverlight XAMLy type talks as I had seen enough of that at Mix 07 and, judging by the number …