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 ...

The MVP authored book, SQL Server MVP Deep Dives is now available for early access and pre-orders at http://manning.com/nielsen/. The book is divided into 5 sections that cover everything from building a proper relational database to developing BI solutions:
1. Database Design and Architecture 2. Database Development 3. Database ...

Red Gate just published a new free e-book in their High Performance SQL Server series. The book is SQL Server Tacklebox: Essential Tools and Scripts for the Day to Day DBA by Rodney Landrum. Rodney is a professional DBA by trade, an author by choice, and a SQL Server MVP. With the SQL Server Tacklebox Rodney demonstrates dozens of ...