SQL Reports

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

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

PRODUCT DEMO: Watch this video demonstration to see exactly how FalconStor Continuous Data Protector is used to protect and recover your Microsoft SQL Server data.

Posted: 21 Jul 2010 | Premiered: 21 Jul 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: 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: 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

INFORMATION CENTER: If you're a DBA or database developer working with Oracle or another relational database management system, learn how easy it is to get trained and certified for IBM DB2 for Linux, UNIX, and Windows. Expand your skills portfolio, or extend your DBMS vendor support to include DB2.  Download this e-kit and learn more!

Posted: 15 Jun 2010 | Published: 15 Jun 2010

WEBCAST: According to Jonathan Lewis, there is a basic strategy to writing efficient SQL, but it requires knowledge of the data, the metadata, and the intent of the query. Kyle Hailey, though, will discuss his own approach to Visual SQL Tuning (VST) with some ringside support from DB Optimizer XE. Be sure to check out this exciting debate!

Posted: 04 Jun 2010 | Premiered: Jun 10, 2010, 14:00 EDT (18:00 GMT)

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

PRESENTATION TRANSCRIPT: Confused about BI? This presentation transcript breaks down the basics of business intelligence and outlines the key features for Microsoft SQL Server. Discover the advantages of BI and find out how to get started with a business intelligence strategy to enhance your organization.

Posted: 19 May 2010 | Published: 19 May 2010

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

EZINE: Business intelligence is a hot topic in 2010, especially with the upcoming release of Microsoft's SQL Server 2008 R2 being dubbed as the "BI release." In this e-zine, one SQL Server expert breaks down exactly what goes into self-service BI, where it works and where it falls short.

Posted: 16 Feb 2010 | Published: 16 Feb 2010

CASE STUDY: Constellation Energy is the largest wholesale power seller in the United States. When they needed a granular, full fidelity data migration from WSSv2 to WSSv3 platforms, they turned to DocAve SharePoint Migrator. Read this case study to learn how AvePoint's migration solution helped them to achieve their migration goals.

Posted: 03 Feb 2010 | Published: 03 Feb 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

PRESENTATION TRANSCRIPT: In this transcript of the "Data Warehousing Basics for SQL Server Analysis Services" webcast, learn how to build your data warehouse for your SQL Server environment. Discover the necessary steps involved and learn about major concepts, including relational data warehousing and supported SQL Server Analysis Services (SSAS) storage formats.

Posted: 25 Nov 2009 | Published: 25 Nov 2009

EBOOK: SQL Server 2008 has many compelling features, but not all of them are necessary. See what's a good fit for your enterprise and what can wait.

Posted: 24 Nov 2009 | Published: 23 Nov 2009

WEBCAST: Corporate databases are in constant danger. Outside criminals can exploit web applications and employees with malicious intent present an even greater threat. This webcast traces the steps involved in breaking into a database and presents a reference architecture and checklist for implementing iron-clad database security measures.

Posted: 12 Nov 2009 | Premiered: Nov 12, 2009

SOFTWARE DEMO: Adobe ColdFusion 9 software enables developers to rapidly build robust Internet applications by condensing complex business logic into fewer lines of code.

Posted: 05 Oct 2009 | Premiered: 05 Oct 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