DatabaseJournal.com Staff

[From SQL Maestro Group] SQL Maestro for MySQL is a MySQL admin tool for database management, control and development. New version introduces improved support for FEDERATED tables, graphical building of queries with UNIONs and subqueries, Italian localization and other features. The article continues at http://www.sqlmaestro.com/products/mysql/maestro/

[From Mentat Technologies] Mentat Technologies announces the release candidate 1 of the upcoming version 4.0 of DreamCoder for Oracle is now available for download. DreamCoder for Oracle DBA 2009 RC1: http://www.sqldeveloper.net/mantis/download-dreamcoder-oracle-beta-2009.php The article continues at http://www.sqlplex.com/articles/oracle/dreamcoder-for-oracle/dreamcoder-for-oracle-4.0-rc1-available-for-download.html

[From PostgreSQL Global Development Group] Lightning Admin Version 1.5 build 30 is available to registered users. This is a big release with several new features. The article continues at http://www.postgresql.org/about/news.1052

>>Script Language and Platform: OracleThis script debugs column length mismatch in Oracle tables and joins the matching rows through an equi join. Author: JP Vijaykumarjp_vijaykumar@yahoo.com Download Script:Debugging-Column-Length.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole […]

[From PHP Builder] One of the most frequently asked questions about PHP is “how can I use PHP to upload an image”. In this article we’ll discuss the details of how you can do just that! The article continues at http://phpbuilder.com/columns/bokeh20090129.php3

[From InternetNews] The Uptime Institute is preparing to release a series of case studies that show many datacenters are not well managed and could become much more efficient without having to spend a dime on new gear. The research was done in 2008. The article continues at http://www.internetnews.com/hardware/article.php/3799451/Clean+Your+Datacenter+Cut+Your+Electric+Bill.htm

[From Oracle Corp.] To assist organizations seeking to further mitigate security risks, satisfy compliance regulations, and protect their enterprise databases, Oracle® Audit Vault has introduced support for collecting audit data from IBM DB2 for Linux, UNIX and Windows (IBM DB2) and Sybase Adaptive Server Enterprise (ASE) database servers. Oracle Audit Vault offers organizations a centralized […]

[From Murach] Mike Murach and Associates has just published a 2008 edition of their bestselling SQL book, now entitled Murach’s SQL Server 2008 for Developers. It teaches how to create SQL queries and take advantage of powerful DBMS features (like views, stored procedures, functions, triggers, and cursors) the way the best professionals do. This includes […]

[From Quest Software, Inc.] ALISO VIEJO, Calif., Jan. 21, 2009 – For years, Quest Software, Inc. has provided the SQL Server market with advanced, high-performance backup compression and encryption via LiteSpeed for SQL Server. Now Quest brings this same high-quality, cost-cutting backup and recovery technology to the Oracle platform with the launch of LiteSpeed Engine […]

[From InternetNews] The PHP community is finally getting an update to the Eclipse Foundation’s PHP Developer Tools (PDT) project, an important set of tools for developers that has not been update since the initial 1.0 release in 2007. The article continues at http://www.internetnews.com/dev-news/article.php/3797776/Eclipse+Rolls+Out+PHP+Development+Tools+20.htm

Monitor the free disk space on your SQL Server and send an alert via email or net send if the available space on any of the drives SQL Server resides on is lower than the specified limit. The script could also be scheduled as a job to provide 24/7 monitoring. Supports SQL Server 7 or […]

[From SQL Server Central] If you’ve been around the forums on SQLServerCentral.com, you’ve probably seen me use the term “RBAR”. “RBAR” is pronounced “ree-bar” and is a “Modernism” for “Row-By-Agonizing-Row”. I use the term “RBAR” for anything that isn’t set based. Some others have picked up on it because it’s easy to remember as a […]