billy-yons and billy-yons of rows

Display Complex Hierarchical Data with Server-Side Pagination

This article presents an approach to perform server-side pagination and display complex hierarchical data in Reporting Services.

Installing SQL Server 2008R2 on a Windows 2008R2 Core Server

This article will show you how to install SQL Server on to a Windows Core Server host.

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task

The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.

Understanding Utility Control Point (UCP) in SQL Server 2008 R2

As your business grows, the number of applications grows as well, as do the SQL Server instances to support these applications. As a SQL DBA, you need to have a multi-server management dashboard that proactively tells you about the resource utilization on each SQL Server instance.

Guide To MCITP: SQL Server 2008 Administration

Find out what you need to learn for the SQL Server 2008 Administration certification exams.

SSRS 2008 R2 KPIs with bullet graphs

Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two different fields as well as see the status of the KPI in red, amber or green color. If the user wants to figure out the thresholds associated with the KPI, these values are generally not visible. Further, representing the threshold values in the scorecard itself defeats the purpose of the scorecard. The scorecard should display the KPI's status in the most summarized form and use a minimal amount of space on the dashboard. In this tip we would look at how to address this issue.

SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available

You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.

SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task

Marcin Policht discusses ways to launch processes for remote systems using SQL Server 2008 R2 Integration Services.

SQL Server 2008 R2 Features