Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance

( 2 )


Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft...

See more details below
Other sellers (Paperback)
  • All (12) from $17.48   
  • New (5) from $50.16   
  • Used (7) from $17.45   
Sending request ...


Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

  • Create SSIS packages; troubleshoot data flow and control flow
  • Configure, debug, and deploy SSIS solutions
  • Develop SSAS cubes for OLAP and data mining services
  • Implement custom logic with MDX
  • Optimize storage design and query performance
  • Create SSRS reports; enable interactivity; write custom code
  • Manage the report environment
  • Configure security features for SSIS, SSAS, and SSRS

Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.

Your kit includes:

  • Includes a 15% exam discount from Microsoft. (Limited time offer)
  • Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 200 practice and review questions.
  • 180-day trial of SQL Server 2008 Enterprise Edition.
  • Case scenarios, exercises, and best practices.
  • Fully searchable eBook of this guide, plus sample chapters from related books.

Read More Show Less

Product Details

  • ISBN-13: 9780735626362
  • Publisher: Microsoft Press
  • Publication date: 4/22/2009
  • Edition number: 2
  • Pages: 688
  • Sales rank: 1,428,221
  • Product dimensions: 7.30 (w) x 8.90 (h) x 1.90 (d)

Meet the Author

Dejan Sarka is MCT and MCDBA certified and a Microsoft MVP for SQL Server. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

Read More Show Less

Table of Contents

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;

Read More Show Less

Customer Reviews

Average Rating 5
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Posted November 28, 2009

    I Passed The Exam!!!!

    Thanks to this book, I have successfully pased the Microsoft certification exam. I highly recommend this book to anyone who is pursing this certification. My recommendation would be to study the sample exam questions (all 200 of them) that are included on the CD with the book. They are a great study guide and really helped me get a great test score out of it.

    My sincere thanks to the authors!!

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 2, 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)