News (4)

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 »

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 (31)

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 »

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 »

Managed code in SQL Server Yukon: a big deal?

One of the big features of Microsoft's next release of SQL Server is the ability to run managed code. How does it work, and is it a good idea? 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 »

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 »

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 »

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 »

More Code, 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

  • Staff A first look at Windows 7 beta

    In this week's Roundup we show you a preview of Windows 7 beta, cover news from the annual Macworld and more. Read more »

    -- posted by Staff

  • Staff Opera's new SDK: Better browsing on the Wii?

    Opera has thrown a little more love at device developers by announcing an updated version of its software development kit on Wednesday at CES. Read more »

    -- posted by Staff

  • Staff 2008: Time to call stumps

    It's another year down but some things never change. That was shown this week as Internet Explorer remained under fire from yet another zero-day exploit. In other news, we set a hard drive on fire and Apple cans its involvement with MacWorld. Read more »

    -- posted by Staff

What's on?