Old Model DA Model

True business value lies in using the data model as an entry point for a program of data management that treasures data as the most valuable corporate asset.

Considerations for Data Warehousing

What type of things do you need to look at when setting up a data warehouse? Hardware is a big one as well as the settings for the server, which may be substantially different than transactional systems most DBAs work with. Warehousing expert Vincent Rainardi brings us the next installment in his data warehousing series with some advice on what you should be looking for.

XBRL or Master Data Management?

Master data management (MDM) and eXtensible Business Reporting Language (XBRL) are two key technologies that promise to address important information management issues. Ventana Research believes both will enable companies to reduce the cost, time and effort needed to collect, analyze and use information, whether for visibility, decision support or process execution. Some observers may see them as competing approaches, but in practice each has capabilities best suited to some applications and not others. Even where they overlap, the two may not be mutually exclusive. We advise companies that have not yet begun investigating XBRL and MDM to do so immediately, and all organizations should begin developing skills in using them.

Introduction to Data Warehousing Part 2 - DW Tables

In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required.

Migrating Data Warehouse Systems to SQL Server 2005

Continuing with his fantastic series on data warehousing. Vincent Rainardi brings us the next installment, which takes a look at upgrading the various components of your data warehousing system.

Introduction to Data Warehousing Part 1

In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.

Introduction to Data Warehousing

In this video series, Wes Dumey shows you some of the core basics of data warehousing. Free registration required.

Do You Need a Data Warehouse?

Building a data warehouse is a complicated topic and a hot topic now. Many companies embark upon these projects without understanding what they really need. New author Janet Chan takes a look at some of the things you need to consider before embarking on a project such as this.

In SQL Server 2005, how many pages are...

You are developing security policy for your SQL...