http://www.sqlservercentral.com/Content tagged Data Warehousing, Miscellaneous posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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.http://www.sqlservercentral.com/redirect/articles/3226/2007/09/21http://www.sqlservercentral.com/redirect/articles/3226/EDM solutions are a logical and often necessary complement to operational analytics.http://www.sqlservercentral.com/redirect/articles/3224/2007/09/11http://www.sqlservercentral.com/redirect/articles/3224/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. http://www.sqlservercentral.com/redirect/articles/3192/2007/09/03http://www.sqlservercentral.com/redirect/articles/3192/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. http://www.sqlservercentral.com/redirect/articles/3079/2007/07/10http://www.sqlservercentral.com/redirect/articles/3079/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."http://www.sqlservercentral.com/redirect/articles/3069/2007/07/03http://www.sqlservercentral.com/redirect/articles/3069/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. http://www.sqlservercentral.com/articles/Miscellaneous/2914/2007/03/21http://www.sqlservercentral.com/articles/Miscellaneous/2914/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.http://www.sqlservercentral.com/redirect/articles/2860/2007/02/08http://www.sqlservercentral.com/redirect/articles/2860/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. http://www.sqlservercentral.com/articles/Miscellaneous/2783/2007/01/10http://www.sqlservercentral.com/articles/Miscellaneous/2783/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. http://www.sqlservercentral.com/articles/Miscellaneous/2732/2006/11/28http://www.sqlservercentral.com/articles/Miscellaneous/2732/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. http://www.sqlservercentral.com/articles/Administering/managingdtspackageseditingschedulingandviewingpack/890/2006/10/06http://www.sqlservercentral.com/articles/Administering/managingdtspackageseditingschedulingandviewingpack/890/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.http://www.sqlservercentral.com/redirect/articles/2506/2006/07/17http://www.sqlservercentral.com/redirect/articles/2506/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.http://www.sqlservercentral.com/redirect/articles/2402/2006/04/30http://www.sqlservercentral.com/redirect/articles/2402/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. http://www.sqlservercentral.com/redirect/articles/2118/2005/11/14http://www.sqlservercentral.com/redirect/articles/2118/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.http://www.sqlservercentral.com/redirect/articles/1962/2005/07/08http://www.sqlservercentral.com/redirect/articles/1962/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.http://www.sqlservercentral.com/redirect/articles/1783/2005/03/17http://www.sqlservercentral.com/redirect/articles/1783/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. http://www.sqlservercentral.com/redirect/articles/1765/2005/03/04http://www.sqlservercentral.com/redirect/articles/1765/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. http://www.sqlservercentral.com/articles/Miscellaneous/areportfromthenydatabaseprofessionalscouncil/1676/2005/01/18http://www.sqlservercentral.com/articles/Miscellaneous/areportfromthenydatabaseprofessionalscouncil/1676/Ralph Kimball, founder of The Kimbaal Group, shares some thoughts on data with PASS. http://www.sqlservercentral.com/redirect/articles/1580/2004/11/08http://www.sqlservercentral.com/redirect/articles/1580/The first article looking at the new BI scorecard technology from Microsoft. This allows you to quickly deploy some easy reports on your OLAP system. From datawarehouse.com.http://www.sqlservercentral.com/redirect/articles/1504/2004/09/16http://www.sqlservercentral.com/redirect/articles/1504/Today Microsoft announces the web release of the Microsoft Office Business Intelligence (BI) Accelerators. Both the Business Scorecards Accelerator and the Excel Add-In for Analysis Services empowers Information Workers and executives alike to increase the speed and quality of decisions aimed at improving business performance. http://www.sqlservercentral.com/redirect/articles/1374/2004/06/04http://www.sqlservercentral.com/redirect/articles/1374/New Author! This is an introductory level look at MDX geared toward intermediate or higher SQL users. The rate of OLAP usage is lower than it should be - maybe this will be what gets you started using it. Or thinking about it at least! http://www.sqlservercentral.com/articles/Miscellaneous/introductiontomdx/1246/2004/01/02http://www.sqlservercentral.com/articles/Miscellaneous/introductiontomdx/1246/Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance! http://www.sqlservercentral.com/articles/Miscellaneous/normalizingdates/1122/2003/09/05http://www.sqlservercentral.com/articles/Miscellaneous/normalizingdates/1122/New author! Tom publishes his first article with us by writing about how business intelligence and data warehouses work together at a high level. Interesting stuff. http://www.sqlservercentral.com/articles/Miscellaneous/buildingbusinessintelligencedatawarehouses/1046/2003/07/15http://www.sqlservercentral.com/articles/Miscellaneous/buildingbusinessintelligencedatawarehouses/1046/Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think! http://www.sqlservercentral.com/articles/Administering/importingandanalyzingeventlogs/997/2003/05/28http://www.sqlservercentral.com/articles/Administering/importingandanalyzingeventlogs/997/Dinesh does a good write up on research he did investigating the BI market and doing a feature comparison between Oracle 9i and SQL 2000. Simple bullet point format, worth a look. http://www.sqlservercentral.com/articles/Miscellaneous/comparisonofbusinessintelligencestrategiesbetweens/993/2003/05/19http://www.sqlservercentral.com/articles/Miscellaneous/comparisonofbusinessintelligencestrategiesbetweens/993/Fast Track to MDX gives readers all the necessary background information needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where a reader can solve real business problems. A CD containing examples from within the book, and a time-limited version of ProClarity, is includedhttp://www.sqlservercentral.com/redirect/articles/971/2003/05/01http://www.sqlservercentral.com/redirect/articles/971/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. http://www.sqlservercentral.com/articles/Administering/managingdtspackageseditingschedulingandviewingpack/890/2006/10/06http://www.sqlservercentral.com/articles/Administering/managingdtspackageseditingschedulingandviewingpack/890/Do OLAP tools shortchange users with time-varying data? This article by Seth Grimes looks at some of the problems with OLAP tools. http://www.sqlservercentral.com/redirect/articles/407/2001/09/06http://www.sqlservercentral.com/redirect/articles/407/An interesting question and one that The OLAP Report attempts to answer. This article is an analysis of what the increasingly misused OLAP term is supposed to mean. http://www.sqlservercentral.com/redirect/articles/410/2001/09/05http://www.sqlservercentral.com/redirect/articles/410/