Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance

Dedication; Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance; Acknowledgments; Introduction; Hardware Requirements; Software Requirements; Using the SQL Server Evaluation DVD and the Companion CD; System Requirements for the Companion CD; Microsoft Certified Professional Program; Technical Support; Evaluation Edition Software Support; Chapter 1: Developing SSIS Packages; 1.1 Before You Begin; 1.2 Lesson 1: Creating SSIS Packages and Data Sources; 1.3 Lesson 2: Creating and Editing Control Flow Objects; 1.4 Lesson 3: Using Data Flow Adapters and Transformations; 1.5 Case Scenario: Creating an ETL Solution; 1.6 Chapter Summary; Chapter 2: Debugging and Error Handling in SSIS; 2.1 Before You Begin; 2.2 Lesson 1: Configuring Package Transactions and Checkpoints; 2.3 Lesson 2: Identifying Package Status, Enabling Logging, and Handling Task Errors; 2.4 Lesson 3: Handling Data Flow Errors and Debugging; 2.5 Case Scenario: Troubleshooting and Handling Errors in SSIS Packages; 2.6 Chapter Summary; Chapter 3: Deploying and Configuring SSIS Packages; 3.1 Before You Begin; 3.2 Lesson 1: Using Package Configurations and Expressions; 3.3 Lesson 2: Deploying SSIS Packages; 3.4 Case Scenario: Deploying SSIS Packages; 3.5 Chapter Summary; Chapter 4: Administering, Securing, and Executing SSIS Packages; 4.1 Before You Begin; 4.2 Lesson 1: Managing the SSIS Service and Configuring Package Security; 4.3 Lesson 2: Executing and Scheduling Packages; 4.4 Case Scenario: Securing and Scheduling SSIS Packages; 4.5 Chapter Summary; Chapter 5: Developing SSAS Cubes; 5.1 Before You Begin; 5.2 Lesson 1: Creating Data Sources and Data Source Views; 5.3 Lesson 2: Creating and Modifying SSAS Cubes; 5.4 Lesson 3: Creating and Modifying Dimensions; 5.5 Lesson 4: Creating Measure Groups and Measures; 5.6 Case Scenario: Building an SSAS Solution as a Prototype; 5.7 Chapter Summary; Chapter 6: Extending SSAS Cubes; 6.1 Before You Begin; 6.2 Lesson 1: Defining User Hierarchies and Dimension Relationships; 6.3 Lesson 2: Creating KPIs, Actions, Translations, and Perspectives; 6.4 Lesson 3: Creating Calculations and Queries by Using MDX; 6.5 Case Scenario: Extending SSAS Cubes; 6.6 Chapter Summary; Chapter 7: Managing SSAS Storage, Processing, and Deployment; 7.1 Before You Begin; 7.2 Lesson 1: Defining Measure Group Partitions and Aggregations; 7.3 Lesson 2: Deploying SSAS Objects; 7.4 Lesson 3: Processing SSAS Objects; 7.5 Case Scenario: Implementing Low-Latency OLAP and Deployment Strategies; 7.6 Chapter Summary; Chapter 8: Securing and Administering SSAS; 8.1 Before You Begin; 8.2 Lesson 1: Setting Up SSAS Server Security; 8.3 Lesson 2: Managing SSAS High Availability, Backups, and Object Scripting; 8.4 Lesson 3: Managing SSAS Tuning and Logging; 8.5 Lesson 4: Tracing and Monitoring SSAS Instances; 8.6 Case Scenario: Administering and Securing SSAS Cubes; 8.7 Chapter Summary; Chapter 9: Working with SSAS Data Mining; 9.1 Before You Begin; 9.2 Lesson 1: Preparing and Creating Data Mining Structures; 9.3 Lesson 2: Creating Models and Applying Algorithms; 9.4 Lesson 3: Validating Models, Using DMX Queries, and Using Prediction Queries in Reports; 9.5 Lesson 4: Securing and Processing Data Mining Models; 9.6 Case Scenario: Working with SSAS Data Mining; 9.7 Chapter Summary; Chapter 10: Developing SSRS Reports; 10.1 Before You Begin; 10.2 Lesson 1: Creating SSRS Projects and Reports in BIDS; 10.3 Lesson 2: Creating a Dataset from a Data Source; 10.4 Lesson 3: Working with Advanced Report Object Properties; 10.5 Lesson 4: Applying Dataset Filters and Groups; 10.6 Case Scenario: Building Reports for the AdventureWorks Intranet; 10.7 Chapter Summary; Chapter 11: Extending and Deploying SSRS Reports; 11.1 Before You Begin; 11.2 Lesson 1: Assigning Parameters Within Reports; 11.3 Lesson 2: Using Expressions to Perform Advanced Report Item Formatting; 11.4 Lesson 3: Deploying New Reports and Changes; 11.5 Lesson 4: Using Reports in Your Code; 11.6 Case Scenario: Creating a Reporting Services Infrastructure; 11.7 Chapter Summary; Chapter 12: Scheduling and Securing Deployed Reports and Data Sources; 12.1 Before You Begin; 12.2 Lesson 1: Administering SSRS Item-Level Permissions and Site Security Roles; 12.3 Lesson 2: Creating Report Schedules and Subscriptions; 12.4 Lesson 3: Managing Report Caching and Execution Properties in Report Manager; 12.5 Case Scenario: Managing the Report Environment for Adventure Works; 12.6 Chapter Summary; Chapter 13: Configuring and Administering the SSRS Server; 13.1 Before You Begin; 13.2 Lesson 1: Installing and Configuring Initial Instances of SSRS; 13.3 Lesson 2: Configuring Advanced SSRS Settings and Scale-Out Deployment; 13.4 Case Scenario: Scaling Out Your SSRS Servers; 13.5 Chapter Summary; Answers; Chapter 1: Case Scenario Answers; Chapter 2: Case Scenario Answers; Chapter 3: Case Scenario Answers; Chapter 4: Case Scenario Answers; Chapter 5: Case Scenario Answers; Chapter 6: Case Scenario Answers; Chapter 7: Case Scenario Answers; Chapter 8: Case Scenario Answers; Chapter 9: Case Scenario Answers; Chapter 10: Case Scenario Answers; Chapter 11: Case Scenario Answers; Chapter 12: Case Scenario Answers; Chapter 13: Case Scenario Answers; References; Implementing an SSIS Solution; Configuring, Deploying, and Maintaining SSIS; Implementing an SSAS Solution; Configuring, Deploying, and Maintaining SSAS; Implementing an SSRS Solution; Configuring, Deploying, and Maintaining SSRS; About the Authors;