Reports for SQL Server 2008 System Data Collections

With SQL Server 2008's new Data Collection feature and the Management Data Warehouse (MDW), came three system Data Collection sets. This article covers the different data collection standard reports that have been provided to display information related to the statistics collected by the system data collections.

GIS and SQL Server 2008: Making Maps with your Data

When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what can you do with GIS Data? We asked an expert!

More New SQL Server 2008 Features

Microsoft updates SQL Server on a pretty regular basis. Its newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them

SQL Server 2008: The New Data Types

Brad continues his helicopter-level view of the most important new features of SQL Server 2008 with a look at the new data types, their use and their significance.

Filtered Indexes in SQL Server 2008

This article demonstrates the performance improvements that can be achieved using Filtered Indexes in SQL server 2008

Is It Worth Upgrading to SQL Server 2008

New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.

SQL Server 2008 SSMS Enhancements - Debugging Support

Continuing on with his series on SQL Server 2008, MVP Jacob Sebastian brings us a look at the debugger, which has returned in SQL Server 2008.

Extended Events

Data Access Tracing

Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine. You can also download associated sample code for this article.

Data Collector