SQL Server 7 Data Warehousing

Microsoft recruited world-renowned database warehousing expert Mike Corey to write this book. He is the best-selling author of Osborne's Oracle 8 Data Warehousing. Microsoft promises to spend more than $20 million to train more than 500,000 new SQL Server 7 DBAs this year. Part of Osborne's SQL Server Professional Library blitz--available with software release. Complete coverage of data warehousing in an enterprisewide environment.

Create a peak-performance data delivery system. Design, build, and manage multidimensional data warehouses with SQL Server 7--Microsoft's new scalable database management system. Businesses today need advanced data delivery systems to analyze complex information and make sound business decisions. This book provides strategic analyses of the latest data warehousing technologies and explains in detail how to implement them--from data mining to RAID or OLAP. Written by renowned relational database solutions experts, SQL Server 7 Data Warehousing is your authoritative guide to every aspect of this explosive technology. Plan, build, implement, and maintain powerful data warehouse solutions. Learn Microsoft's Decision Support Server (Plato) architecture and MOLAP, ROLAP, and HOLAP options. Use the new Data Transformation Services (DTS) to import, export, and transform data in a consistent format. Share data and its lineage information using the Microsoft Repository. Maximixe performance using the new Query Analyzer, Tuning Wizard, and SQL Profiler tools. Use the new Data Transformation Services (DTS) to import, export, and transform data in a consistent format. Implement incremental backup, File Group backup, and other efficient backup strategies.