Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Articles with tag
Data Warehousing
Refine your search with one of the following additional tags (with number of items):
Analysis Services (SSAS)
(62)
Database Design
(3)
SQL Server 2005 - SSIS
(2)
Data Compression
(1)
Design and Theory
(58)
Reporting Services (SSRS)
(3)
T-SQL
(2)
Database Weekly
(1)
Miscellaneous
(28)
Scalability
(3)
ADO
(1)
Dimensional modeling
(1)
OLAP Server
(11)
SQL Server 2005
(3)
Advanced
(1)
Editorial
(1)
Data Mining
(10)
Best Practices
(2)
Advanced Querying
(1)
Employee Dimension
(1)
SQL Server 2008
(9)
Development
(2)
Basic Querying
(1)
Fast Track Data Warehouse
(1)
SQL Server 7, 2000
(7)
DTS
(2)
Basics
(1)
Product Reviews
(1)
Programming
(5)
ETL
(2)
Blogs
(1)
Reviews
(1)
Business Intelligence
(4)
Integration Services (SSIS)
(2)
Book Reviews
(1)
Star Join
(1)
Extract, Transform, Load (ETL)
(4)
Interviews
(2)
Capacity planning
(1)
Star Schemas
(1)
MDX
(4)
MDM
(2)
Change Data Capture (CDC)
(1)
Strategies
(1)
News
(4)
Performance Tuning
(2)
cloud services
(1)
Visual Basic 6
(1)
Administration
(3)
SQL Server
(2)
Column-Store Databases
(1)
webinar
(1)
Search for
any
content tagged
Data Warehousing
Items 1 to 20 of 208
Next 20 >>
What a Data Warehouse is Not
Recently, I was at a conference, and I heard the following discussion about what a data warehouse was. One person suggested that a data warehouse was really all the old legacy systems connected by software that could access the data. By calling such a contraption a data warehouse, the organization could avoid having to do the hard and complex work of integration. There are so many problems with this federated approach to a data warehouse that they are almost not worth repeating here. But (once again!) here goes.
Read more...
By
Additional Articles
2009/11/09
|
Source:
B-Eye
|
Category:
Data Warehousing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2 reads
Kimball University: Six Key Decisions for ETL Architectures
Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.
Read more...
By
Additional Articles
2009/10/20
|
Source:
Intelligent Enterprise
|
Category:
Data Warehousing
Rating:
Rate this
|
Briefcase
|
2,317 reads
Energy Intelligence
Given that companies spend on average between 7 and 12 percent of their annual budgets on energy – a focus on reducing energy consumption can have significant bottom-line impact
Read more...
By
Additional Articles
2009/09/30
|
Source:
DMReview
|
Category:
Data Warehousing
Rating:
Rate this
|
Briefcase
|
2,025 reads
How to Calculate Data Warehouse Reliability
This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.
Read more...
By
Additional Articles
2009/09/29
|
Source:
DMReview
|
Category:
Data Warehousing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,342 reads
Ten Pitfalls In Establishing An Enterprise Architecture
Avoiding getting snared in these traps avoids having to spend a lot of money later to fix problems, Gartner says. In addition, EA benefits can be realized faster and the risk of program failure is reduced.
Read more...
By
Additional Articles
2009/09/23
|
Source:
Intelligent Enterprise
|
Category:
Data Warehousing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,809 reads
Star Join Optimization in SQL Server 2008
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
Read more...
By
AdamJorgensen
2009/09/16
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
943 reads
Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).
Read more...
By
Additional Articles
2009/09/10
|
Source:
Microsoft MSDN
|
Category:
SQL Server 2008
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,180 reads
Implementing a SQL Server Fast Track Data Warehouse
This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.
Read more...
By
Additional Articles
2009/09/04
|
Source:
Microsoft MSDN
|
Category:
Data Warehousing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,053 reads
Kimball University: Five Alternatives for Better Employee Dimension Modeling
The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.
Read more...
By
Additional Articles
2009/08/26
|
Source:
SQLServerCentral.com
|
Category:
Data Warehousing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,334 reads
Introduction to Fast Track Data Warehouse Architectures
This paper provides an overview and guide to SQL Server® Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.
Read more...
By
Additional Articles
2009/06/26
|
Source:
TechNet
|
Category:
Data Warehousing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,822 reads
The Wide-Ranging Effects of MDM on BI Systems
When an enterprise first encounters master data management, it often doesn’t have a clear understanding of how MDM will affect the architecture of its business transaction systems or business intelligence systems. This article describes master data patterns in legacy system architectures, a general MDM architecture and some ways the new MDM layer affects the master data patterns in the legacy layers.
Read more...
By
Additional Articles
2009/06/19
|
Source:
Intelligent Enterprise
|
Category:
MDM
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,162 reads
Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation
This document describes common data warehouse implementation strategies and proposes an effective hub-and-spoke architecture using a massively parallel processing system with multiple instances of SQL Server databases.
Read more...
By
Additional Articles
2009/06/17
|
Source:
TechNet
|
Category:
SQL Server 2008
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,326 reads
Using SQL Server to Build a Hub-and-Spoke Enterprise Data Warehouse Architecture
Scalable, cost-effective EDW implementation is an elusive goal for many large organizations. Three common approaches include centralized EDW the “monolithic” approach, decentralized collections of data marts, and attempts at hub-and-spoke architectures that combine the previous two. With the acquisition of DATAllegro and the pending release of Project codename “Madison,” Microsoft is poised to deliver a unique and compelling Massively Parallel Processing (MPP) data warehouse solution that combines the best features of both EDW and decentralized data marts.
Read more...
By
Additional Articles
2009/05/25
|
Source:
TechNet
|
Category:
SQL Server 2008
Rating:
(not yet rated)
Rate this
|
Briefcase
|
533 reads
Book Review: The Data Warehousing Toolkit 2nd Edition
Longtime author and SQL Server guru David Poole takes a look at a classic book about Data Warehousing.
Read more...
By
David Poole
2009/04/24
|
Source:
SQLServerCentral.com
|
Category:
Book Reviews
Rating:
|
Discuss
|
Briefcase
|
1,849 reads
Kimball University: A Data Warehousing Fitness Program for Lean Times
How can you do more with less? Follow this data warehousing/BI strengthening regimen to cut cost, avoid expenditures and bulk up the bottom line.
Read more...
By
Additional Articles
2009/03/24
|
Source:
Intelligent Enterprise
|
Category:
Data Warehousing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,151 reads
The Flaws of the Classic Data Warehouse Architecture, Part 1
Visit ten randomly picked customers that own a data warehouse architecture, and you will see that at least eight have developed a classic data warehouse architecture (CDWA). What do I mean by a CDWA? In a CDWA, data is copied periodically from production systems to the central data warehouse.
Read more...
By
Additional Articles
2009/03/20
|
Source:
B-Eye
|
Category:
Data Warehousing
Rating:
Rate this
|
Briefcase
|
5,045 reads
A Cloudy Week - Database Weekly (Mar 2, 2009)
There has been a lot of news about cloud computing this past week, including an announcement about SQL Server.
Read more...
By
Steve Jones
2009/03/02
|
Source:
SQLServerCentral.com
|
Category:
Editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
178 reads
Week of Warehousing Webinar Series
Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.
Read more...
By
Press Release
2009/02/19 (first published: 2009/01/28)
|
Source:
SQLServerCentral.com
|
Category:
webinar
Rating:
|
Discuss
|
Briefcase
|
8,606 reads
Week of Warehousing Webinar Series
Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.
Read more...
By
Press Release
2009/02/19 (first published: 2009/01/28)
|
Source:
SQLServerCentral.com
|
Category:
webinar
Rating:
|
Discuss
|
Briefcase
|
8,606 reads
Week of Warehousing Webinar Series
Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.
Read more...
By
Press Release
2009/02/19 (first published: 2009/01/28)
|
Source:
SQLServerCentral.com
|
Category:
webinar
Rating:
|
Discuss
|
Briefcase
|
8,606 reads
Items 1 to 20 of 208
Next 20 >>
Most popular
Week of Warehousing Webinar Series
Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won't want to miss out on this free "week of warehousing" webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works.
Read more...
By
Press Release
2009/02/19 (first published: 2009/01/28)
|
Source:
SQLServerCentral.com
|
Category:
webinar
Rating:
|
Discuss
|
Briefcase
|
8,606 reads
The Flaws of the Classic Data Warehouse Architecture, Part 1
Visit ten randomly picked customers that own a data warehouse architecture, and you will see that at least eight have developed a classic data warehouse architecture (CDWA). What do I mean by a CDWA? In a CDWA, data is copied periodically from production systems to the central data warehouse.
Read more...
By
Additional Articles
2009/03/20
|
Source:
B-Eye
|
Category:
Data Warehousing
Rating:
Rate this
|
Briefcase
|
5,045 reads
Energy Intelligence
Given that companies spend on average between 7 and 12 percent of their annual budgets on energy – a focus on reducing energy consumption can have significant bottom-line impact
Read more...
By
Additional Articles
2009/09/30
|
Source:
DMReview
|
Category:
Data Warehousing
Rating:
Rate this
|
Briefcase
|
2,025 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use