White Papers : SQL Server 2008

  • Article

Discover SQL Server 2008 through a variety of solution and technology-focused white papers.

 

General

  • SQL Server 2008 Product Overview

    Microsoft SQL Server provides a policy-based system for managing one or more instances of SQL Server along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases and SQL Server instances.
    Audience: High-level

 

  • Running SQL Server 2008 on Windows Server 2008

    The combination of SQL Server 2008 and Windows Server 2008 offers enterprise IT administrators and professional developers a superlative platform for mission-critical applications together with enhanced end-to-end security, management, and development capabilities.
    Audience: High-level

 

Business Intelligence

  • Introduction to New Data Warehouse Scalability Features in SQL Server 2008

    With the 2008 release, SQL Server makes a major advance in scalability for data warehousing. It meets the data warehouse needs of the largest enterprises more easily than ever. SQL Server 2008 provides a range of integrated products that enable you to build your data warehouse, and query and analyze its data. These include the SQL Server relational database system, Analysis Services, Integration Services, and Reporting Services. This paper introduces the new performance and manageability features for data warehousing across all these components. All these features contribute to improved scalability.
    Audience: High-level

 

  • SQL Server 2008 Analysis Services Overview

    Microsoft SQL Server 2008 Analysis Services builds on the value delivered with the significant investments in Analysis Services 2005 around scalability, advanced analytics, and Microsoft Office interoperability. This paper covers a high-level look at the key Analysis Services features available in SQL Server 2008.
    Audience: High-level

 

  • Predictive Analysis with SQL Server 2008

    This 10-page paper explores the complete and intuitive set of data mining tools offered in Microsoft SQL Server 2008, which features predictive analysis for all users, insight at every step of the data lifecycle, and data mining awareness in every application.
    Audience: High-level

 

  • Business Intelligence in SQL Server 2008

    This 10-page paper covers the following topics: Unifying Data Storage and Access, Building and Managing Sophisticated BI Solutions, and Extending the Reach of Your BI Solution.
    Audience: High-level

 

  • SQL Server 2008 Reporting Services

    This paper discusses how Microsoft SQL Server 2008 Reporting Services provides a complete server-based platform that is designed to support a wide variety of reporting needs including managed enterprise reporting, ad-hoc reporting, embedded reporting, and web based reporting to enable organizations to deliver relevant information where needed across the entire enterprise.
    Audience: High-level

 

 

Online Transaction Processing/Data Management

  • Database Encryption in SQL Server 2008 Enterprise Edition

    With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows.
    Audience:   High-level

 

  • SQL Server 2008 Security Overview for Database Administrators

    SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way even as applications and users make use of the data stored within.
    Audience: Mid-level

 

 

  • SQL Server 2008 Manageability

    This paper discusses how Microsoft SQL Server 2008 builds on the management capabilities of previous versions and provides a variety of tools and frameworks to help you manage your enterprise data environment.
    Audience: High-level

 

  • SQL Server 2008 Performance and Scale

    This paper discusses how Microsoft SQL Server 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness.
    Audience: Mid-level

  • An Introduction to SQL Server 2008 Integration Services

    This paper discusses the challenges that face businesses that rely on data integration technologies to provide meaningful, reliable information to maintain a competitive advantage in today’s business world. It discusses how SQL Server 2008 Integration Services (SSIS) can help Information Technology departments meet data integration requirements in their companies. Real-world scenarios are included.
    Audience: High-level

 

Application Development/Data Programmability

 

  • What's New for XML in SQL Server 2008

    This 16-page paper discusses how Microsoft SQL Server 2008 builds on the extensive support for XML by extending support for XML schema validation and XQuery, and by enhancing the xml data type.
    Audience: Technical

 

  • Managing Unstructured Data with SQL Server 2008

    This 11-page paper discusses how Microsoft SQL Server 2008 provides a flexible solution for storing unstructured data and combining it with relational data to build comprehensive solutions that encompass the full range of data across an organization.
    Audience: Technical

 

 

Online Transaction Processing/Data Management

  • Database Encryption in SQL Server 2008 Enterprise Edition

    With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows.
    Audience:   High-level

 

  • SQL Server 2008 Security Overview for Database Administrators

    SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way even as applications and users make use of the data stored within.
    Audience: Mid-level

 

 

  • SQL Server 2008 Manageability

    This paper discusses how Microsoft SQL Server 2008 builds on the management capabilities of previous versions and provides a variety of tools and frameworks to help you manage your enterprise data environment.
    Audience: High-level

 

  • SQL Server 2008 Performance and Scale

    This paper discusses how Microsoft SQL Server 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness.
    Audience: Mid-level

 

Server Consolidation