Database Journal News

All About the Crosstab Query

December 29, 2009

Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.

Data searches that leverage existing indexes

December 28, 2009

Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on data searches, which leverage existing indexes, taking into account such features as noise words and thesaurus files.

The Second 5 top new features in Oracle Database 11gR2

December 24, 2009

The second part of this two-part article completes a high-level evaluation of Oracle 11gR2's new features to assist Oracle DBAs to decide whether to upgrade their Oracle 9i, 10g, and 11gR1 databases to Oracle 11g Release 2 in the near term.

Oracle as a Data Source

December 23, 2009

This article takes a quick look at Oracle database's materialized view and extends the concept of that feature to a case where Oracle is the data source for another relational database management system.

Introducing the Tablix Data Region: Basic Grouping Concepts

December 22, 2009

BI Architect Bill Pearson continues his examination of the general characteristics and properties of the Tablix data region, which debuts in Reporting Services 2008. Here, we discuss further concepts, and begin our hands-on examination of a Tablix data region in a working sample report.

Working with external text files in MS Access

December 18, 2009

It's possible to treat a text file as a data table, and use the standard approaches to dealing with tables, which is a major advantage in that you can use SQL to filter the text in the file. Doug Steele shows you how.

Getting started with standard auditing in Oracle Database 11g

December 17, 2009

Database auditing is big business. Are you ready for the challenge to pass an audit? This article begins with an introduction to Oracle’s standard auditing that we can build on to answer that question.

Scripting data out of a table in SQL Server 2008

December 16, 2009

Learn how to use the "Generate Script option" in SQL Server 2008 to script data from a table.

Oracle Pledges MySQL Support, EU Warms Up

December 14, 2009

The company may be winning over some critics as it seeks to get the OK on its purchase of Sun, but it also made some sizable commitments in return.