Eu estou compartilhando com vocês um subconjunto de artigos é “White Papers”publicados pela Microsoft sobre Banco de Dados SQL, agrupado pela categoria

Armazenamento de Dados

• TechNet Library Whitepaper: Physical Database Storage Design
• RAID Levels and SQL Server
• Books Online: Files and Filegroups Architecture
• SQL Server 2005 Technical Article: Partitioned Tables and Indexes in SQL Server 2005

Tempdb

• TechNet Library Whitepaper: Working with Tempdb in SQL Server 2005
• Books Online: Optimizing tempdb Performance
• Books Online: Capacity Planning for tempdb

Monitoramento

• Windows Server 2003 Help: Performance monitoring Concepts
• Books Online: Introducing SQL Server Profiler
• TechNet Library: SQL Server 2005 Waits and Queues - SQL Server Best Practices Article
• TechNet Library: SQL Server Best Practices Article - Predeployment I/O Best Practices

Backup

• Books Online: Backing Up and Restoring Databases in SQL Server
• Support Article: SQL Server 7.0, SQL Server 2000, and SQL Server 2005 logging and data storage algorithms extend data reliability
• Description of using disk drive caches with SQL Server that every database administrator should know

Segurança

• Books Online: Securing SQL Server
• Books Online: Setting Up Windows Service Accounts
• Books Online: Security Considerations for a SQL Server Installation

Alta disponibilidade

• Books Online: High Availability Solutions Overview
• Books Online: Selecting a High Availability Solution
• Books Online: Database Mirroring Overview
• Books Online: Log Shipping Overview

Replicação

• Books Online: SQL Server Replication
• Books Online: Replication Publishing Model Overview
• Books Online: Types of Replication Overview
• Books Online: Replication Agents Overview

Service Broker

• Books Online: SQL Server Service Broker
• Books Online: Overview (Service Broker)
• Books Online: What Does Service Broker Do?
• Books Online: Typical Uses of Service Broker

Serviço de Integração

• Books Online: SQL Server Integration Services
• Books Online: Security Overview (Integration Services)
• Books Online: Integration Services Packages
• Books Online: Support for Data Transformation Services (DTS) in SQL Server 2008
• Books Online: Creating Package Configurations

SQL Server 2008

• SQL Server 2008 Technical Article: Introduction to New T-SQL Programmability Features in SQL Server 2008
• SQL Server 2008 Technical Article: Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet
• Books Online: Managing SQL Server Workloads with Resource Governor
• Books Online: Introducing Resource Governor
• Books Online: Resource Governor Concepts

Markus