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

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

SqlBulkTool 1.0

SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.  Read more...
By Additional Articles 2006/07/17 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,127 reads

Getting Started with MDX Scripts

In this article, adapted from the just-published second edition of MDX Solutions that Chris co-authored with George Spofford, Siva Harinath, Dylan Hai Huang, and Francesco Civardi, Chris shows us how to start exploring the world of cubes and MDX Scripts.  Read more...
By Additional Articles 2006/04/30 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,439 reads

Data Rich, Information Poor?

Data, information, and knowledge. They're all different concepts and we sometimes lose sight of the fact that there are differences. This is a good look at the difference.   Read more...
By Additional Articles 2005/11/14 | Source: TDAN | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,345 reads

Time Hour Dimension

By ihafidh 2005/10/13 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,067 reads

Meta-Data Trends & Technologies

The term “Enterprise Metadata Management” has been in use since the late 1980’s when many of us worked in classic “mainframe environments” using “corporate data dictionaries” to manage our COBOL programs, Job Control Language (JCL), screens, reports, copybooks, and database schema definitions. Fast-forward to 2005 ~ has anything changed? What does “enterprise metadata management” mean today ? I recently surveyed a number of leading metadata management vendors, Global 5000 companies, and industry thought-leaders seeking their input.  Read more...
By Additional Articles 2005/07/08 | Source: TDAN | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,974 reads

MDX Essentials: Set and String Functions: The GENERATE() Function

In this lesson, we will introduce a function that provides us the ability to derive a set by systematically applying a set expression to each of the members of a set we define. GENERATE() is a potent function in our MDX toolset, in that it enables us to select precisely only certain members of a dimension level. It effectively operates upon two sets to create a new set, based upon the members of a second set that are also in a primary set.  Read more...
By Additional Articles 2005/03/17 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,682 reads

The Insight Reports: Grid Computing

In the two years since Insight's last examination of the topic, grid computing has moved out of the laboratory and into mainstream commercial applications. No longer the exclusive tool of researchers seeking to harness enough compute power for massive computational challenges such as weather modeling or weapons test simulations, today grids are being deployed in more traditional commercial computing applications. For example, commercial computing stalwarts IBM, Intel, Hewlett-Packard (HP) and Sun recently announced they were forming the Globus Consortium to drive the technology into the mainstream for applications such as financial analysis, oil exploration and pharmaceutical testing. And within the technical community, new standards being developed called the Web Services Resource Framework (WSRF) will foster convergence of the Web service and grid computing communities, which in the years ahead is likely to have a major impact on quality and diversity of Web services.   Read more...
By Additional Articles 2005/03/04 | Source: Datawarehouse.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,069 reads

Analysis Services 2005, the Year of BI

Robert Pearl of Pearl Knowledge Solutions, Inc., recently attended a meeting of the NY Database Professionals Council where SQL Server Analysis Services 2005 was a large part of the topic of conversation. Read his report on the push to move business intelligence into the mainstream.   Read more...
By Robert Pearl 2005/01/18 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,485 reads

Random Populate a Table

By roberto nervi 2004/12/06 | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 312 reads

An Interview with Ralph Kimball

Ralph Kimball, founder of The Kimbaal Group, shares some thoughts on data with PASS.   Read more...
By Additional Articles 2004/11/08 | Source: PASS | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,157 reads
<< Newer    Items 21 to 40 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)