News (84)

MySQL 4.1 moves in on Oracle

The open-source database is edging closer to parity with commercial databases with functionality such as binary prepared statements. Read more »

Sun releases MySQL 5.1

Sun Microsystems has released the updated 5.1 version of the MySQL open source database software it recent acquired, promising improved performance and management of larger database applications. 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 »

Drizzle: MySQL slims down on Aker's diet

Brian Aker, MySQL's director of architecture, has unveiled Drizzle, a database project aimed at powering websites with massive concurrency as well as trimming superfluous functionality from MySQL. Read more »

New hacker trick may expose Oracle databases

A new attack technique increases the risk of commonly found bugs in Oracle's database software, a security researcher has warned. Read more »

MySQL backtracks on closed-source plan

Sun has backtracked on previous plans to release important backup features for its MySQL database under a proprietary licence, following widespread criticism from the open-source community. Read more »

Embarcadero embarks on a new journey with CodeGear

Embarcadero Technologies, a provider of professional database tools has signed a deal to acquire CodeGear, currently a part of the Borland Software Corporation for approximately $23 million. Read more »

Oracle buys open-source database firm

Database heavyweight Oracle has acquired Innobase Oy, a privately held Finnish company with close ties to open-source database company MySQL. Read more »

Oracle tool to rein in database admins

Database administrators don't always need access to the information in the databases they're managing, so Oracle has created a tool to protect it. Read more »

Big Blue DB2 Viper database will feature data-compression technology, code-named Venom, imported from mainframe.

Big Blue DB2 Viper database will feature data-compression technology, code-named Venom, imported from mainframe. Read more »

Features (169)

Generate dynamic SQL statements in SQL Server

When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly. Read more »

Create a VS.NET add-in to write SQL statements

Visual Studio .NET allows you to create an add-in to write all of those tedious SQL statements for you. We'll show you how step-by-step. Read more »

SQL basics: Query multiple tables

Learn when to use SELECT, JOIN, subselects, and UNION to access multiple tables with a single statement. Read more »

Using SQL statements with ASP

Using ASP and SQL together can be confusing. Help ease he confusion with the help of these 12 SQL tips for ASP. 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 »

SQL basics: SELECT statement options

Master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Read more »

Using SQL Server 2008's MERGE statement

SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. Read more »

More New SQL Server 2008 Features

Microsoft updates SQL Server on a pretty regular basis. Its newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them. Read more »

Create cross-platform database-driven applications with JDBC

The Java Database Connectivity (JDBC) API offers a unified interface to different databases, providing a series of generic functions that are internally translated into native function calls. This makes it extremely easy to create database-driven applications that work across different RDBMS types. Read more »

New Date Datatypes in SQL Server 2008

SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Heres how you can use these new data types to your advantage in SQL Server 2008. Read more »

Blog (3)

The 2008 Trends and Threats to Internet security

Lana Kovacevic [blogs:webanatomy] -- I recently came across the IBM Internet Security Systems X-Force 2008 Mid-Year Trend Statistics report, which outlines issues affecting internet security, including application vulnerabilities, phishing, malware and spam. Read more »

Is public domain software open-source?

Staff [blogs:syslog] -- When writing earlier this week about Adobe's sponsoring of the SQLite project, I ran into a complicated issue: is software released into the public domain also open-source software? Read more »

CodeGear ready Ruby release

Brendon Chase [blogs:codemonkeybusiness] -- CodeGear have announced this week they will be releasing an integrated development environment(IDE) for Ruby on Rails developers in the second half of 2007. Read more »

Log in


Sign up | Forgot your password?

What's on?