SQL Server Artigos é “White Papers”
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