Microsoft Articles

    Articles ZONE

  • Microsoft

 
Article Author
Written by Valentino Vranken.


The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source. The dataset can use a SELECT query, which is the most common way of retrieving data and one that you're probably already familiar with. But it can also use a Stored Procedure (aka stored proc or SP).

The purpose of this article is to demonstrate how data can be ...
Article Author
Written by Valentino Vranken.

A while ago I wrote an article called Chart Optimization Tips. This article explained how to optimize a Column Chart. Today I have returned to show you some Pie Chart implementation techniques.

As usual, I will be using the AdventureWorks2008 database, available at CodePlex. The chart itself will be implemented using SQL Server 2008 Reporting Services.


...
Article Author
A good server design is one that has no, or very few, single points of failure. Among the most common server components that fail are disks. The commonly used method for providing protection against disk failure is Redundant Array of Independent/Inexpensive Disks, or RAID.

In addition to providing tolerance against disk failure, certain RAID levels increase performance by striping data across multiple disks and therefore distributing I/O load among the disks in the RAID volume. After memory, the disk subsystem is the most important factor affecting SQL Server performance.
...
Article Author
For the following example I'll be using SQL Server Reporting Services 2008 and the Adventure Works cube running on SQL Server Analysis Services 2008. In case you don't have the AdventureWorks databases and cubes yet, they're available at CodePlex.

I could have called the article "How to implement conditional formatting using SQL Server Reporting Services 2008", but I didn't. Because that's not the only thing what this article is trying to illustrate. The initial purpose of this article is to show you how you can detect missing fields when retrieving data from an OLAP cube. On top of that, the article also ...
 
 
Articles Help

Have a question about Articles or need ideas for what to write? Check out these links:

 
 
2000th Corporate Account

2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 
 
Filter: Date
Jmoody10 found an article helpful! Understanding Group Policy Loopback Processing 11/20/09 02:21 PM
fibo commented on an article! Win7 after XP -- First Impressions 11/20/09 10:50 AM
fibo commented on an article! Excel Tips & Tricks: The Camera Tool 11/20/09 10:41 AM
StevenHook commented on an article! Windows Virtual PC and XP Mode 11/20/09 10:29 AM
hxtr found an article helpful! Why you shouldn't use PST files 11/20/09 10:28 AM
StevenHook found an article helpful! Win7 after XP -- First Impressions 11/20/09 10:07 AM
alainbryden commented on an article! How to make an 'Archive' button in Outlook 11/20/09 09:54 AM
sourabhjain wrote a Tutorial! Actuate Overview 11/20/09 01:22 AM
RiteshShah wrote a Tutorial! Audit in SQL Server 2008 11/20/09 01:04 AM
x-men wrote a Tip/Trick! AD nested group membership 11/19/09 08:52 AM