Using Included Columns in SQL Server 2005

One of the new features found in SQL Server 2005 is the ability to add additional columns, called Included Columns, to a non-clustered index. This article will explain the advantages of using included columns and what impact they will have on your database.

Tell Me What You Need - iPod

Ever worked on a software project where you didn't get all the requirements? One where the functions and features change in midstream? Steve Jones comments on some possibilities on why this happens.

Tell Me What You Need - MP3

Ever worked on a software project where you didn't get all the requirements? One where the functions and features change in midstream? Steve Jones comments on some possibilities on why this happens.

Tell Me What You Need - WMV

A Lack of Data Quality

This Friday's poll examines a situation straight out of Office Space.

Katmai Delayed

SQL Server 2008, Katmai, apparently won't ship in Q2. Looks like a Q3 possibility now.

NULL Versus NULL?

Dealing with NULL data is something that often confuses new SQL Server developers, but even experienced DBAs might not understand all the intricacies of NULL operations. In a follow up to his highly acclaimed Four Rules of Null article, Michael Coles brings us a few new
tricks with NULLs.

The CLR in SQL Server 2005

Updated: Jan 2008. One of the big changes in SQL Server 2005 is the integration of the CLR into the relational engine itself. This is probably the biggest reason for the delays in completing the product and it is a controversial decision. Steve Jones spends a few minutes looking at the pros and cons of having the CLR integrated and possible implications for DBAs.

Data Quality Solutions

This white paper describes how application developers can incorporate data quality into their Microsoft SQL Server 2005 Integration Services solutions.

Microsoft SQL Server 2008 - Change Data Capture – Part I

Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to keep track of Data Definition Language changes on a table.