News (1)

Builder's August Top Ten

Have you missed any of the hottest technology development stories published in the past month? ZDNet Australia's Builder channel can help you keep in touch with the top ten stories of August. Read more »

Features (10)

Use Perl DBI to build portable scripts for database access

Learn this functionality and it will become a staple in your Perl bag of tricks. Read more »

Locking down Microsoft SQL Server

One of the easiest ways to avoid rewrites is to make security a priority during the initial database design. Builder.com shows you how to enforce security at each tier. Read more »

SQL joins made easy

If you're new to SQL, joins can be a daunting concept. There are many different types of joins and seemingly little information available that explains and compares them. But after you digest a few basic concepts, the practice of joins actually isn't very difficult. Read more »

Specify DataSet in XML

This article describes a mechanism that uses a Singleton Factory Class for creating DataSet objects that represent sets of views, locating the base configuration nodes for each view via XPath query. Read more »

Create your own SQL Server views

Follow this step-by-step process from Dan Seewer to build views using Enterprise Manager in SQL Server 7.0/2000. Read more »

PHP gotchas to avoid

When you are debugging PHP code under a tight deadline, start by looking for the most typical problems. Topping the list should be parsing and scope errors. 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 »

SQL basics: Query multiple tables

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

Cool Web tools: four IDEs tested

We stack up four development environments for creating Web-based applications. Find out which one best suits your needs. Read more »

Is SQL a standard anymore?

For many companies, SQL standard conformity is an important consideration when choosing a relational database management system (RDMS), so why is this standard considered optional for database manufacturers? Read more »

Log in


Sign up | Forgot your password?

What's on?