News (52)

Oracle's Beehive buzzes at OracleWorld

Oracle unveiled a new open enterprise software application on Monday in the US, designed to improve the way users collaborate and communicate on projects. Read more »

Microsoft releases SQL Server 2008

Microsoft said on Wednesday in the US that it had finished work on SQL Server 2008, the latest version of its database software. Read more »

Open-source database Ingres targets software firms

Database company Ingres is creating a package of its namesake open-source database and a version of Linux, a combination it hopes will appeal to hosted application providers. Read more »

SQL Server 2005 gets second service pack

Microsoft has released a second free service pack -- a large, recommended update -- for its popular SQL Server 2005 database application. Read more »

Red Hat scoops up JBoss for US$350m

Linux distributor Red Hat said on Monday that it has signed an agreement to buy open-source company JBoss for at least US$350 million, a move that expands Red Hat's product line and adds to its growth potential. Read more »

Oracle shifts multicore licensing model

Following months of anticipation and some high-profile criticism, Oracle has changed the licensing model for its databases and middleware on multicore servers, bringing it a step closer in line with competitors. Read more »

In T-SQL, use CASE...WHEN in place of IF...THEN

Add some flexibility to your program flow in T-SQL with the CASE...WHEN statement. Get a hands-on look at the statement's syntax and the advantages it can provide for your application. Read more »

Economist: Oracle-SAP duopoly would hurt market

An economist testified Friday that an Oracle takeover of PeopleSoft would allow the database powerhouse and SAP to unfairly dominate the market for business software. Read more »

Grassroots computing languages hit the big time

Once considered simple toys by serious programmers, scripting languages are becoming first-class citizens in the world of corporate software development. Read more »

Sun backs open-source database PostgreSQL

Sun Microsystems has thrown its weight behind PostgreSQL, announcing plans to distribute and support the open-source database. Read more »

Features (79)

Using Mirrored Media Sets in SQL Server 2005

Mirrored Media Sets is a new feature in the Enterprise Edition of SQL Server 2005. It enables the creation of redundant copies of a backup file to reduce the possibility of a backup device malfunction. Here's how you make it work. Read more »

Execute SQL statements in Integration Services

This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary. Read more »

Handle errors in the data tier with SQL Server

Exception handling is a standard part of every .NET application. The try/catch block allows you to catch exceptions and control application execution from that point. Many errors occur during database interaction, but a lot of developers are unaware of handling errors within the database tier. This week we examine error handling in your database code with SQL Server and T-SQL. Read more »

Find sequence gaps using Oracle's analytic functions

Sequences of values occur frequently in database tables. Whether generated naturally as part of the data, or assigned by an Oracle sequence object, the intent is to number the rows with a unique, ever-increasing number. Gaps in this numbering may occur for various reasons. Read more »

Upsizing an existing Microsoft Access database

The Upsizing Wizard in Microsoft's Access database software makes transforming to SQL Server mostly painless. But even the wizard needs fine-tuning for a smooth transition. Find out how to overcome some of the limitations. Read more »

Understand Oracle 10g's Hierarchical Query options

In this week's Oracle tip Scott Stephens discusses Oracle 10g's features that help with Hierarchical Queries. Read more »

Extend the reach of SQL Server with SQLXML classes in .NET

SQL Server 2000 provides XML features called SQLXML classes that are readily available without drastic changes to database design or related stored procedures. Here are a couple of examples of how to use these powerful features. Read more »

Oh, my--MySQL!

MySQL is great for energising your Web site, managing personal data, or any of the average everyday uses of a database. Read this article to learn more about this system, and discover when, where, and why you should use MySQL. Read more »

Add MDX to your SQL Server toolkit

MDX can provide an efficient mechanism for summarising and exploring large volumes of data. See how this tool can help you query big databases. Read more »

SQL basics: Datetime and interval data types

Learn more about the basic syntax of the standard SQL types datetime and interval, in this continuation of the SQL basics series. Read more »

Blog (1)

CodeGear Q&A

Brendon Chase [blogs:codemonkeybusiness] -- CodeGear is the new name for Borland's developer tools business. Builder AU spoke to CodeGear about the handover and direction of the developer tools business under the new banner. Read more »

Log in


Sign up | Forgot your password?

What's on?