Microsoft SQL Server White Papers

(View All Report Types)
A Low Cost Data Warehouse Using SQL Server 2008
sponsored by Dell and Microsoft SQL
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

Dell and Microsoft SQL

Essentials Guide to Table Partitioning and Data Lifecycle Management
sponsored by EMC Corporation
WHITE PAPER: Database partitioning provides improvements to maintenance and performance. This paper examines the benefits of partitioning a database into smaller, workable chunks, rather than an entire monolithic piece.
Posted: 02 May 2006 | Published: 01 Mar 2006

EMC Corporation

Creating SANLess Microsoft SQL Server Failover Cluster Instances with SIOS DataKeeper Cluster Edition and Fusion-io
sponsored by SIOS Technology Corp
WHITE PAPER: Deploying a failover cluster instance (FCI) architecture for your SQL Server database requires expensive shared storage for data files and backups. This resource introduces an alternative to storage area networks (SANs) that provides the availability benefit of an FCI – without the high price tag.
Posted: 11 Feb 2014 | Published: 31 Dec 2013

SIOS Technology Corp

Solution Guide - Choosing Storage for Dell Database Solutions with Dell™ PowerVault™ and Dell/EMC Storage
sponsored by DellEMC and Intel®
WHITE PAPER: This white paper provides a guide for choosing an appropriate storage architecture for Dell Database Solutions deployed on Dell PowerEdge servers with Dell PowerVault and Dell/EMC storage.
Posted: 27 Aug 2008 | Published: 27 Aug 2008

DellEMC and Intel®

Reduce CPU Usage with 'SMART' SQL
sponsored by BMC Software, Inc.
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

BMC Software, Inc.

Comprehensive SQL Server Data Protection with Symantec Backup Exec 11d
sponsored by Symantec Corporation
WHITE PAPER: Choosing the proper backup and recovery plan for SQL Server can be a daunting task. Read this white paper and learn which model best suits your organization and can ease administration.
Posted: 19 Nov 2007 | Published: 01 Jan 2007

Symantec Corporation

Edison Group, Comparative Management Costs Study: Oracle Database 11g vs. Microsoft SQL Server 2008
sponsored by Oracle Corporation
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

Oracle Corporation

How Dell IT Implements Microsoft SQL Server 2005 with Database Mirroring
sponsored by DellEMC and Intel®
WHITE PAPER: Upgrading from SQL Server 2000 to 2005 may seem like a daunting task, but the benefits are plentiful. Get a comparison of features between the two versions, learn about simplified management with MOM management packs and improved database mirroring.
Posted: 18 Sep 2006 | Published: 15 Sep 2006

DellEMC and Intel®

Guide: Enterprise Security Reporter
sponsored by ScriptLogic Corporation
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

ScriptLogic Corporation

Total Data Quality Integration Toolkit (TDQ-IT) for Master Data Management … powered by the Microsoft SQL Server SSIS 2005/2008
sponsored by Melissa
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

Melissa