Data Base Journal News   ---  

FREE reports on top business
technology priorities

DB2 z/OS Systems Tuning Tactics

In the z/OS
environment, tuning a DB2 subsystem may require the DBA and systems programmers
to wear multiple hats and approach overall performance tuning from several
different angles. What approaches are best in which situations?

Usage and Benefits of Using WITH RESULT SETS In SQL Server 2012

Having stored procedures returning result sets can become a problem when you want to have control of the name and data type of the columns being returned. Arshad Ali explains a new SQL Server 2012 feature, which lets you redefine the name and data types of the columns being returned from the stored procedure.

Managing Data Growth with Enterprise-class Databases

Compliance isn’t the only reason to retain large data sets; better historical business reference and real-time analysis, all require access to large volumes of data to gain better business insights. Read on to learn more.

SQL Server 2008 and 2008 R2 Integration Services - Sort Transformation

SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing ETL tasks. While most of them are fairly straightforward to deploy in their basic form, there are caveats that should be taken into account as part of their implementation. Read on to learn more.

Data Driven Subscription in SSRS 2008 R2

Learn how to acquire data or parameter values required during the execution of a report from a database query, using Data-Driven Subscription in SQL Server Reporting Services (SSRS).

Couchbase Moving Forward In 2012

NoSQL startup is gearing up for a major new database release.

SQL Server 2008 and 2008 R2 Integration Services - Sampling Transformations

Row Sampling Transformation and Percentage Sampling Transformation, which provide data sampling functionality, are useful in a number of Analysis Services and Data Mining-based scenarios. Marcin Policht demonstrates the functionality of both transformations.

Report Subscription in SSRS 2008 R2

SSRS allows you to create two types of subscriptions, e.g., Standard Subscription and Data Driven Subscription. This article discusses the standard subscription in which you need to specify the parameters the report expects at the time of subscription creation and which cannot be changed at runtime.

SQL Server 2008 and 2008 R2 Integration Services - Dimension Processing Data Flow Destination

The SSIS component, Partition Processing Data Flow Destination, is capable of performing direct data load from a fact table into an arbitrarily chosen partition of a measure within an Analysis Services cube. In this article Marcin Policht examines its counterpart known as Dimension Processing Data Flow Destination, which provides equivalent functionality in regard to dimensions.

Archiving Oracle Databases

Archiving older data is a complex task. Within the context of an Oracle database there are methods of archiving data, some simple, some a bit more complex but still within the realm of possibility. Let's look at those options and what they can, and cannot, offer.