SQL Server White Papers

WHITE PAPER: Learn how to support your SQL Server instances and control your costs and administration requirements.

Posted: 15 Oct 2010 | Published: 14 Oct 2010

WHITE PAPER: You can virtualize SQL Server successfully using VMware Infrastructure. The vast majority of SQL Server deployments are good candidates for virtualization and can benefit from improvements offered by a virtualized infrastructure—such as improved management, availability, and scalability—thus reducing overall TCO.

Posted: 15 Oct 2010 | Published: 14 Oct 2010

WHITE PAPER: Run your business-critical applications, including Exchange, SQL, SAP, and Oracle, on VMware vSphere with breakthrough performance and outstanding reliability.

Posted: 14 Oct 2010 | Published: 14 Oct 2010

WHITE PAPER: This paper outlines different considerations for separating decision support systems (DSS) from Transaction Processing (OLTP) environments and touches upon technical procedures for achieving the same, as well as examines data warehouse solutions, different storage topologies, storage interface optimizations and much more.

Posted: 08 Oct 2010 | Published: 29 Jul 2009

WHITE PAPER: This paper focuses on the SQL Server I/O subsystem and the role it plays in a SharePoint environment. The lessons learned in this paper will help IT Managers build more efficient and effective SharePoint environments on an SQL back-end.

Posted: 08 Oct 2010 | Published: 24 Aug 2010

WHITE PAPER: New IBM DB2 features make compatibility easy. In this guide, you’ll learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more—all designed to improve your ability to run applications on both DB2 and Oracle platforms

Posted: 01 Sep 2010 | Published: 01 Sep 2010

WHITE PAPER: This article overviews the new PL/SQL compatibility features in IBM DB2 software version 9.7, making it easier to adopt and allowing you to take advantage of its autonomic and high-performance characteristics. 

Posted: 01 Sep 2010 | Published: 01 Sep 2010

WHITE PAPER: Read this paper for a description of the benefits and performance of the latest Dell™ PowerEdge™ R810 running Microsoft® SQL Server® in VMware® vSphere™ 4.0 Update 1 (U1) and EqualLogic™ PS6000XV iSCSI storage arrays.

Posted: 12 Jul 2010 | Published: 23 Apr 2010

WHITE PAPER: Read this paper for a discussion of the Community Technology Preview (CTP) process, and the CTP5 incarnation specifically. This paper examines mission-critical features, enterprise management features, database data and programmability, and new business intelligence features.

Posted: 12 Jul 2010 | Published: 15 Jan 2008

WHITE PAPER: Read this paper for an informative guide to helping you consolidate your Microsoft® SQL Server® 2000 and SQL Server 2005 databases from multiple machines onto a single SQL Server 2008 server system.

Posted: 12 Jul 2010 | Published: 30 Oct 2008

WHITE PAPER: This white paper describes the benefits and performance of the latest Dell PowerEdge R810 running Microsoft SQL Server in VMware vSphere 4.0 Update 1 (U1) and EqualLogic PS6000XV iSCSI storage arrays.

Posted: 12 Jul 2010 | Published: 12 Jul 2010

WHITE PAPER: This Quick Reference Guide is for people who need to understand the basics of how Microsoft SQL Server 2008 R2 is licensed and sold. This guide does not supersede or replace any of the legal documentation covering SQL Server use rights.

Posted: 12 Jul 2010 | Published: 12 Jul 2010

WHITE PAPER: Consolidating and/or virtualizing SQL Server databases can improve data center efficiency and enable you to tackle database sprawl, achieve high availability, and boost agility. Beginning with the value 4 processor (4P) capabilities of the AMD Opteron™ 6000 Series platform, the AMD/Dell/Microsoft combination can help produce substantial savings.

Posted: 06 Jul 2010 | Published: 06 Jul 2010

WHITE PAPER: Consolidating and/or virtualizing SQL Server databases can improve data center efficiency and enable you to tackle database sprawl, achieve high availability, and boost agility. Beginning with the value 4 processor (4P) capabilities of the AMD Opteron™ 6000 Series platform, the AMD/Dell/Microsoft combination can help produce substantial savings.

Posted: 25 Jun 2010 | Published: 25 Jun 2010

WHITE PAPER: This guide outlines the common steps that people go through when they are interested in evaluating an open source database (e.g. one or both of the Postgres Plus products). This guide will also provide links to other documents/collateral that will help you accomplish each step. Read on to learn about these common steps in evaluation in more detail.

Posted: 16 Jun 2010 | Published: 15 Jun 2010

WHITE PAPER: This paper describes game-changing innovations in SQL Server® 2008 R2, including self-service business intelligence (BI), server manageability, complex event processing (CEP), and Master Data Services. 

Posted: 10 May 2010 | Published: 04 May 2010

WHITE PAPER: The Total Data Quality Integration Toolkit is an affordable, full-featured enterprise data integration platform and rich development environment for creating and managing data assets that can be leveraged specifically for MDM applications. TDQ-IT leverages SSIS to provide a flexible, effective solution for data quality and MDM initiatives.

Posted: 20 Apr 2010 | Published: 20 Apr 2010

WHITE PAPER: This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.

Posted: 30 Nov 2009 | Published: 30 Nov 2009

WHITE PAPER: Microsoft SharePoint Server is a powerful platform for collaboration and content management built upon the firm foundation of Microsoft SQL Server® technology. It provides simplified storage provisioning and management for SharePoint with performance and scalability that supports enterprise-wide content consolidation.

Posted: 25 Sep 2009 | Published: 28 Aug 2009

WHITE PAPER: This document covers the key overall concepts and procedures you need to setup and configure your Hyper-V platform. It reviews in detail the approach that PT and Dell recommend for a tested and validated installation of Windows Server 2008 and Hyper-V.

Posted: 10 Sep 2009 | Published: 10 Sep 2009

WHITE PAPER: This Deployment Guide reviews the approach that Principled Technologies and Dell recommend for migrating databases from SQL Server 2000 to SQL Server 2008.

Posted: 10 Sep 2009 | Published: 23 Apr 2008

WHITE PAPER: In this whitepaper presented by the Edison Group, reveals how Oracle Database widens the manageability lead over Microsoft SQL Server 2008. The study shows how Oracle Database can save 43% in time and 41% in database management costs over Microsoft SQL Server 2008.

Posted: 09 Sep 2009 | Published: 15 Jul 2009

WHITE PAPER: In large networks, the sheer number of permission settings makes it almost impossible to gain a clear overview of overall security, and checking that all those permission are in compliance with corporate and regulatory standards is a Herculean task.

Posted: 27 Aug 2009 | Published: 27 Aug 2009

WHITE PAPER: This white paper explains how to use Encrypting File System (EFS), a feature that is provided by default in the Windows® operating system, to protect data in Microsoft Dynamics CRM clients for Outlook Compatibility Update running on Windows XP Professional Service Pack 2 (SP2).

Posted: 25 Aug 2009 | Published: 28 Jun 2007

WHITE PAPER: Safeguarding personally identifiable information (PII) and remaining in compliance with government regulations is a difficult challenge made easier with database tools from Embarcadero Technologies.

Posted: 27 Mar 2009 | Published: 27 Mar 2009