DatabaseJournal.com Staff

[From LogiXML, Inc.] LogiXML, Inc. (www.logixml.com), today announces a new OEM program for software companies using the MySQL database platform. Under this program, companies that are currently or will be OEMing the MySQL database can add the capabilities of the Logi Report business intelligence product at no charge. The article continues at http://www.logixml.com/rdPage.aspx?rdReport=CompanyNews.082207

[From internetnews.com] When it comes to the business of selling technology, two immutable facts emerge: Past is prologue; and it’s always personal. Just ask Larry Ellison and Henning Kagermann, the stars of the latest and, some might say, most vicious revival of an age-old tale that’s been told and re-told throughout the history of American […]

[From Microsoft] Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL […]

by JP Vijaykumar Understanding the characteristics of Oracle’s Synonyms and their object access priorities will help resolve related issues. A synonym is an alias for a schema object. Oracle restricts the length of object names (tables, columns, views, procedures) to 30 characters, but does not impose the 30 characters length restriction on synonym […]

[From SearchOracle.com] Software initiatives related to governance, risk and compliance (GRC) are high priorities for CIOs these days — primarily because of the unprecedented rise in data retention regulations like The Sarbanes-Oxley Act and HIPAA — and Oracle has taken notice. In this podcast interview, Leone breaks down the components of Oracle’s new GRC suite, […]

[From Highwire Development] For a limited time, Highwire Development is offering a free full site license for RAAS Workflow Manager. RAAS – Request. Approve. Associate. Script. Gain control over your database change management process with RAAS. Simply reply to your ‘download complete email’ with “I want it free!” to receive your free license key. The […]

Microsoft® SQL Server 2005 Compact Edition By Prashant Dhingra and Trent Swanson Published by Sams ISBN-10: 0-672-32922-0 ISBN-13: 978-0-672-32922-7 Buy this book IN THIS CHAPTER Introducing ADO.NET Building Applications Summary SQL Server Compact Edition allows you to store data on a desktop or mobile device. A majority of application code consists of retrieving data from […]

SQL 2000 This automated script retrieves the structure of all databases on a given server. A single script with structure(table,index,stored procedure,view,trigger) for each databases on a given server Author: Sonali Patade Download Script: automated.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in […]

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes By Ben Forta Published by Sams ISBN-10: 0-672-32867-4 ISBN-13: 978-0-672-32867-1 Buy this book In this lesson, you'll learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables. Making the Connection Now […]

[From The Australian Software Company] The Australian Software Company has released version 4.1 of their SQL Schema and Data comparison tool “SQL Delta”. As before all support and updates are free of charge. Included now are feature specific ToolTips, Project and Structure Search and comprehensive Tabbed Pages allowing easy switching between tasks. Visit www.sqldelta.com to […]

[From MySQL AB] Overview Submitting patches to Open Source code doesn’t come naturally to everyone. It is not easy, since it requires coding skills that the average user does not have. Moreover, code patches require a fair amount of additional documentation, without which the patch itself is virtually useless. These notes will walk you through […]

>>Script Language and Platform: Oracle Get any database object ddl’s. Author: BHABANI SHANKAR MAHARANA OCP DBA SET long 20000SET pagesize 0SELECT DBMS_METADATA.get_ddl (‘OBJECT_TYPE’,’OBJECT_NAME’,’SCHEMA_NAME’) from dual; Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All […]