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

Articles with tag Data Warehousing Rss

Search for any content tagged data warehousing

   Items 1 to 20 of 228    Older >>
 

Pairing Data Vault and Biml for DW Agility

Agile data warehousing can be challenging. Pairing the right methodologies and tools can help. Here is how my team met the challenge by using Data Vault methodology and BIML scripting.  Read more...
By Benjamin Seidle 2014/09/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,986 reads

Implementation of partition switching within SSIS

In the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.  Read more...
Rating: |  Discuss |   Briefcase | 3,575 reads

Partitioning Data in a Multi-tenant Data Warehouse Solution

Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.  Read more...
By Sean Woehrle 2014/04/22 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,493 reads

Comparing Data Warehouse Design Methodologies for Microsoft SQL Server

In this article, Arshad Ali goes intp detail about how a data warehouse is different from operational data store and the different design methodologies for a data warehouse.  Read more...
By Additional Articles 2013/07/03 | Source: MSSQLTips.com | Category: data warehousing
Rating: (not yet rated)  Rate this |   Briefcase | 4,494 reads

A Data Hub

The idea of a data hub in your company is interesting to Steve Jones. He talks about this concept, and how it might help you increase data quality, and perhaps get closed to a single view of the truth.  Read more...
By Steve Jones 2012/08/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 193 reads

Track source dates when loading a data warehouse

A primer on how to reduce network and source system load when reading a relational source into the data warehouse.  Read more...
By Magarity Kerns 2012/07/30 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 3,639 reads

PASS Data Architecture VC presents Row Versioned Data Warehouses with Jeremy Huppatz

On Thursday December 15th at 8PM Pacific, Jeremy will discuss the strengths and disadvantages of a row-versioned data warehouse design in the context of a real world case study, sharing lessons learnt and demonstrating some of the technologies and techniques used to build a row-versioned data warehouse   Read more...
By Press Release 2011/12/15 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,670 reads

Slowly changing dimensions using T-SQL MERGE

Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.   Read more...
By Adam Aspin 2011/06/20 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 15,231 reads

Scaling Up Your Data Warehouse with SQL Server 2008 R2

SQL Server 2008 introduced many new functional and performance improvements for data warehousing, and SQL Server 2008 R2 includes all these and more. This paper discusses how to use SQL Server 2008 R2 to get great performance as your data warehouse scales up. We present lessons learned during extensive internal data warehouse testing on a 64-core HP Integrity Superdome during the development of the SQL Server 2008 release, and via production experience with large-scale SQL Server customers. Our testing indicates that many customers can expect their performance to nearly double on the same hardware they are currently using, merely by upgrading to SQL Server 2008 R2 from SQL Server 2005 or earlier, and compressing their fact tables. We cover techniques to improve manageability and performance at high-scale, encompassing data loading (extract, transform, load), query processing, partitioning, index maintenance, indexed view (aggregate) management, and backup and restore.  Read more...
By Additional Articles 2011/05/19 | Source: Microsoft MSDN | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,529 reads

Understanding and Controlling Parallel Query Processing in SQL Server

Data warehousing and general reporting applications tend to be CPU intensive because they need to read and process a large number of rows. To facilitate quick data processing for queries that touch a large amount of data, Microsoft SQL Server exploits the power of multiple logical processors to provide parallel query processing operations such as parallel scans. Through extensive testing, we have learned that, for most large queries that are executed in a parallel fashion, SQL Server can deliver linear or nearly linear response time speedup as the number of logical processors increases. However, some queries in high parallelism scenarios perform suboptimally. There are also some parallelism issues that can occur in a multi-user parallel query workload. This white paper describes parallel performance problems you might encounter when you run such queries and workloads, and it explains why these issues occur. In addition, it presents how data warehouse developers can detect these issues, and how they can work around them or mitigate them.  Read more...
By Additional Articles 2010/12/10 | Source: MSDN Communities | Category: data warehousing
Rating:  Rate this |   Briefcase | 3,465 reads

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,981 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,151 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,034 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,276 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,354 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,417 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,501 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,226 reads
   Items 1 to 20 of 228    Older >>