News (7)

IDC Web site defaced by 'eco-terrorists'

The Web site of Global IT research firm IDC has been hacked by a group purporting to be Brazilian environmental terrorists to serve a message urging people to take action over global warming. Read more »

GPL3 welcomed by IBM, Red Hat, Novell, MySQL

Sixteen years after releasing GPL2, Richard Stallman and the Free Software Foundation launched GPL3 over the weekend. Read more »

Sendmail may turn tools over to open source

Sendmail, whose products are built on the software that delivers many e-mail messages, may release some substantial new technology as open source. Read more »

Intel feeds virtualisation's need for speed

With the first generation of Intel Virtualization Technology now being built into most of the chipmaker's products, Intel is turning its attention to improving its performance. Read more »

AJAX spurs Web rebirth for desktop apps

Slicker development techniques like AJAX, a way of building interactive browser-based applications, are fuelling a surge in consumer Web applications. Read more »

Gates trots out Longhorn

Microsoft chairman Bill Gates tried to win over developers in Los Angeles Monday in the U.S. as he offered the first look at Longhorn, the next version of Windows. Read more »

Microsoft places bet on Whitehorse

Microsoft this year will seek to distance itself from Java rivals with tools designed to streamline how Windows-based business software is built and used. Read more »

Features (47)

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 »

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 »

How do I ... reject alpha characters in a SQL Server character column?

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports. Read more »

Running totals in SQL Server queries

This article demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements. 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 »

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 »

Grant Web servers secure database access

Allowing Web clients to access a database is a delicate matter that should not be attempted lightly or without careful consideration. 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 »

Relational databases: The untold story

Discover the origins of the modern relational data model, how rules were set for relational database theory, and how to put the theory into practice. 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 Constraints, Database Features Results

Blog (1)

In a world of Goliaths, who's got a stone?

David McAmis [blogs:theneteffect] -- It seems like it is that time of year again... the days are getting longer, the weather is getting a bit warmer and the top-tier software vendors are on a buying spree. Will you get lost in the shuffle? Why not support your local software developer! Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

What's on?