最 低 价：￥181.00
| 作者简介：Erik VeermanErik Veerman is a SQL Server MVP, MCT, and mentor for SolidQuality Mentors, focusing on the SQL Server BI platform. Erik ledthe ETL architecture and design for the first production imple- mentation of Integration Services (SSIS) and assisted with the ETL standards and best practices for Microsoft's SQL Server 2005 Project REAL initiative. Erik is co-author of the books Professional 5QL 5erver 2005 Integration Services and Expert SQL 5erver 2005 Integration Services, and he assists in the leadership of the Atlanta SQL Server User's Group. |
| Introduction 1 Installing SQL Server 2005 Business Intelligence Tools Before You Begin Lesson 1: Installing SQL Server 2005 Components Selecting Installation Components Choosing Installation Details Practice: Installing SQL Server 2005 Components Lesson 2: Performing Updates and Advanced Installations Keeping Current with Service Packs Clustering Analysis Services and Managing Instances Installing Multiple Instances of Reporting Services Practice: Installing a Service Pack Case Scenario: Installing SQL Server 2005 Components for a BI Project Chapter Summary 2 Configuring SQL Server 2005 Business Intelligence Components Before You Begin Lesson 1: Configuring the SSRS Architecture and Instances Using the Report Server Configuration Manager Tool for Server Setup and Management ; Using the Reporting Services Command-Line Tools to Manage SSRS Configuring the Report Server for SSL Communication and Internet Deployment Practice: Managing SSRS Encryption Keys Lesson 2: Setting SSAS Server Security and Server Properties Setting SSAS Administrative Roles and Permissions Editing SSAS Server Properties Practice: Setting Up SSAS Query Logging Case Scenario: Setting up your SSAS and SSRS Servers Chapter Summary 3 Migrating to SQL Server 2005 Business Intelligence Components.. Before You Begin Lesson 1: Upgrading SSAS Architecture Changes Migration Overview Using the Analysis Services Migration Wizard Post-Migration Considerations Practice: Using the Analysis Services Migration Wizard Lesson 2: Migrating to SSIS Packages DTS and SSIS Differences Executing and Managing DTS in SQL Server 2005 Running the Package Migration Wizard Post-Migration Steps Taking Advantage of SSIS Features Practice: Migrating a DTS Package to SSIS Case Scenario: Migrating to SQL Server 2005 Business Intelligence Components Chapter Summary 4 Developing SSlS Packages Before You Begin Lesson 1: Creating SSIS Packages Using the Import and Export Wizard Creating an SSIS Project in BIDS Practice: Creating a New Project Lesson 2: Defining Project Data Sources and Package Connections.Creating a Data Source …… 5 Debugging and Error Handling with SSlS Packages 6 Developing SSAS Cubes 7 Extending SSAS Cubes 8 Defining SSAS Storage, Partitions, and Aggregations 9 Developing SSAS Data Mining Models 10 Developing SSRS Reports 11 Formatting and Extending SSRS Reports 12 Deploying and Configuring SSlS Packages 13 Deploying and Processing SSAS Objects 14 Deploying and Scheduling SSRS Reports 15 Securing and Executing SSlS Packages 16 Administering and Securing SSAS Cubes 17 Securing and Querying SSAS Data Mining Models 18 Managing and Securing SSRS Reports |
内容加载中，请稍后...
商品评论（0条）