SQL White Papers

(View All Report Types)
OMEGAMON Extended Insight- Analysis: Where is your application spending time?
sponsored by IBM
WHITE PAPER: The limited amount of infomation provided by traditional DB2 for z/OS monitoring makes it difficult and time-consuming to isolate problems within the multiple layers of today's Java, CLI (SAP), and .NET applications. Read this paper to discover a monitoring alternative that provides the detailed information needed for modern applications.
Posted: 14 Feb 2012 | Published: 31 Dec 2011

IBM

BI is in the Details: How Columnar Technology Leverages the Latent Value in SQL Databases
sponsored by Vertica Systems
WHITE PAPER: This paper will discuss how Vertica enhances the capabilities of analytical work through the implementation of different architecture for relational database-based analytical work. By simply rotating the orientation of the database from rows to columns, dramatic improvements in load and query speed, scalability and cost effectiveness are achieved.
Posted: 29 Aug 2011 | Published: 01 Sep 2009

Vertica Systems

VMware vSphere 4: The Most Efficient SQL Server Consolidation Platform
sponsored by VMware, Inc.
WHITE PAPER: Learn how to support your SQL Server instances and control your costs and administration requirements.
Posted: 24 Aug 2011 | Published: 24 Aug 2011

VMware, Inc.

IBM Informix Software Product Family: Version 11.7
sponsored by IBM
WHITE PAPER: Read this paper to take a look at Informix 11.7 and you’ll discover unprecedented advantages. With the introduction of Informix Flexible Grid, it’s easy to perform routine maintenance and upgrades at all your geographic locations from a single site—and you can do it with zero downtime. Read on to learn more about the advantages of Informix 11.7.
Posted: 18 Mar 2011 | Published: 18 Mar 2011

IBM

How to Migrate From Oracle DatabaseLite to Sybase SQL Anywhere
sponsored by Sybase, an SAP company
WHITE PAPER: This document assists with the mobile application migration process from Oracle Database Lite to Sybase SQL Anywhere technology. SQL Anywhere enables bi-directional enterprise data synchronization between multiple mobile devices and an Oracle Database.
Posted: 25 Feb 2011 | Published: 25 Feb 2011

Sybase, an SAP company

Top Five Reasons to Choose Toad® Over SQL Developer
sponsored by Dell Software
WHITE PAPER: Can you actually save more money using Toad® rather than SQL Developer - a free product? The answer is “yes!” In this surprising Quest technical brief, learn how Toad’s revolutionary new features save you time and money while dramatically increasing your productivity. Read the technical brief today.
Posted: 08 Feb 2011 | Published: 08 Feb 2011

Dell Software

Virtualizing Business-Critical Applications With Confidence
sponsored by Symantec Corporation
WHITE PAPER: Within any business, a number of applications exist that are critical to the success of the business. As a result, these applications and the systems they run on require a higher level of availability. The trade off with increasing application availability is an additional cost in terms of redundant hardware and complexity.
Posted: 27 Dec 2010 | Published: 27 Dec 2010

Symantec Corporation

Improving Data Center Performance through Virtualization of SQL Server Databases
sponsored by Dell, Inc. and Intel®
WHITE PAPER: Small and medium businesses need to support growth while wringing every ounce of value out of the investments they’ve already made. This paper looks at the benefits of virtualizing SQL Server databases, as well as how to get the most out of your virtual infrastructure.
Posted: 16 Nov 2010 | Published: 16 Nov 2010

Dell, Inc. and Intel®

Virtualizing Business-Critical Applications With Confidence
sponsored by Symantec Corporation
WHITE PAPER: Within any business, a number of applications exist that are critical to the success of the business. As a result, these applications and the systems they run on require a higher level of availability. The trade off with increasing application availability is an additional cost in terms of redundant hardware and complexity.
Posted: 15 Nov 2010 | Published: 15 Nov 2010

Symantec Corporation

Oracle Real Application Testing 11g Release 2
sponsored by Oracle Corporation UK Ltd
WHITE PAPER: This white paper discusses how Real Application Testing - with Oracle Database 11g Release 2 - allows businesses to quickly adopt new technologies while eliminating the risks associated with change.
Posted: 22 Oct 2010 | Published: 20 Aug 2009

Oracle Corporation UK Ltd

Oracle Database 11g for Data Warehousing and Business Intelligence
sponsored by Oracle Corporation UK Ltd
WHITE PAPER: This white-paper provides an overview of Oracle Database 11g's capabilities for data warehousing, and discuses its key features and technologies. Discover how to integrate information, perform fast queries, scale to very large data volumes, and more.
Posted: 22 Oct 2010 | Published: 23 Sep 2009

Oracle Corporation UK Ltd

Implementing Database Security and Auditing: Using Granular Access Control
sponsored by Guardium, an IBM Company
WHITE PAPER: In this white paper you’ll see that granular access control can only be achieved through aligning the application user model with the database security system.
Posted: 27 Sep 2010 | Published: 27 Sep 2010

Guardium, an IBM Company

RedBook: Oracle to DB2 Conversion Guide - Compatibility Made Easy
sponsored by IBM
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

IBM

SQL Compatibility in DB2 9.7-- From triggers to object enhancements: A demonstration of the new PL/SQL compatibility features
sponsored by IBM
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

IBM

Microsoft SQL Server in a VMware Environment on Dell PowerEdge R810 Servers and Dell EqualLogic Storage
sponsored by Dell and Microsoft SQL
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

Dell and Microsoft SQL

What You Need to Know About SQL Server 2008 Community Technology Preview 5
sponsored by Dell and Microsoft SQL
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

Dell and Microsoft SQL

Guide to Consolidating SQL Server 2000 and SQL Server 2005 Databases to SQL Server 2008
sponsored by Dell and Microsoft SQL
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

Dell and Microsoft SQL

Virtualize Microsoft SQL Server For Improved Performance With PowerEdge 11th Generation
sponsored by Dell and Microsoft SQL
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

Dell and Microsoft SQL

SQL Server 2008 R2: Licensing Quick Reference Guide
sponsored by Dell and Microsoft SQL
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

Dell and Microsoft SQL

How the Right Infrastructure Delivers Real SQL Database Virtualization Benefits
sponsored by Dell, Microsoft and AMD
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

Dell, Microsoft and AMD

Postgres Plus® Technical Evaluation Guide
sponsored by EnterpriseDB Corporation
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

EnterpriseDB Corporation

Heterogeneous Data Replication: Cost-Effective Information Leverage
sponsored by Sybase, an SAP company
WHITE PAPER: Data is the lifeblood of organizations but few organizations take an asset-based, comprehensive approach to it. It drives too much cost because of redundant proliferation, poor synchronization across applications and lack of comprehensive availability policies. Read this paper to learn how effective data integration strategies can help.
Posted: 15 Jun 2010 | Published: 15 Jun 2010

Sybase, an SAP company

Technology Audit: Imperva SecureSphere Data Security Suite
sponsored by Imperva
WHITE PAPER: Any organization delivering services or products via the Web should consider SecureSphere as a “must-have” piece of its IT protection infrastructure. The product set makes a strong case for itself as a leading contender in this market space. Read this paper to read more.
Posted: 02 Jun 2010 | Published: 02 Jun 2010

Imperva

Data Loss Prevention for IBM i
sponsored by Innovatum, Inc.
WHITE PAPER: Open system technology has introduced real threats to data; making loss—whether from theft, malicious manipulation or inadvertent misuse—easier than before. The IBM i has exceptional audit capabilities making it one of the most secure technology platforms. Read this white paper to learn how the IBM i might be a good solution for your organization.
Posted: 16 Apr 2010 | Published: 16 Apr 2010

Innovatum, Inc.

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.