Database
Why PostgreSQL is a better enterprise database than MySQL
This article demonstrates some of the features that make PostgreSQL a standout database. While it's a bit more challenging to set up and use, he thinks it offers much more security, reliability and data integrity than MySQL. Read more »
Comparing cursor vs. WHILE loop performance in SQL Server 2008
This article discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. Read more »
Workflow Patterns
In this serialisation of Chapter 15 from the book Oracle SOA Suite Developer's Guide, we look at some of the more complex, yet common use cases and how these can be addressed in a relatively straightforward fashion by the Workflow Service. Read more »
Message Interaction Patterns
In this serialisation of Chapter 14 from the book Oracle SOA Suite Developer's Guide, we look at the more advanced messaging constructs supported by the Oracle BPEL PM. Read more »
Setting up Change Data Capture in SQL Server 2008
Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. This article shows how to use CDC to easily set up data auditing on your SQL Server system. Read more »
Filtered Indexes in SQL Server 2008
Filtered indexes are a neat feature in SQL Server 2008 that allows you to define indexes on subsets of data. Read more »
10+ tips for working smarter with SQL
The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started. Read more »
Installing Data Protection Manager 2007 as a VM in a lab environment
This article describes how to install DPM 2007 as a virtual machine in a lab environment. Here are the gotchas to look out for and an explanation of the benefits you can realise. Read more »
Avoiding cursors with SQL Server 2005
Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them. Read more »
Perils of adding fields to database tables
If you're not careful, when you add a field to a database table, you may cause all sorts of problems. This article looks at two such scenarios, and how you can plan for their occurrence. Read more »
News and features
- Latest
- Popular
- Features
- Most Discussed
-
Microsoft shows off IE9 previewThis week, highlights from Microsoft's MIX10 conference and more in the Roundup. Read more »
-
In a split decision by the judges, the winner of the W3C/WHATWG video codec consensus is H.264, taking home the future of video playback on the internet while loser Ogg goes home with nothing but thoughts of what might have been. Read more »
-
Google launches Apps MarketplaceGoogle launches and app store, while Mozilla plans to re-write its open-source license. More of this week's news in the Roundup. Read more »
-
Filter protesters brave Vic weather
2010/03/08 13:35:35
-
CNET first look at Google Buzz
2010/02/11 10:42:51
-
Disable Flash on your web browser
2010/02/05 09:35:57
Most popular tags
What's on?
-
Broadband + home phone + PlayStation®3 in a single package price!




