DatabaseJournal.com Staff

[From linux.com] With the 5.1.12 release, MySQL will be dropping the Berkeley DB (BDB) storage engine from its list of supported database engines. Some observers have suggested that this move is connected to Oracle’s purchase of Sleepycat, and that InnoDB may be next. However, Brian Aker, MySQL’s director of architecture, says that they’re unlikely to […]

[From msdn] In the first half of 2006, I was commissioned to design a brand new system using Microsoft Visual Studio 2005 Team Edition for Software Developers as the integrated development environment. The system was based on ASP.NET 2.0 and Microsoft SQL Server 2005 technologies, and the tool and the technologies performed well. But on […]

[From Oracle Technology Network] How we look at our data forms our view of the world. Until recently most of us have ignored location because we lacked the tools (or the ability to use those tools) needed to acquire, manage, and present the spatial component of our data. This means we have missed the geospatial […]

>>Script Language and Platform: Oracle In applications, some users need privileges to truncate tables in others’ schemas. Only the schema owner can truncate his/her owned tables. Any user with DBA role granted can truncate tables in others’ schemas. Any user with “drop any table” system privilege can truncate tables in others’ schemas. Without granting DBA […]

[From Builder.com] Bulk binding in PL/SQL is an important technique for efficient processing of dynamic DML. Instead of looping within your program, and submitting one UPDATE statement with each iteration, you use the FORALL statement to submit a single UPDATE statement with bind variables in it. Collections, such as nested tables or VARRAYs, are used […]

>>Script Language and Platform: Oracle Run this script from your sqlplus session to find trace files. You must set TRACE_DIR and ORACLE_SID in this script Put trace in < $HOME/bin > make it executable and run it from sqlplus session. Example: SQL> ! trace Critics, Comment and suggestion are welcome nomiak@yahoo.com Note:You Must Run this […]

[From PremiumSoft] PremiumSoft released Navicat MySQL GUI for Mac OS X ver 6.3.2, which supports HTTP Tunnel, Foreign Key Data Selection, MySQL version 5.X and Triggers. Navicat is a powerful yet easy to use MySQL client that provides extensive functionality for managing and developing MySQL. Download a trial: http://www.navicat.com/download.html. The article continues at http://www.navicat.com/news.html?yr=2006&mth=8

Paul C. Zikopoulos, BA, MBA is the Program Director for the DB2 Evangelist team at IBM. He is an award-winning writer and speaker with more than 14 years of experience with DB2. Paul has written more than 230 magazine articles and 11 books on DB2 including, Information on Demand: Introduction to DB2 9.5 New Features, […]

[From Developer.com] Often in software development, a new tool introduces old, reliable, battle-tested techniques to an equally reliable and mature platform. SQL Server 2005 Service Broker is such a technology. Service Broker brings the world of asynchronous messaging to the SQL Server database platform. The article continues at http://www.developer.com/db/article.php/3623546

>>Script Language and Platform: SQL Server 2000 and SQL Server 2005 This script searches a column on all the databases from a server. Note: Please update @columnnametosearch with the column name that you are searching. Please choose the right script based on your SQL Server version. Author: MAK –If SQL Server 2000 use master go […]

[From Active Database Software] The new version 1.6 of Active Query Builder introduces ability to work in offline mode, loading metadata information from a previously saved XML file. This is very convenient if the component is used to work with a remote database, for example in the ASP.NET environment. Active Query Builder is a powerful […]

[From TechRepublic] Unlike database backup procedures, which can be automated, securing your data from the prying eyes of unauthorized users requires a certain amount of interaction from the system administrator. If you’re using MySQL, there are some easy things you can do to secure your systems and significantly reduce the risk of unauthorized access to […]