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

Content with tags Data Warehousing, Miscellaneous Rss

   Items 1 to 20 of 75    Older >>
 

Function to Add Leading 0's (Zeros) to an INT

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...
By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,573 reads

Strategies for Testing Data Warehouse Applications

This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.  Read more...
By Additional Articles 2007/09/21 | Source: Datawarehouse.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,106 reads

Making the Most of Operational Analytics with Enterprise Decision Mana

EDM solutions are a logical and often necessary complement to operational analytics.  Read more...
By Additional Articles 2007/09/11 | Source: Datawarehouse.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 967 reads

The Importance of Fraud Analytics

Organizations with mature business intelligence environments can integrate fraud analytics within their current environment to take advantage of processes and architecture that are already in place.   Read more...
By Additional Articles 2007/09/03 | Source: Datawarehouse.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,214 reads

Real-Time Ambition: Reaching the Potential of Event Processing

Complex event processing (CEP) software delivers on the promise of real-time insight, but is the technology too green for mainstream success? CEP was once available only to big financial institutions and government agencies that could afford custom development projects. That's no longer the case, as off-the-shelf products and implementations have proliferated.   Read more...
By Additional Articles 2007/07/10 | Source: Intelligent Enterprise | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,407 reads

Dynamic Data Warehousing - The Virtual Brand Reaches Take-Off Speed

The interest in dynamic data warehousing (DDW) is growing significantly. A sure sign that the virtual brand has reached take-off speed is claims by bloggers that they did not get enough credit for coining the concept, viral brand or idea. For example, Dan Linstedt recently went on what he described as a "rant" about "dynamic data warehousing."  Read more...
By Additional Articles 2007/07/03 | Source: Intelligent Enterprise | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,831 reads

Are you ready for Data Warehouses?

Data warehousing is being used more and more everyday and longtime data warehouse DBA Janet Wong brings us a short look at her first project and some thoughts about warehousing in general.   Read more...
By Janet Wong 2007/03/21 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,193 reads

Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Repor

Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified as having predominately read workloads (e.g. Decision Support, Analysis, and Reporting) with periodic feeds or batch loads. It is important to keep these characteristics in mind as we examine the significance of database design, resource utilization and system performance. The top performance bottlenecks or gotchas to avoid for Data Warehouse or Reporting applications are outlined below.  Read more...
By Additional Articles 2007/02/08 | Source: TechNet Blogs | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,056 reads

Generating Surrogate-Keys for Type 1 and Type 2 dimensions using SSIS

We published a very interesting article about data warehousing in the SQL Server Standard awhile back. However the article was abridged and the author, a very respected data warehousing professional asked that we publish the entire thing here. So we bring you Harsh Bhaiya's very popular ETL treatise.   Read more...
By Harsh Bhaiya 2007/01/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,450 reads

Upsert Dimension Table

We get Vincent Rainardi's "Data Warehouse Loading Part 2" article taking a look at how you can perform an "upsert" in your data warehouse.   Read more...
By Vincent Rainardi 2006/11/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,515 reads

Managing DTS packages - Editing, Scheduling, and Viewing Package Logs

In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.   Read more...
By Haidong Ji 2006/10/06 (first published: 2003/01/02) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,648 reads
   Items 1 to 20 of 75    Older >>
 
Tags
t-sql (24)    
maintenance and management (22)    
sqlinsider scripts (10)    
backup / restore (5)    
administration (4)    
indexing (4)    
programming (4)    
replication (4)    
analysis services (ssas) (3)    
mail (3)    
olap server (3)    
database design (2)    
lock and connection management (2)    
sql server 7 (2)    
advanced (1)    
advanced querying (1)    
data (1)    
data mining (1)    
dba (1)    
design and theory (1)    
dts (1)    
integration services (ssis) (1)    
performance tuning (1)    
reporting services (ssrs) (1)    
sql server 2005 (1)    
strategies (1)    
warehouse (1)