Data Base Journal News   ---  

FREE reports on top business
technology priorities

Using Dynamic Management Objects to Monitor I/Os Against an Instance of SQL Server

 To ensure that queries run as efficiently as possible, the database administrator needs to monitor performance to find inefficient queries. This article focuses on exploring how a DBA can monitor the I/Os against an instance of SQL Server, using Dynamic Management Objects, or more commonly know as Dynamic Management Views (DMVs) and Functions (DMFs). -  more information

Examining the Oracle Database 10053 Trace Event Dump File

 Ever wonder what the Oracle Database Cost Based Optimizer (CBO) was doing behind the scenes or how it comes up with an execution plan? While other tools or settings show us WHAT the CBO comes up with, the 10053 trace event setting tells us HOW the CBO came to its decision (the final execution plan). -  more information

Building a Data Warehouse Blueprint for Success

 One of the most integral components and critical success factors of any enterprise data warehousing initiative is the Solutions Architecture document, a high-level conceptual model of a data warehousing solution. Learn why this collaborative effort that addresses the needs of all major stakeholders, including both the business units and Information Technology (IT), is essential. -  more information

I/O Performance Tuning Tools for Oracle Database 11gR2

 Oracle Database 11g Release 2 (11gR2) makes it easier than ever to isolate and identify potential root causes of poor I/O performance. This article focuses on the various Oracle and non-Oracle tools to generate sample workloads to provide sufficient metrics for detection and eventual resolution of performance bottlenecks within the database's underlying input/output (I/O) subsystem. -  more information

Five Handy Tips for MySQL's Powerful UPDATE Statement

 Rob Gravelle explores the MySQL UPDATE statement, which is used to modify existing records in a table. Among its many features, he looks at how to update multiple tables, avoiding mistakes, and how to limit how many rows are updated. -  more information

IBM DB2 pureScale: The Next Big Thing or a Solution Looking for a Problem?

 In October 2009, IBM announced that some rather neat technology known as data sharing would be delivered for the IBM DB2 for Linux, Unix and Windows product, in an optional facility dubbed pureScale. Julian Stuhler takes a closer look at this technology and the possible implications for the entire IBM DB2 world. -  more information

Implementing SSIS Package Configurations

 Marcin Policht demonstrates how to leverage SQL Server Integration Services (SSIS) package variables in order to modify SSIS properties without directly editing package content. -  more information

Going Mobile: Data Management Solutions for Mobile Devices

 Crunched by the economy and squeezed by competition, businesses and consumers alike are turning to mobile computing. This report wraps up our overview of the top contenders in the mobile database market with a look at Sybase SQL Anywhere and SQLite. -  more information

Gain the Competitive Advantage: Data Management Solutions for Mobile Devices

 Today's workforce and consumers have become increasingly mobile. Businesses crunched by the economy or squeezed by competition look to mobile computing to gain a competitive advantage. This report examines the top contenders in the mobile database market space, starting with SQL Server Compact, Oracle Database Lite and IBM DB2 Everyplace. -  more information

SQLAntipatterns: Avoiding the Pitfalls of Database Programming

 Learn how you too can stamp out common database errors and learn a lot about relational databases along the way. 'Ambiguous Groups' is extracted from 'SQL Antipatterns', published by the Pragmatic Bookshelf. -  more information