DatabaseJournal.com Staff

[From EnterpriseDB] WESTFORD, Mass., June 16, 2009 – EnterpriseDB, the leading enterprise open source database company, today announced the general availability of the latest version of Postgres Plus Advanced Server, the company’s flagship RDBMS product, which is based on the award-winning PostgreSQL open source database. More than 300 beta customers tested the product prior to […]

[From Packt Publishing] Schedule, manage, and execute jobs that automate your business processes Automate jobs from within the Oracle database with the built-in Scheduler Boost database performance by managing, monitoring, and controlling jobs more effectively Contains easy-to-understand explanations, simple examples, debugging tips, and real-life scenarios The article continues at https://www.packtpub.com/mastering-oracle-scheduler-in-oracle-11g-databases/book

>>Script Language and Platform: Unix shell script (Solaris) for Oracle Look for Object Name and for how long the Lock has been there (Locked Time in Sec). If necessary the DBA may need to kill the session/process. Author: Susmit Sarkar Download Script: database_lock.sql Disclaimer: We hope that the information on these script pages is valuable […]

[From PRWeb] Rolling Meadows, IL (PRWEB) June 10, 2009 — Train Signal, today announced the release of the company’s new SQL Server 2008 Administration Training. This is the first course ever released by Train Signal featuring SQL Server topics. The article continues at http://www.prweb.com/releases/SQL-Training/Computer-Training/prweb2517494.htm

[From SQL Server Magazine] YourSQLDba is a stored procedure that uses T-SQL to perform routine database maintenance tasks. YourSQLDba automates database and log backups, consistency checks, and other preventative database maintenance tasks. YourSQLDba works with SQL Server 2008 and SQL Server 2005 in 32-bit and 64-bit environments. The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=101795

>>Script Language and Platform: SQL Server This function finds all the numbers in a string. Example. select dbo.udf_findallnumbers (’12sfg34′) –results 1234 select dbo.udf_findallnumbers (‘asas123’) –results 123 select dbo.udf_findallnumbers (‘assd123jdh556jdfd4j56j78’) –results 12355645678 select dbo.udf_findallnumbers (‘sadasd’) –results 0 select dbo.udf_findallnumbers (‘sadasds65’) –results 65 create table test (name varchar(100)) insert into test select ‘A2b4b2b5bb6bb8bb9’ insert into test select […]

[From Oracle Blogs] Tom Kyte, renowned Oracle DBA and founder of Ask Tom, will be presenting at three upcoming Oracle Technology Days where he will discuss the benefits of upgrading to Oracle Database 11g. Oracle experts from Advanced Customer Services and the Database Center of Excellence (COE) will also share best practices – from planning, […]

>>Script Language and Platform: Oracle In one of my Oracle projects, I had a unique requirement. I needed to create a user, if the user did not exist in the db. Drop the user, if the user exists in the db. This is something similar to the SQL Server feature “if exists(….), if not exists( […]

>>Script Language and Platform: SQL*PLUS Using cascade constraints you can drop all tables from user schema. Author: Paul Nersesov SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET HEADING OFF SET MARKUP HTML OFF SET ESCAPE SPOOL drop_tables.sql select ‘drop table ‘, table_name, ‘cascade constraints […]

[From MySQL AB and Sun Microsystems, Inc.] During my years as an application developer I was most in my element when working on projects that involved building applications from the ground up. Somehow taking user and customer pain points and requirements and turning them into a working solution was much more satisfying than upgrading an […]

>>Script Language and Platform: Oracle In one report, I have to display the matched records from tables A and B, unmatched records from table A, unmatched records from table B–similar to a full outer join. Due to some constraints I can not use a full outer join on my two large tables. Author: JP Vijaykumar […]

>>Script Language and Platform: Oracle SQL Useful on Oracle 8.1.7 onward or remove the dba_temp_files line & run for earlier versions. Author: Arvind Gawade Download Script: physical_actual_size.sql 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 […]