Chapter 14 -- Managing a SQL Server Data Warehouse

Chapter 14

About This Chapter

The tasks performed to manage a data warehouse built using SQL Server 7.0 and SQL Server OLAP Services include managing slowly changing dimensions, managing server resources, security, and performance. This chapter discusses these issues from a data warehousing perspective. You should use the information discussed in this chapter to supplement your standard SQL Server management practices.

Before You Begin

To complete the lessons in this chapter, you must

• Have installed SQL Server 7.0.
• Have installed SQL Server OLAP Services; in order to complete the optional exercise on creating multiple partitions, you must install SQL Server OLAP Services Enterprise Edition.
• Be able to log in to SQL Server as an administrator.



• Have installed the Exercise files from the Supplemental Course Materials CD-ROM to your hard disk drive. See the "Getting Started" section in "About This Book" for installation instructions.
• Have completed the exercises in Chapter 8, "Advanced DTS" to create and populate the Northwind_Mart data warehouse database. If you have not created the Northwind_Mart database, you can execute the C:\SQLDW\Exercise\Ch08\MakeMart.BAT batch file to create and populate the database. You cannot perform the exercises in this chapter if you have not created and populated the Northwind_Mart database.
• Have completed the exercises in Chapter 9, "Microsoft SQL Server OLAP Services" to create and populate the Northwind_DSS OLAP Services database and the Sales cube. If you have not created the Northwind_DSS database and the Sales cube, you can execute the C:\SQLDW\Exercise\Ch09\MakeMDdb.BAT batch file to create and populate the database and the cube. You cannot perform the exercises in this chapter if you have not created and populated the Northwind_DSS database and the Sales cube.