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.

Multi-Environment Deployments Using Team Edition for Database Professionals

In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.

SQL 2005: Enter XML

SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.