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 »

Tags: authentication, data management, databases, enterprise software, hardware, mysql, open source, postgresql, software, storage

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 »

Tags: cursor, databases, enterprise software, human resources, microsoft sql server, performance, row

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 »

Tags: oracle, pattern, work flow, xml

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 »

Tags: message, oracle, xml

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 »

Tags: data capture, databases, job, microsoft sql server, table

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 »

Tags: databases, hardware, index, microsoft sql server, null, record, storage

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 »

Tags: clause, column, data, record, select, sql, statement, table, value

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 »

Tags: backups, data management, data protection, disaster recovery, server

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 »

Tags: cursor, inventory, microsoft sql server, select

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 »

Tags: databases, field, product, select, storage, table

More >

Log in

News and features

Latest
Popular
Features
Most Discussed

Blogs

Microsoft shows off IE9 preview

This week, highlights from Microsoft's MIX10 conference and more in the Roundup. Read more »

-- posted by Staff
IE9's H.264 vote killed Ogg

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 »

-- posted by Chris Duckett
Google launches Apps Marketplace

Google 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 »

-- posted by Staff