Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Data Warehousing Rss

<< Newer    Items 21 to 40 of 317    Older >>
 

3 Fundamental Questions about Data Marts...and Their Answers

A data mart provides the primary access to the data stored in the data warehouse or operational data store. It is a subset of data sourced from the data warehouse or operational data store specifically focused on a business function or set of related business functions. Read on to learn the answers to fundamental questions about data marts.  Read more...
By Additional Articles 2010/12/03 | Source: Database Journal | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,984 reads

A Quick Look at the MPP World

David Poole takes a look at the Massively Parallel Processing world for database servers.  Read more...
By David Poole 2010/08/11 | Source: SQLServerCentral.com | Category: mpp
Rating: |  Discuss |   Briefcase | 4,418 reads

Data Distribution - Part 1

The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.  Read more...
By Leo Peysakhovich 2010/07/26 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 6,764 reads

Building a Data Warehouse Blueprint for Success

One of the most integral components and critical success factors of any enterprise data warehousing initiative is the Solutions Architecture document, a high-level conceptual model of a data warehousing solution. Learn why this collaborative effort that addresses the needs of all major stakeholders, including both the business units and Information Technology (IT), is essential.  Read more...
By Additional Articles 2010/07/09 | Source: Database Journal | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 1,157 reads

Data Warehousing Architecture - Designing the Data Staging Area

The staging area tends to be one of the more overlooked components of a data warehouse architecture, and yet it is an integral part of the ETL component design. Learn why it is best to design the staging layer right the first time, enabling support of various ETL processes and related methodology, recoverability and scalability.   Read more...
By Additional Articles 2010/07/07 | Source: Database Journal | Category: data warehousing
Rating:  Rate this |   Briefcase | 5,040 reads

How to Conduct Effective Data Warehouse and Business Intelligence Software Evaluations

Denise Rogers discusses the essential tasks in conducting effective software evaluations revolving around data warehousing and business intellegence. Each step has a dependency on the previous one, starting with establishing the framework of the evaluation and adding progressively elaborate data that facilitates a decision making process that is resolute.   Read more...
By Additional Articles 2010/06/11 | Source: Database Journal | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,280 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,350 reads

HASHBYTES can help quickly load a Data Warehouse

Data warehouse loads can be time consuming - this method can be used in some instances to help speed things up.  Read more...
By Magarity Kerns 2010/04/14 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 13,370 reads

Populate partition

Fill a specified partition of a table with a specific query, working on staging table   Read more...
By Federico Iori 2010/03/25 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 708 reads

Rebuild partition

Rebuilds online a table partition with all indexes   Read more...
By Federico Iori 2010/03/12 | Source: SQLServerCentral.com | Category: rebuild
Rating: |  Discuss |   Briefcase | 1,686 reads

Kimball University: Three ETL Compromises to Avoid

Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative.  Read more...
By Additional Articles 2010/03/11 | Source: Intelligent Enterprise | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 3,418 reads

Slowly Changing Dimensions

By Prakriti Agrawal 2010/02/08 | Category: data warehousing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,988 reads

Data Warehousing 2.0 and SQL Server: Architecture and Vision

Architecture and data warehousing are not static. From the first notion of a data warehouse to a full-blown analytical processing architecture that includes data marts, ETL, near line storage, exploration warehouses, and other constructs, data warehousing and its associated architecture continue to evolve. In 2008, the book on the latest evolution of data warehousing appeared – DW 2.0: The Architecture for the Next Generation of Data Warehousing (Morgan Kaufman). In that book the general architecture for data warehousing in its highest evolved form appeared.  Read more...
By Additional Articles 2010/01/12 | Source: Microsoft MSDN | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,504 reads

Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

When you need to insert a large set of data using T-SQL, what can you do? New author Melinda Sansone brings us a best practice when using T-SQL to load data for data marts, or warehouses.  Read more...
By Mel Sansone 2009/11/23 | Source: SQLServerCentral.com | Category: data mart
Rating: |  Discuss |   Briefcase | 8,228 reads

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:  Rate this |   Briefcase | 5,718 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 | 3,721 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 | 3,059 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 | 3,990 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 | 3,691 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 | 4,016 reads
<< Newer    Items 21 to 40 of 317    Older >>
 
Tags
miscellaneous (69)    
analysis services (ssas) (62)    
design and theory (58)    
maintenance and management (29)    
t-sql (29)    
sqlinsider scripts (12)    
olap server (11)    
data mining (10)    
sql server 2008 (10)    
etl (7)    
sql server 7 (7)    
backup / restore (6)    
replication (6)    
indexing (5)    
integration services (ssis) (5)    
programming (5)    
administration (4)    
business intelligence (4)    
extract, transform, load (etl) (4)    
mdx (4)    
news (4)    
database design (3)    
lock and connection management (3)    
mail (3)    
reporting services (ssrs) (3)    
scalability (3)    
sql server 2005 (3)    
best practices (2)    
blogs (2)    
code generation (2)    
data profiling (2)    
datawarehouse (2)    
datetime (2)    
development (2)    
dimensions (2)    
dts (2)    
editorial (2)    
interviews (2)    
mdm (2)    
merge (2)    
online (2)    
partition (2)    
partitioning (2)    
performance tuning (2)    
slowly changing dimensions (2)    
sql server (2)    
webinar (2)    
ado (1)    
advanced (1)    
advanced querying (1)    
basics (1)    
biml (1)    
book reviews (1)    
capacity planning (1)    
change data capture (cdc) (1)    
cloud services (1)    
columnstore index (1)    
data (1)    
data compression (1)    
data mart (1)    
data vault (1)    
database weekly (1)    
dba (1)    
defragmentation (1)    
dimensional modeling (1)    
employee dimension (1)    
events (1)    
fast track data warehouse (1)    
hashbytes (1)    
master data services (mds) (1)    
mpp (1)    
multi-tenant (1)    
parallel (1)    
populate (1)    
product reviews (1)    
rebuild (1)    
reviews (1)    
sql server 2008 r2 (1)    
star join (1)    
star schemas (1)    
strategies (1)    
try..catch (1)    
very large table (1)    
visual basic 6 (1)    
warehouse (1)