DatabaseJournal.com Staff

Roger Burkhardt president and CEO of Ingres, as well as columnist at Dr. Dobb’s, makes his predictions for the open source market in 2010. After reading these seven predictions it would seem that the economic issues we’ve started to emerge from have helped solidify the value of open source. So much so that not only […]

There has been quite a bit of confusion as to the fate of MySQL after the acquisition of Sun by Oracle. If you’ve missed this one, Oracle has publicly pledged 10 items they promise to do regarding maintaining MySQL—stating: Continued Availability of Storage Engine APIs—not only will Oracle maintain but they will periodically enhance MySQL’s […]

[From eWeek] It’s been a long, strange and expensive trip for Oracle in its quest to add Sun Microsystems to its list of company acquisitions. And the final chapter isn’t yet written. This started in early 2009 when word got out that Sun was up for sale. The article continues at http://www.eweek.com/c/a/Data-Storage/Oracles-15-Key-Plot-Points-in-Its-Struggle-with-the-EC-Over-Buying-Sun-Microsystems-775347/

Oracle’s SQL Developer is a fully supported and free tool from Oracle for database development; enabling you to browse objects, run SQL, and create, edit, and debug PL/SQL. Today, Oracle announced the newest release (2.1) of Oracle SQL Developer that introduces: PL/SQL Unit Testing — enabling developers to build and share unit tests, access prebuilt […]

[From SQL Server Magazine] Considering that SQL Server 2008 R2 is an interim release, Microsoft has introduced many significant changes in this R2 release. While many of the major changes like the PowerPivot feature are in the BI space, other big changes exist as well, such as the new editions of SQL Server 2008 R2, […]

With 2009 coming to a close there is bound to be some database resolutions, as well as the attempt to pinpoint the major events of the year into a top 10 list or some sort of recap. Well, Shayna Garlick over at SearchOracle.com has put together a “The Top 10 Eye on Oracle blog posts […]

Last week, Oracle CEO Larry Ellison made comments to the effect that Oracle Corp. will not be competing against the likes of HP and Dell in the commodity server market. Instead, said Ellison, “Oracle will focus its Sun franchise on high-end servers, leaving other hardware providers to duke it out”—concentrating on large Sparc-based SMP servers. […]

When selected a database platform for your business application it is important to review the key players in the database space. Before you pick a vendor, you need to know it will meet your business requirements. You want to be sure once you pick a solution it will meet your short and long term database […]

In these economic tough times, corporations are looking for ways to control and tighten their spending. Have you been tasked with identifying ways to reduce your total cost of ownership for SQL Server? If so then maybe you should consider how consolidating your SQL Server environment might help reduce your long term SQL Server costs. […]

Available now, from The MySQL developer community, is the Milestone release, 5.5-m2. A quick rundown of the release notes include semi-synchronous replication, enhanced partitioning syntax, and SIGNAL and RESIGNAL methods to programmatically return errors. Additionally the InnoDB Plugin is included is included in 5.5 as the built-in version with performance, scalability, and reliability improvements. And, […]

>>Script Language and Platform: MS SQL Server This script will get the last day of the month. Author: Ram Ramamoorthy SELECT (CASE MONTH(GETDATE()) WHEN 1 THEN 31 WHEN 2 THEN (CASE YEAR(GETDATE())%4 WHEN 0 THEN 29 ELSE 28 END) WHEN 3 THEN 31 WHEN 4 THEN 30 WHEN 5 THEN 31 WHEN 6 THEN 30 […]

>>Script Language and Platform: SQL To avoide ARC_Triggers creation, you can use DEFAULT column values. Author: Paul Nersesov drop table abc_test; create table abc_test ( col_id number, col_1 number default 99999, create_date date default sysdate, create_user varchar2(30) default user ); insert into abc_test(col_id) values (1); select * from abc_test; /* COL_ID COL_1 CREATE_DA CREATE_USER ———- […]