Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements.  Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are.  They simplify code and can improve performance ...

I just got tagged by my old friend Jacob Sebastian at Beyond Relational, and it turns out it's my turn to explain how I became such a geek :) Way back in the day I got my start on the TRS-80 Model III (affectionately known as the ''Trash-80s''), a nice little Z-80 based desktop computer with an 80x25 monochrome screen and a whopping ...

SQL Server MVP Jacob Sebastian's new e-book, The Art of XSD, is available as a free download from Red Gate software at http://www.red-gate.com/specials/Ebooks/XSD_0409.htm. You may reognize Jacob from his many XML-related articles on SQL Server Central (http://www.sqlservercentral.com/Authors/Articles/Jacob_Sebastian/212008/). This book allows him ...