DatabaseJournal.com Staff

[From NuSphere Corporation] New NuSphere PhpED 4.5 with SQLite and FireBird support is released. By now, PhpED has the widest range of supported databases among Php IDEs – MySQL, MSSQL, Oracle, PostgreSQL, SQLite and Firebird. Other nice innovations include: Customizable Multi-Level Highlighting Dynamic highlighting mode Internet Explorer Toolbar for remote debugging The article continues at […]

[From Mentat Technologies] Mentat Technologies is pleased to announce the new version of DreamCoder for Oracle. The New DreamCoder for Oracle includes the most advanced options for database development. It combines the following options : Database data Synchronization, Database Structure Synchronization, Advanced Query Builder, Recycle bin and other powerful options. The article continues at http://www.mentattech.com/themes/mentat/news/news-dreamcoder.html#dreamcoder

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title. Michael Aubert Learn SQL Server 2000 Administration in 15 Minutes a Week Series SQL Server 2000 Administration in 15 Minutes a Week: Table Basics (Part 1)SQL Server […]

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title.

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title.

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title.

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title.

[From PremiumSoft] PremiumSoft released Navicat for Windows ver. 7.1.15. This version supports MySQL 5.0.X and fixed some bugs on the data transfer and other features. Navicat is a powerful yet easy to use MySQL client that provides extensive functionality for managing and developing MySQL. It is also available for Mac OS and Linux. Download a […]

>>Script Language and Platform: T-SQL/SQL Server (All versions) I needed an easy way to add Easter holiday to an events table for a database supporting a web calendar. After a little research, I found an algorithm to calculate the Western traditional date. It works for any year in the Gregorian calendar, any year after 1582. […]

by Sreeram Surapaneni Oracle Database 10g‘s mantra is simpler, more automated database management. We DBAs cannot help but get excited about all the new technology that Oracle routinely releases. With the release of Oracle’s Volume Manager and File system built into the Database kernel (ASM) that enthusiasm cannot be overstated. While this Oracle 10g delivers […]

[From SQL Effects Software] SQL Effects Software has released a free ‘Community Edition’ version of its SQL Effects Clarity Database Comparison software for Microsoft SQL Server. The tool features lightning quick database comparisons, and an interactive side by side GUI review of comparison results. The article continues at http://www.sqleffects.com/Articles/Product/SFXClarityInfo/aboutSFXClarityCommunityE.html

>>Script Language and Platform: SQL Server 2000 This script will Copy GRANT/REVOKE User/Group Permissions. Simply run the script with proper substitution on : source server + source database + source user Copy the results and paste it into Query Analyzer of: target server + target database RUN (: Author: Ajith Dharwar ——-Copy GRANT/REVOKE User/Group Permissions————————– […]