News (3)

Massive SQL-based Web attack decoded

The SANS Internet Storm Center has published details about the massive SQL-based Web attack that occurred over the weekend. Read more »

Zope launch next-generation application server

The open-source organisation has released the first version of Zope X3, which has been completely rewritten to improve the architecture. Read more »

Flaw hunters pick holes in Oracle patches

Oracle, the business software maker that has marketed its products as "unbreakable," faces mounting criticism over its security practices. Read more »

Features (144)

Sometimes a variables table is better than hard coding into a package

When writing PL/SQL packages, there are times where it's better to store a variable in a table instead of coding it into the package. It's most useful for a variable that you might want to change fairly often. 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 »

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 »

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 »

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 »

Build a database front end with ASP

There are many ways to interface with a database, and one solution is to use ASP to build a front end. Builder AU dives in and creates a sample app in this article. Read more »

Optimise your PostgreSQL database with data types

This document outlines the most important data types supported by PostgreSQL, describing when and how each should be used. Read more »

Oracle Tip: Use DBCA to clone a database

Resident Oracle columnist, Scott Stephens shows how to use DBCA to clone a database. 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 »

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 »

More Database, Variable Features Results

Blog (1)

Lets Shindig!

Lana Kovacevic [blogs:webanatomy] -- At this year's Google Developer Day in Sydney, Dan Peterson and John Hjelmstad talked about Apache Shindig, an open source implementation of OpenSocial and gadgets. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

What's on?