News (45)

UK beefs up huge snooping database

The UK Home Secretary has stressed the need for even greater snooping powers for government, even as the country is planning a massive interception database of all communications. Read more »

Sun to subsidise Oracle database software

In a bid to compete better against IBM and Hewlett-Packard, Sun Microsystems said Tuesday it will bundle Oracle's database with higher-end Unix servers and partially subsidise the fees customers would otherwise have to pay to use the software. Read more »

MySQL worm halted

A worm exploiting weak database passwords on Windows computers had essentially stopped spreading on Friday, after the systems infected with the program were cut off from the control of several central computers. Read more »

Microsoft launches long-awaited updates

After a number of delays, Microsoft on Monday launched long-awaited updates to its flagship database programs and developer tools. 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 »

Interview: Red Hat's new CEO

Red Hat's new chief executive officer, Jim Whitehurst, talks about the Linux maker in an extensive interview with ZDNet Australia sister site CNet News. Read more »

Free Google Analytics: A spammer's best friend

Spammers are taking advantage of Google's free Analytics service to track the performance of spam campaigns and boost their business. Read more »

Microsoft targets Oracle licensing to win customers

With the upcoming launch of SQL Server 2008, Microsoft will focus its massive resources on the issue of licensing, in an attempt to win customers for Oracle and IBM. Read more »

India shares open-source experiences

India's National Informatics Center has launched a Web site to share the government's experiences with open-source software. Read more »

Features (208)

Using Object Dependencies in SQL Server 2008

Tracking object dependencies has always been difficult with SQL Server. SQL Server 2008 makes it easier because it tracks dependencies by the object's name rather than ID. Here's how it works. 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 »

Creating and managing a Mysql database with phpMyAdmin

phpMyAdmin is a graphical user interface (GUI) developed in PHP, for creating and managing MySQL databases. Read more »

Comparing SQL Server constraints and DML triggers

This article sheds some light on when to use constraints and when to use DML triggers. Read more »

Defining cascading referential integrity constraints in SQL Server

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point. Read more »

Is LINQ the future of database development?

The LINQ (.NET Language Integrated Query) Project is a Microsoft initiative to standardise data access across not only data sources but also development. Will it revolutionise database development? Read more »

Get your feet wet with Sun's tiny Java DB

Java DB is a lightweight database management system (DBMS) that is written completely in Java. It only needs 2 MB of memory, and it makes it very easy to embed a fully functional database directly into your application. Java DB is also standards-based, supports SQL and the JDBC API, and easily integrates with J2EE. Beginning with the release of Java 6, Sun started packaging Java DB in the JDK. Read more »

Obtain your SQL Server's database location

Do you need to find out where the location of your SQL Server's database is? Use this quick tip from Arthur Fuller to show you how. Read more »

When to use a database-driven Web site

A database back end is a tool that helps fulfill a Web site's requirements. Whether a Web site needs a database back end is a different matter. 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 »

Blog (2)

Oracle's Agile PLM gains popularity

Staff [blogs:syslog] -- I recently spoke to Oracle about their Agile Product Lifecycle Management (PLM) solution, an integrated tool for managing information about a product throughout its lifecycle. Read more »

Be a hero, get a Meego: IT Fund for kids competition.

Staff [blogs:syslog] -- Support the IT Fund for kids and you could win from an entertainment pack worth over $1,000! Read more »

Log in


Sign up | Forgot your password?

What's on?