SQL White Papers

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: 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: Performance optimization is a key ingredient in the struggle to stretch an invested IT dollar to its absolute limit. Read this whitepaper to learn about the 3-step 'prevent, find, fix' approach to handling performance optimization problems at any stage of the development lifecycle.

Posted: 29 May 2009 | Published: 29 May 2009

WHITE PAPER: Today's storage environments need a way to keep data intact without consuming corresponding disk storage. The FalconStor® File Interface Deduplication System provides the solution. Read on to discover the amazing benefits of this data deduplication solution.

Posted: 20 May 2009 | Published: 20 May 2009

WHITE PAPER: Using Solid State Disks (SSDs) in enterprise storage arrays is one of today's hottest storage trends. This whitepaper discusses the best practices for deploying SSDs in an OLTP environment using Dell EqualLogic PS Series arrays.

Posted: 05 May 2009 | Published: 05 May 2009

WHITE PAPER: Find out how Embarcadero's DB Optimizer™ can help you to quickly discover and fix problematic SQL statements that can cause performance bottlenecks in your database. DB Optimizer™ gives you the flexibility of using a single easy-to-use IDE to test, profile and tune SQL.

Posted: 16 Apr 2009 | Published: 16 Apr 2009

WHITE PAPER: This study highlights the benefits and costs of deploying the Oracle Enterprise Manager Diagnostic Pack and Tuning Pack across the enterprise of a sample organization. The study examines the estimated ROI for the sample organization and presents aggregate findings derived from the interview and analysis process and Forrester's independent research.

Posted: 18 Mar 2009 | Published: 18 Feb 2008

WHITE PAPER: This paper spotlights the issues SharePoint administrators and IT administrators encounter when trying to recover SharePoint data and reveals a solution.

Posted: 10 Feb 2009 | Published: 10 Feb 2009

WHITE PAPER: The combination of high performance and efficiency make the PowerEdge R900 an excellent Microsoft Hyper-V virtualization server.

Posted: 11 Dec 2008 | Published: 11 Dec 2008

WHITE PAPER: LINQ is an acronym which stands for Language Integrated Query. This new technology comes built into the .NET Framework 3.5 and can be used with any of the different languages that run under .NET. This paper serves as an introduction.

Posted: 10 Dec 2008 | Published: 10 Dec 2008

WHITE PAPER: Data compression features in data warehouse databases are the current trend, and this paper explains the benefits of compression in data warehousing and differentiates compression approaches taken by different databases.

Posted: 03 Dec 2008 | Published: 03 Dec 2008

WHITE PAPER: This E-Guide offers a step-by-step guide for consolidating SQL Servers, also provides insight on why SQL Server consolidation is an optimization technique.

Posted: 20 Nov 2008 | Published: 20 Nov 2008

WHITE PAPER: This report gives a comprehensive insight into the events and trends that emerged during the first half of 2008, and helps businesses to stay ahead of today's increasingly covert threats.

Posted: 13 Nov 2008 | Published: 13 Nov 2008

WHITE PAPER: Read this white paper to discover the implications, so you can enhance information security for the rest of 2008 and beyond.

Posted: 27 Oct 2008 | Published: 27 Oct 2008

WHITE PAPER: Read this white paper to learn how the new Real Application Testing capabilities in the Oracle Database 11g allows database administrators to adapt to changes easily, lower their testing costs and reduce hardware and software investments.

Posted: 14 Oct 2008 | Published: 14 Oct 2008

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: 15 Oct 2007 | Published: 01 Oct 2007

WHITE PAPER: i5/OS may be famous for security, but it doesn't go far enough in protecting your data. Supplementing with third-party Transaction security is popular, but cumbersome. Find out why Object-based security provides a better way in this...

Posted: 10 Sep 2007 | Published: 01 May 2007

WHITE PAPER: IBM DB2 9 (previously codenamed 'Viper') for Linux, UNIX, and Windows marks a new stage in the evolution of data servers. This IBM white paper introduces and details many of DB2 9's innovative features and capabilities.

Posted: 16 Nov 2006 | Published: 01 Jul 2006

WHITE PAPER: The DB2 Viper is contributing significant advancements in database compression technology. This white paper compares the leading data server compression utilities and details how to reduce storage costs and improve performance.

Posted: 16 Nov 2006 | Published: 01 May 2006