Migrating DTS packages to Integration Services? Brian Knight’s white paper covers two proven methods, and I add tips on testing the result.
SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008
Ron Talmage’s white paper on partitioned table and index strategies using SQL Server 2008, for loading, removing and maintaining data in very large tables.
SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman
Erik Veerman’s white paper introducing Fast Track Data Warehouse architectures, reference configurations that take the guesswork out of BI hardware choices.
SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008
Two white papers by Allan Hirt: Consolidation Guidance for SQL Server, which compares three consolidation options, and Consolidation Using SQL Server 2008.
SQL SERVER – Whitepaper Consolidation Using SQL Server 2008
Allan Hirt’s white paper on consolidation using SQL Server 2008: gathering the facts, then planning, building and running a consolidated environment.
SQL SERVER – Sharepoint Resource Available for SQL Server
A quick SharePoint resource list: recently updated Microsoft tools for SQL Server and SharePoint, like the External Collaboration Toolkit and Reporting Services Add-in.
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
A Microsoft white paper on data compression in SQL Server 2008: strategy, capacity planning, best practices, and the trade-off of I/O savings for CPU.