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?
-
more information
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.
-
more information
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.
-
more information
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.
-
more information
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).
-
more information
Couchbase Moving Forward In 2012
NoSQL startup is gearing up for a major new database release.
-
more information
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.
-
more information
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.
-
more information
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.
-
more information
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.
-
more information
|