Keep OSNews alive by becoming a Patreon, by donating through Ko-Fi, or by buying merch!

Databases Archive

SQL Server 2005 Gets Second Service Pack

Microsoft has released a second free service pack for its popular SQL Server 2005 database application. The update makes SQL Server 2005 compatible with Microsoft's new Windows Vista operating system and Office 2007 suite, and adds a number of data compression, manageability and interoperability enhancements. Microsoft has also changed the terms under which SQL Server 2005 can be run using virtualisation software.

MySQL Quietly Drops Support for Most Linux Distributions

MySQL quietly deprecated support for most Linux distributions on October 16, when its 'MySQL Network' support plan was replaced by 'MySQL Enterprise.' MySQL now supports only two Linux distributions - Red Hat Enterprise Linux and SUSE Linux Enterprise Server. We learned of this when MySQL declined to sell us support for some new Debian-based servers. Our sales rep 'found out from engineering that the current Enterprise offering is no longer supported on Debian OS.' We were told that 'Generic Linux' in MySQL's list of supported platforms means 'generic versions of the implementations listed above'; not support for Linux in general.

Microsoft Beats Oracle in Security Showdown

Microsoft is beating Oracle hands down with the security of its database, according to a new report. David Litchfield, a security researcher with NGS Software, published a whitepaper entitled Which database is more secure? Oracle vs. Microsoft on 21 November comparing the number of software vulnerabilities patched by both vendors in their respective products in the past six years.

Firebird 2.0 Goes Gold

After 2 years in development, the Firebird Project today officially releases the much-anticipated version 2.0 of its open source Firebird relational database software during the opening session of the fourth international Firebird Conference in Prague, Czech Republic.

Oracle Linux Uncovered

"Yesterday Oracle announced the release of their own version of Red Hat Enterprise Linux, simply called Enterprise Linux or 'Unbreakable Linux'. In a remarkably similar move to such projects as CentOS, Oracle have decided to remove all Red Hat specific trademarks and brand it as their own (all quite legit, of course). They will be supplying bugfixes for this new version, and will also be synchronising it with future releases of Red Hat Enterprise Linux. We decided to take a peek at what Oracle had come up with. Read on for a first-look, and the Linux Format team's opinions." In the meantime, Mark Shuttleworth said a partnership with Oracle is no longer a matter of if, but when.

Oracle’s Red Hat Rip-Off

"No one saw this coming. People talked about Oracle making its own Linux, or buying a Linux company (Ubuntu?). But, the news that Oracle is erasing Red Hat's trademarks from Unbreakable Linux and supporting it for less than Red Hat is a bolt from the blue. Or, perhaps, I should say that Oracle is firing a shot at the heart of Red Hat, and commercial Linux? This really, really ticks me off." Apparently, Oracle announced that they will provide full enterprise support for Linux and so it competes with RH.

MySQL Splits Into Enterprise and Community

The popular MySQL database is slated for a future split between what MySQL AB calls the Community and the Enterprise versions. Read the official announcement and further opinions and explanations from Kaj Arno (MySQL VP of Community Relations) and Stephen O'Grady (software industry analist). In Arno's own words: "We recognise that the needs of the MySQL Community are different from the needs of commercial enterprise customers. After 11 years of producing our software, we can no longer hope that a single offering is the best solution for both Community and Enterprise users. Consequently, we are introducing two different offerings for each distinct target group."

MySQL Master Master Replication

"This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability. In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the first one goes up again, it will still be used as slave for the live one. Here is a basic step by step tutorial, that will cover the mysql master and slave replication and also will describe the mysql master and master replication."

Oracle Overhauls Sleepycat’s Original Berkeley DB

The new version of Berkeley DB, the OSS embeddable database Oracle acquired along with Sleepycat, promises better performance and the ability to do upgrades on the fly. But does Oracle really have open source street credibility? One expert says not really. On other DB news, check this audiocast on PostgreSQL while Zmanda launched the first comprehensive backup solution for MySQL.

Eight Key Tools for Oracle Applications Developers

Attendees of the recent New England Oracle Applications User Group conference got a refresher course on some of the key tools that Oracle developers use to customize E-Business Suite applications. Sridhar Bogelli, the leader of the session and founder and chief executive officer of Apps Associates, an application development consultancy, told attendees that properly using the tools provided by Oracle and third-party vendors can help developers and their companies avoid embarrassing, production-related problems.

Using Excel to Analyze MySQL Data

"You might be surprised to know that you can connect Excel to a database, and this isn't limited to databases running Microsoft's SQL. Excel can connect to practically any mainstream database (MySQL, PostgreSQL, Oracle and others), provided that the database offers an ODBC (Open DataBase Connectivity) driver. In this article, you'll learn how to connect MySQL to Excel."