Data Mining with Microsoft SQL Server 2008 - Sample Chapter

Another sample chapter from Wiley, this time for one of the hot topics in business intelligence: data mining.

Introducing SQL Server 2008 and 2008 R2 Integration Services

The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics.

Performance Analysis Using SQL Server 2008 Activity Monitor Tool

While looking through the new features and improvements in SQL Server 2008 Management Studio (SSMS) we found a potentially interesting one called Activity Monitor. Database developers and Database Administrators can use Activity Monitor to get a quick overview of an SQL Server 2008 system performance. Can you give us a detailed explanation of how we go about using Activity Monitor?

SQL Server 2008

SQL Server 2008 Backup

SQL Server 2008 Administration in Action - Sample Chapter

A sample chapter on clustering from Manning Publishing. Read it to learn a bit on clustering and preview this new book.

Installing SQL Server 2008

The installation process for SQL Server 2008 has many different options. These options allow you more control over your SQL Server Instance configuration. Having this additional control allows you to set up your SQL Server 2008 instances out of the box with the appropriate configuration, like directory structure, accounts, etc. In this article I'll walk you through the SQL Server installation process.

SQL Server 2008 Upgrade Gotchas & Fixes

Preparation for upgrading SQL Server 2005 production database servers to SQL Server 2008, I tested upgrade in dev/test env.

Using SQL Server 2008 Reporting Services with SAP NetWeaver Business Intelligence

This paper discusses the integration of SAP NetWeaver BI ® with Microsoft ® SQL Server ® 2008 Reporting Services (SSRS). The paper provides an overview of using the Reporting Services SAP Netweaver BI data provider and related query designer, to build high quality reports against SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you connect and build datasets. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.

Using SQL Server 2008 Change Data Capture

An introduction to this new feature in SQL Server 2008.