Katmai Delayed

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

Featured Blog: SQL Server 2008: Spatial indexes

Paul Randal talks about the new spatial data types and their indexes.

New datetime datatypes in SQL Server 2008

Older versions of SQL Server had only one datatype to store both the date and time values. In SQL Server 2008, Microsoft introduces a set of new datatypes that store date and time individually, and both date and time together.

Hot Add CPU - Prerequisites

Installing SQL Server 2008

This article highlights the steps involved to install SQL Server 2008.

SQL Server 2008 New DATETIME DataTypes

SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.

Declarative Management Framework - Performing Policy Management

The Declarative Management Framework is a new policy based management framework included with the upcoming SQL Server 2008. Using this feature administrators can define policies to govern their SQL Server environments much like in the Windows environment. This article, written based on the SQL Server "Katmai" July CTP introduces you to the DMF and shows you how you can perform policy management.

Passing table valued parameters in SQL Server 2008

I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.

Using SQL Server 2008's MERGE statement

SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement.