How many of you have written resursive queries in SQL? Or any language since school for that matter? Not many people write recusrive queries because of the complexity, the difficulty to understand how they work, and the chance for heap overflows. However, SQL Server 2005 implements Common Table Expressions and recursion in a way that is much easier to code and incorporates some safeguards. New author SQL Server MVP Frederic Brouard has written a fantastic article looking at resursive queries.

SQL Server T-SQL in 10 Minutes

by Steve Jones

SQLServerCentral.com

Book Reviews

A short review of this book by Ben Forta giving you the basics of T-SQL

Row Value Constructor in SQL Server 2008

by Additional Articles

Database Journal

SQL Server 2008

This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.

The Database Weekly Update for May 19. 2008

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Steve Jones looks at the performance of column changes, petaflop computing, and a few ways to beef up your DBA skills.

Using Policy-Based Management in SQL Server 2008

by Additional Articles

MSSQLTips.com

Policy Based Management (PBM)

As we are reviewing the new features in SQL Server 2008, we found one that looks really interesting - Policy-Based Management. Could you help us to understand how this works and provide some examples? Can you please explain each of the components and how to manage them in the interface and with commands?

IT and Musicians?

by Ted-Manasa

SQLServerCentral.com

Editorial

Are IT people wired for musicianship?

What Makes a Good Programmer

by Janet Wong

SQLServerCentral.com

State of the Business

Are top notch programming skills innate or can they be learned? Janet Wong takes a look at the skills and capabilities of great programmers in this essay.