DatabaseJournal.com Staff

[From Knight Consulting] Identify data differences between two SQL resultsets. Most tools of this type will only allow you to compare the data from two identical tables within a database from the same vendor. This tool will let you query two different databases, each with a custom SQL statement, then compare the data returned from […]

[From Imperva] Imperva announces the SecureSphere Universal Visibility Architecture, which monitors all database activity regardless of the method used to access the database. SecureSphere is the first network-based database security and compliance product capable of providing full visibility into local events initiated by privileged users and automated maintenance tasks using IPC (Inter Process Communication) mechanisms. […]

[From Core Lab] MySQL Developer Tools is an add-in designed to simplify the MySQL database application development process. It integrates into Visual Studio and Delphi, making all database development and administration tasks available from your IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements and queries, etc. The […]

[From Microsoft TechNet] SQL Server 2005 is an ideal database platform for use in shared and dedicated Web hosting environments. This paper provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scripts for provisioning users and databases for use in […]

[From Datasparc Inc.] DBHwak is a Web-based Oracle tool that provides convenient database administration and development from home, office, or remote locations. It allows developers and DBAs to do various database tasks such as browse database objects, create new objects, view dependencies between various objects, generate DDL, execute SQL queries, run Explain Plan, and export […]

by JP Vijaykumar Prelude 02:00 AM Boss: Reclaim every byte of free space from other tablespaces in the database/ server that are not 100% full and allocate to EMP_TBSP01 tablespace, which is 100% full. OncallDBA (Oracle): I need to resize, at least a few dozen datafiles to get 1 GB of free space on the […]

This excerpt from “SQL for MySQL Developers: A Comprehensive Tutorial and Reference” discusses adding aggregation functions to a select block with the use of a GROUP By clause. SQL for MySQL Developers: A Comprehensive Tutorial and ReferenceBy Rick F. van der LansPublished by Addison Wesley ProfessionalISBN-10: 0-13-149735-9Published: Apr 20, 2007Dimensions 7×9-1/4 Pages: 1032Buy this book […]

[From SQL Maestro Group] SQL Maestro Group releases freeware PHP Generators for MySQL, Oracle, PostgreSQL, MS SQL Server, SQLite, Firebird and MaxDB database servers. Each generator is a powerful GUI front-end that allows you to generate high-quality PHP scripts for the selected tables, views and queries providing the ability to further work with these objects […]

[From netForensics, Inc.] netForensics, Inc. announced the launch of nFX Data OneTM, a comprehensive security data monitoring solution for Web and database applications vulnerable to insider threat and application-layer attacks. nFX Data One together with nFX Open Security Platform (OSP) provides organizations the ability to identify and remediate threats from the perimeter to the core […]

[From EMS Database Management Solutions, Inc.] EMS Company is pleased to announce the new major version of the powerful MySQL administration and development tool – SQL Manager 2007 for MySQL. What’s new: UTF8 support, all wizards working in background mode, ability to abort queries in the improved SQL Editor and much more. The article continues […]

[From internetnews.com] McAfee on Tuesday announced McAfee Data Loss Prevention (DLP) Gateway, a server gateway that ensures your data doesn’t leave the network if it’s not supposed to. DLP Gateway, which sits at the server and network gateway layer, is a complement to the company’s Data Loss Prevention (DLP) Host, announced in February, which is […]

April, May, June 2009       March 2009   3/23/2009 Policht SQL Server 2005 Express Edition – Part 43 – Service Broker Poison Message Handling MSSQL 3/24/2009 Manning Excerpt Server Consolidation and Virtualization MSSQL 3/25/2009 Callan Connecting Oracle BI Publisher to SQL Server Oracle 3/26/2009 JSC Oracle Database 11g: SecureFiles, Part 3 Oracle 3/27/2009 […]