Reporting Services 2005 101 with a Smart Client

Are you interested in a raise? Asif Sayed got one from a well written report. This time he brings us a beginners' looks at Reporting Services 2005 using a smart client for testing.

Top 10 Enhancements in SQL 2005 Notification Services

In this article, we examine some of the best new features and characteristics available in the 2005 version.

The Report Builder

Andy Warren brings us an introduction the the Report Builder in SQL Server 2005. It's the less often used tool for developing and customizing reports that you can give to end users and lower the number of requests your developers receive.

A Report to Display and Edit User 'Rights'

Reporting Services is quickly becoming one of the most popular parts of SQL Server and new author Jonathan Spink brings us an interesting use of this subsystem. He explains how Reporting Services can do more than just display data; it can also provide an easy interactive way to make changes without the overhead of a complete .NET application.

Reporting on Hierarchical Recursive data using Reporting Services

Reporting Services has proven itself to be an amazing platform on which to develop all types of reports. Author Asif Sayed brings us some .NET code for using Reporting Services to return data recursively in a report.

Creating a Basic SSAS Cube

In this video demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube. Free registration required.

One of your developers is writing a CLR...

BlackBelt Administration: Linked Reports in Report Manager

Use Linked Reports to provide multiple "versions" of a single source report, as a mechanism for restricting consumer groups to their respective data in accordance with a "need to know."

Data Driven Subscriptions

Reporting Services is a great subsystem for SQL Server that fulfills quite a few needs. However just like SQL Server, there are some features that are limited to the Enterprise Editions, something that not every user can afford to implement. New author Jason Selburg brings us a way to implement subscriptions to reports using Standard edition.

Load 1TB in less than 1 hour

This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to loan me some time one night on the machine they use to do the TPC-H tests. It is an Itanium2 Superdome with 64 1.6GHZ 9M (Madison) CPUs. For the insert tests the system was equipped with 256GB of RAM. The HP SAN configuration is rated at 14GB per second throughput.