SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Miscellaneous, Data Warehousing Rss

<< Newer    Items 21 to 40 of 76    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,150 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,465 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,388 reads

Time Hour Dimension

By ihafidh 2005/10/13 | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,116 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 | 2,002 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,744 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,102 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,518 reads

Random Populate a Table

By roberto nervi 2004/12/06 | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 316 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,389 reads
<< Newer    Items 21 to 40 of 76    Older >>
t-sql (25)    
maintenance and management (22)    
sqlinsider scripts (10)    
backup and restore (5)    
administration (4)    
indexing (4)    
programming (4)    
replication (4)    
analysis services (ssas) (3)    
database design (3)    
mail (3)    
olap server (3)    
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)    
development (1)    
dts (1)    
integration services (ssis) (1)    
other (1)    
performance tuning (1)    
reporting services (ssrs) (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sql server 2016 (1)    
strategies (1)    
warehouse (1)