White Papers

SQL Server 2005 Metadata

Category: Data Management, Software and Web Development

Overview This white paper covers several interesting and unique methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis. What is metadata? The short answer is that it's data about data. Although that sounds like a cop-out, the long answer continues to fill volumes of books and befuddle both technical staff and business users. The primary goals in this whitepaper are to discuss a few different approaches and methods for creating, maintaining, managing and accessing metadata for the purposes of augmenting reporting and analysis systems and how to use features in the SQL Server 2005 platform for metadata to improve overall end user experiences.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: Microsoft
File Format: WORD
Date Published: Sep 19, 2008
Format: White Papers
Topics: Application Servers, Business Intelligence - Data Warehousing, Database Management

Similiar White Papers

Danish Supermarket Group Manages 10 Terabytes of Business Intelligence With SQL Server 2005

With more than 1,000 stores, Danish Supermarket group is one of Denmark's largest retailers. To help keep up with custom

Publisher: Microsoft Tips | Tags: bi, business intelligence, data, data warehouse, intel, retailers, server

TechNet Webcast: Microsoft Business Intelligence for SAP Netweaver (Level 200)

Microsoft SQL Server 2005 includes the integrated Microsoft SQL Server Reporting Services solution to easily create and

Publisher: Microsoft Tips | Tags: data, data warehouse, warehouse

Microsoft Online Customer Story: InSinkErator

Headquartered in Racine, Wisconsin, InSinkErator, a division of Emerson is the world's largest manufacturer of food wast

Publisher: Microsoft

Momentum Webcast: Unlocking the Business Intelligence Capabilities of SQL Server (Level 100)

In an environment where challenge is to do more with less, one must squeeze as much value as possible out of the existin

Publisher: Microsoft | Tags: bi, business intelligence, database, infrastructure

Oracle Optimized Warehouse on Dell PowerEdge Servers and Dell/EMC Storage

This white paper provides an architectural overview and configuration guidelines for deploying Oracle Optimized Warehous

Publisher: Dell | Tags: data, data warehouse, emc, linux, poweredge, software, warehouse

Microsoft White Papers

Guide to Creating and Configuring a Server Cluster under Windows Server 2003

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »