Event Review: Introduction to SQL Server 2005 Reporting Services (Session ITPROSQL-06)

Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.

Session Outline

This session introduces SQL Server 2005 Reporting Services. We will review its place in what is known as SQL Server 2005 Business Intelligence, and the various components and features that comprise the Reporting Services platform. We will then cover the many new and exciting features that have been added since SQL Server 2000. Finally, we will gain an understanding of the report lifecycle. We will see how to create, publish, manage and deliver reports using the new tools and features of SQL Server 2005 Reporting Services. At the end of the session, you should be ready to create and publish reports to enhance your organizations business knowledge.

Session Agenda


Use the following resources to learn more about topics covered in this briefing.

Microsoft Press Books

  • Microsoft SQL Server 2005 Administrator's Pocket Consultant

    Summary: Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005.

  • Microsoft SQL Server 2005 Reporting Services Step by Step

    Summary: Your hands-on, step-by-step guide to building reporting solutions for the enterprise. Teach yourself the fundamentals of SQL Server Reporting Services one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization. Discover how to: Install and configure Reporting Services , Author, manage, and access reports, Create attractive, information-rich reports with the Report Designer, Calculate values, organize information, and manipulate report data, Build, deploy, and maintain a report model, Render and distribute reports in various formats, Implement role-based security to restrict access to information, Explore more advanced report design techniques, Programmatically customize any stage of the reporting lifecycle. The included CD features all practice exercises.

  • Inside Microsoft SQL Server 2005: The Storage Engine

    Summary: Get expert architectural insights for building and maintaining robust databases. Take an in-depth look at the internals of the SQL Server Storage Engine with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.

  • Microsoft SQL Server 2005 Administrator's Companion

    Summary: Your one-volume guide to planning, deployment, administration, and support. Get your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrators reference details features and capabilities of SQL Server 2005 including how to implement business intelligence applications. It delivers the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for on-the-job-results.

  • MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005

    Summary: Your 2-in-1 Self-Paced Training Kit. Ace your preparation for the skills measured by MCTS Exam 70-444 and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises.

  • MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005

    Summary: Your 2-in-1 Self-Paced Training Kit. Ace your preparation for the skills measured by MCITP Exam 70-443 and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

  • Microsoft SQL Server 2005: Database Essentials Step by Step

    Summary: Your hands-on, step-by-step guide to learning the fundamentals of SQL Server 2005 programming. Get the guidance you need to start designing databases one step at a time. With this practical tutorial, you'll teach yourself the core skills for building and managing databases with the next generation of SQL Server.

Third-Party Books

  • Microsoft SQL Server 2005 Reporting Services

    Summary: SQL Server Reporting enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions.

  • Microsoft SQL Server 2005 Reporting Services 2005

    Summary: Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

  • SQL Server 2005 Distilled

    Summary: SQL Server 2005 Distilled offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more.

  • Microsoft SQL Server 2005 A Beginner's Guide

    Summary: This bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench, T-SQL, automated administration tasks, security, and analysis.

  • Microsoft SQL Server 2005 The Complete Reference

    Summary: Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports.

  • Professional SQL Server 2005 Reporting Services

    Summary: SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool.

Training and Certification