DatabaseJournal.com Staff

[From eWeek] Not to pick on MySQL—I’m glad to see they were picked to be editor’s choice in Builder AU’s recent road test of databases, which compared MySQL, SQL Server Express, DB2 Express and Oracle 10g Standard Edition. “Release 5.0 of MySQL is really taking it to…Oracle and DB2 with advanced features such as cluster […]

Seven new webcasts are scheduled for January, covering such topics as Common Language Runtime Integration, Security Considerations When Upgrading to SQL Server 2005, How Microsoft IT Runs SAP on SQL Server 2005 and more. MSDN Webcast: SQL Server MasterClass: Common Language Runtime Integration (Level 200) Tuesday, January 10, 2006 9:00 AM Pacific Time One of […]

[From SQL Server Magazine] As a DBA, one of your many tasks is to manage your SQL Server databases’ ever-expanding storage requirements. How often do you find yourself adding more disk, trying to accurately size a database, or wishing you could more efficiently use your existing disk capacity? Storing database data on a SAN can […]

by Paul C. Zikopoulos The IBM DB2 Universal Database product (DB2 UDB) comes with countless features and capabilities, among them the DB2 Query Patroller product. For data warehousing, the DB2 Query Patroller (DB2 QP) product can be used to proactively manage users, groups, and queries bound for a DB2 UDB-managed data warehouse. Using the DB2 […]

[From Oracle Corp.] REDWOOD SHORES, Calif., 20-DEC-2005 Oracle today announced that it is integrating Fortify’s source code and analysis tools into the company’s comprehensive secure development lifecycle. Over the past year, the companies have worked together to extend and enhance Fortify’s source code analysis tools to accommodate a code base as large and sophisticated as […]

[From Irish Developer Network] Bangalore, India – December 19, 2005: Webyog Softworks, a MySQL Network Gold Certified Partner and a renowned developer of data management software, today announces the release of SQLyog 5.01. This application serves as a compact Win32 front end for the MySQL database server. SQLyog offers a winning combination of tools for […]

[From PostgreSQL Global Development Group ] In the month since the release of 8.1.0 several minor bugs have been fixed, which have been accumulated into the 8.1.1 release. 7.3.12, 7.4.10 and 8.0.5 patch releases are also available. For a complete list of bugs fixed, please see the appropriate HISTORY file available within each releases tar […]

[From DBTools Software] DBTools Software is pleased to announce the new DBManager Professional 3.2.0. You can check he list of updates and new features at http://www.dbtools.com.br/EN/article.php?id=00060. It supports PostgreSQL, MySQL, SQLite, Ibase/Fbird, DBF, Access, SQL Server, Oracle, Sybase and ODBC. To know more about DBManager: http://www.dbtools.com.br/EN/dbmanagerpro/features.php. The article continues at http://www.dbtools.com.br/EN/article.php?id=00060

[From Business Wire] VERNON HILLS, Ill.–(BUSINESS WIRE)–Dec. 13, 2005–CDW Corporation (NASDAQ:CDWC), a leading provider of technology products and services to business, government and education, today announced new CDW pre-configuration services for Oracle(R) Database 10g software. CDW’s certified technicians will now ship pre-configured and tested solutions that include Oracle Database 10g software on leading hardware platforms […]

>>Script Language and Platform: MS SQLFind the column property from a table. 3 Input——– Table NameColumn NameWhat property of the Column neededOuput——Default property value will be returned. If NULL it will return zero Author: msundartech Download Script:sp_conv_getcolproperty.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the […]

[From LinuxWorld] An update to the widely-used Apache Web server was released last week, offering several feature improvements and fixes from the previous versions. Among the many new modules, programs and feature improvements in Apache 2.2 are new tools for cleaning up a Web server’s cache and support for large files (up to 2GB, i.e. […]

[From eWeek] A major change since SQL Server 2000 is the introduction of the free Express version of SQL Server 2005, designed for smaller-size database applications and to spur developer interest. Oracle recently introduced a beta of its own free offering, the forthcoming Oracle Database 10g Express Edition. The article continues at http://www.eweek.com/article2/0,1759,1894886,00.asp?kc=EWRSS03119TX1K0000594