DatabaseJournal.com Staff

[From PHP Builder] The Structured Query Language, SQL, which is commonly pronounced as if it was a word – “seekul”, is used to access a database in a modern database management system (DBMS). Now, before we get into coding specific commands in PHP, it is very worthwhile to get an overview of the basic elements […]

[From Dundas Data Visualization] ORLANDO, FL (June 4, 2007) – Dundas Data Visualization announces Microsoft Corp. has acquired Dundas’s data visualization technology, which will be part of the final feature set for Microsoft SQL Server 2008 Reporting Services. The Dundas products to be incorporated into SQL Server 2008 include Dundas Chart for Reporting Services, Dundas […]

[From Network Times] At Microsoft’s TechEd conference in Orlando, Oracle is announcing beta versions of a couple existing tools that help .NET developers work with Oracle databases, plus a new tool for writing applications that store web session data in Oracle databases. Oracle is adding a new feature to Oracle Developer Tools for Visual Studio […]

[From Highwire Development] Periscope captures SQL performance metrics and provides a central repository for analytical data. It’s near zero overhead architecture allows for 24/7 monitoring, and it’s reporting modules let you drill down into the real story behind your SQL performance. Periscope v5.5 includes enhanced reports, better SQL statement grouping, and more precise hardware to […]

[From DB Solo] Nashua, NH – 6/5/2007 – DB Solo LLC is pleased to announce the general availability of DB Solo SQL Query Tool 2.2, the latest upgrade to DB Solo’s sophisticated cross-platform SQL Query Tool. DB Solo provides developers and administrators with a wealth of advanced features such as visual explain plan, database comparison […]

[From Mentat Technologies] Mentat Technologies announces the first version of the DreamCoder for MySQL tool with multi language data support now supported. DreamCoder for MySQL replaces the popular MySQL Turbo Manager. For more information: http://www.mentattech.com/themes/mentat/mysqlmanager/index.html You can download DreamCoder for MySQL at: http://www.mentattech.com/themes/mentat/download.html The article continues at http://www.mentattech.com/themes/mentat/news/news-mysql.html

Microsoft® Office Access 2007 Forms, Reports, and QueriesPaul McFedriesMay 2007, Paperback, 408 pages ISBN10: 0789736691Publisher: Pearson EducationBuy this book This excerpt from “Microsoft Office Access 2007 Forms, Reports, and Queries” introduces several techniques that serve to either make data entry less of a chore, or to reduce or eliminate data entry errors (or both). Chapter […]

[From EMS Database Management] EMS Database Management announces SQL Manager 2007 for PostgreSQL – the new major version of the PostgreSQL administration and development tool. New in SQL Manager 2007 for PostgreSQL: UTF8 support, all wizards working in the background mode, query execution in the background mode, improved SQL Editor, Database Statistics and much more… […]

[From Builder.com] When data in a database is read or modified, the database engine uses special types of controls, called locks, to maintain integrity in the database. Locks basically work by making sure database records involved in a transaction cannot be modified by other transactions until the first transaction has committed, ensuring database consistency. The […]

[From Developer.com] In this article, we’re going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL’s implementation is a fascinating mix of technology that is truly a remarkable achievement—an achievement born from the sweat and […]

[From SQL Maestro Group] SQL Maestro Group announces the release of MS SQL Maestro 7.5, a Windows GUI solution for Microsoft SQL Server administration and database development. New version introduces support of Service Broker objects (queues, message types, contracts, services and conversations), the Process Browser tool, updated SQL Editor and some other features. The article […]

Sean Hull is a business and technology consultant, author and speaker. He is the founder and senior consultant at Heavyweight Internet Group in New York and has worked as a database consultant and expert for ten years. He is the author of “Oracle and Open Source” on O’Reilly & Associates and his articles have appeared […]