News (12)

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 »

Can Google break Microsoft's enterprise chokehold?

A tie-up with Saleforce.com sees Google pushing even further into Microsoft's businesss applications territory Read more »

Gates explains why Microsoft needs Yahoo

For a man a few months away from leaving his job, Bill Gates has a lot on his mind. Read more »

The History of Builder AU

Builder AU has turned five and it's time to look back and see how we got here. Read more »

China, Korea and Japan close to open source deal

The three Asian giants plan to collaborate on an open-source alternative to Windows. Read more »

Oracle details post-merger plans

Oracle executives took the stage to rally support for the company's development plans after a recent acquisition tear that has left Wall Street lukewarm on the firm. Read more »

Microsoft XML guru sees power for the people

For some insight into how Microsoft plans to drive upgrades of its nearly ubiquitous Office desktop application suite, talk to Jean Paoli. Read more »

Eight strategies for delivering business intelligence on the Web

These strategies will help companies ensure they are distributing the kind of high-quality, actionable BI necessary to make real-time business decisions. 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 »

Features (72)

Iterating through tables and databases in SQL Server

We look at two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. 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 »

Bulk importing data into SQL Server

If you work with databases, at some point, you'll deal with inserting data into SQL Server from outside data files. This tutorial shows how to import data using the BULK INSERT command and explains how changing some of its options can make it easier and more efficient to insert data. 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 »

Backing up and restoring MySQL databases

MySQL users have at their disposal a built-in suite of advanced tools that simplify backing up and restoring databases. Here are some tips for putting them to work. Read more »

Analyse MySQL databases with SQLyog

MySQL Server enthusiasts can now take advantage of an interface similar to SQL Server's Query Analyser. SQLyog provides the functionality for free. Read more »

Use Jet's ShowPlan to write efficient queries

In large databases, an inefficient query can reduce performance to a crawl. The ShowPlan feature of the Access Jet engine lets you plan more efficient queries, optimise your database, and boost performance. Read more »

Blog (1)

InAccess: Querying .Net

Paul Ayre [blogs:controlaltdefeat] -- INAccess: Tales of woe revolving around the Access Database system Read more »

Log in


Sign up | Forgot your password?

What's on?