News (18)

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 »

Sun floats open-source database idea

Sun Microsystems has raised the possibility that it might offer customers its own database, a move that could trigger displeasure at Oracle but curry favor with open-source advocates. Read more »

Open-source projects intertwine for integration

Three open-source projects are teaming up to create an alternative to software-integration products from IBM and other heavyweights. Read more »

IBM barred from US government contracts

IBM has been indefinitely barred from entering into new contracts with the US federal government. 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 »

Mozilla Thunderbird e-mail client finally gets calendar

Mozilla Foundation has finally integrated the Lightning calendar to its latest incarnation of open-source e-mail client, Thunderbird 3.0. Users can also expect improved search. Read more »

Microsoft wants to help reduce medical mistakes

By standardising on a common way to display medical data, Microsoft hopes to reduce the 600,000 errors that take place in US hospitals each year, many of them from medication mix-ups. Read more »

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 »

'Free' is the new 'cheap' for software tools

James Gosling, a vice president and fellow at Sun Microsystems, once quipped that the average software developer spends more on cafe lattes than on tools. Read more »

Oracle's eye on the future

As part of its semiannual analysts' day, Oracle on Wednesday outlined a range of plans for the New Year and beyond, from integration of PeopleSoft technology to its planned entry into the market for collaboration software. Read more »

More Database, Integration, List News Results

Features (141)

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 »

Visualise your database with treemaps

In this tutorial we show you how to generate a simple treemap to show which tablespaces have low percentages of free space and include a sample PHP script to generate the results in a graph. Read more »

Forms authentication in .NET: Using a database

Storing forms authentication information in Web.config has serious limitations. See how to work around them by storing this information in a database. Read more »

Designing databases for reporting brings clients higher ROI

Reports can be the most important part of the database apps you design for clients. The ability to create queries and reports on the fly extends the power of reporting information and creates added value for your clients. 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 »

XPath provides an easier way to select information in Jet database

In the Microsoft .NET Framework, extracting information from a Jet database can be accomplished using SQL queries or XPath. Each method has pros and cons, but you may find yourself using XPath more often as .NET becomes more prevalent. Read more »

Bridge your DB to XML with Java, XML-DBMS

XML-DBMS is middleware that allows database-to-XML conversion, even for non-XML databases. See how to implement XML-DBMS with Java. Read more »

Extend the reach of SQL Server with SQLXML classes in .NET

SQL Server 2000 provides XML features called SQLXML classes that are readily available without drastic changes to database design or related stored procedures. Here are a couple of examples of how to use these powerful features. Read more »

Supersize me-- Access to SQL

Access developers who have ambitions to upsize to SQL Server face several problems. The problem that's the most difficult to surmount is dynamic SQL. Read more »

Cleaning up your ADO.NET mess

Although .NET eases the burden of managing system resources, you're not totally disconnected from the process. Take care to free your database resources! Read more »

More Database, Integration, List Features Results

Blog (2)

Q&A with EditMe: A wiki for non-geeks

Brendon Chase [blogs:codemonkeybusiness] -- Finally, a wiki CMS solution that you can safely give to your clients to use. But sshhhh... don't call it a wiki... Read more »

Know when to walk away, know when to run

David McAmis [blogs:theneteffect] -- As a software developer, there are certain projects you want to avoid. For me, that is usually the project where the end-users design the entire application -- you know the type I am talking about. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

What's on?