A new feature for SQL Server? Steve Jones talks about a very interesting job posting from Microsoft.

XML Workshop I - Generating XML output using FOR XML with AUTO and RAW

by Jacob Sebastian

SQLServerCentral.com

Quickly becoming the SQL Server XML expert, Jacob Sebastion brings us a great new article that expands upon his very popular series on XML in SQL Server. This time he examines the FOR XML PATH option, which provides additional formatting capabilities.

Dependency Tracking in SQL Server 2008

by Additional Articles

SQL Community

SQL Server 2008

People reading this post might really wonder of having read /heard about a concept on Dependency tracking in SQL Server 2008. It is nothing, but a set of built in existing SYS objects and their effective usage that help us save time & tedious efforts.

Execution Plan Basics

by Additional Articles

SimpleTalk

Performance Tuning

Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? We are very pleased to be allowed to publish the first chapter of Grant Fritchey's excellent new book on execution plans.

SSIS Is Not Just for SQL Server

by Tim Mitchell

SQLServerCentral.com

Integration Services (SSIS)

SQL Server Integration Services is an incredibly rich and complex development environment that can handle almost any data movement task. Even those that do not involve SQL Server. Longtime author Tim Mitchell brings us a use that has nothing to do with SQL Server, but can be very handy for many of us.