DatabaseJournal.com Staff

>>Script Language and Platform: TSQLSQL Server 2000 This script will delete data from every table in the database except those specified in the @NoDeleteLst. @NoDeleteLst = Comma seperated list of all tables you DO NOT want this script to delete. NOTE: Script also includes a split function. Author: Shane Lively Download Script: truncate_db.sql Disclaimer: We […]

[From Softpedia] In light of the upcoming Snow Leopard release, Apple has issued an “ODBC Administrator Tool for Mac OS X,” a software package that enables database administration of ODBC-compliant data sources. Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). The makers of ODBC set a goal […]

>>Script Language and Platform: Delete all the files from the temporary directory, leaving only the recently created last 4 files. Author: JP Vijaykumar Download Script: BeyondFind.txt 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. […]

Doug Steele has worked with databases, both mainframe and PC, for many years. Microsoft has recognized him as an Access MVP for his contributions to the Microsoft-sponsored newsgroups. Check http://www.accessmvp.com/djsteele for Access information, as well as Access-related links. You can reach him at AccessHelp@rogers.com, but note that personal replies are not guaranteed. Current Articles

[From SQL Server Performance] Once the Server Level audits described in Part 1 of the Security Audit series are complete, databases should be considered next. A number of steps can be taken to audit database level security. The article continues at http://www.sql-server-performance.com/articles/dba/security_audit_database_level_p1.aspx

>>Script Language and Platform: Oracle Interval partitioning is a new partitioning feature introduced in Oracle 11g. This is an extension to range partitioning in which Oracle creates a partition automatically when the inserted value exceeds all other partition ranges. Internal partition adds new partitions automatically, but does not drop any old partitions. This script will […]

[From InternetNews] Do enterprise apps make for good virtual appliance apps? According to enterprise software vendor Oracle, they sure do, but they need to have the right technology behind them. Oracle (NASDAQ: ORCL) today unveiled a new open source technology called Oracle VM Template Builder, which enables users to build their own virtual software appliances. […]

[From Oracle Corp.] Enabling customers to further benefit from server consolidation, world-class support, and energy and space cost savings by using enterprise-class server virtualization, Oracle today announced the availability of Oracle VM Templates for Siebel CRM 8.1.1. Oracle VM Templates for Siebel CRM deliver a quick start for a virtualized Siebel CRM, Oracle Database and […]

[From MySQL AB] 11 August 2009 — Joyent, a leading vendor in Enterprise-Class Cloud Computing, announced today that it is taking the proven performance and reliability of Sun Microsystems’ MySQL database to a whole new level by offering optimizations to the Joyent Cloud for MySQL. Joyent and Sun’s database group have teamed up to create […]

[From Linux Magazine] These days InnoDB is the “gold standard” for storage engines in MySQL–both in terms of performance and durability. InnoDB has been around long enough that we kind of take it for granted. It’s been years since arguments like “MySQL doesn’t even have real transactions!” held any water. While I’ve written about some […]

[From InternetNews Blogs] Oracle today announced that it has integrated its value chain planning (VCP) apps into its JD Edwards EnterpriseOne software through a Process Integration Pack (PIP). The upgrade is targeted at three verticals — manufacturing, high technology, and retail goods distribution, an Oracle (NASDAQ: ORCL) representative said in an e-mail to InternetNews.com. The […]

>>Script Language and Platform: SQL Server Script will iterate every field within a database for every occurrence of a specified value. Takes a single string input and does a LIKE search on every field in the database. Outputs a data set for each table and column combination where the specified field value is found. A […]