Summary

In this chapter, you reviewed several advanced components provided with SQL Server 2008. You installed and configured Analysis Services, Integration Services, and Reporting Services. Each installation was similar and used the same installation engine. The key was to select the appropriate options during installation. Once you installed SQL Server Integration Services, you created your first package for data export. Additionally, you worked with both Database Mail and full-text indexes. You learned that Reporting Services no longer requires IIS to be installed on the SQL Server and that Database Mail has not required Outlook on the server since SQL Server 2005 was released. You also learned that full-text indexing no longer requires external ...

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.