DatabaseJournal.com Staff

>>Script Language and Platform: SQL server 2000 During migration you might come across situations when you have to change the database’s collation and all its table columns. This script will help you fix the collation without having to go through resetting collation for the master or DTS. You still can use Backup & Restore and […]

Rob Garrison is a database architect at Fiserv in Portland, Oregon specializing in OLTP design and development. He has over twenty years of IT experience, with over ten years in database development and architecture.   Current Articles Article Series

[From Oracle Corp.] REDWOOD SHORES, Calif., 12-DEC-2006 05:00 AM Celebrating more than a decade of providing highly productive tools and technologies to the developer community, Oracle today announced that Oracle Technology Network (OTN) now has more than five million worldwide members. Exemplifying Oracle’s commitment to facilitating application development and working closely with the development community, […]

Browse our articles by author: Dave Aldridge Michael Aubert Neil Boyle Steve Callan Vincent Chan Alexander Chigrik Jim Czuprynski Sumit Dhingra Rob GarrisonIan Gilfillan Sean HullMarin Komadina James Koopmann Gregory A. Larsen Eli Leiba Danny Lesandrini Muthusamy Anantha Kumar aka The MAK Nandeep Nagarkar Alexzander Nepomnjashiy Andrew Novick Amar Kumar Padhi William E. Pearson, III […]

by JP Vijaykumar Though the title says “A Simple Security Approach Part II”, the topics covered in this article are COMPLEX in nature. Welcome to the world of complexities in database access and security. This document describes setting up column level / row level security of data through custom built views, and a critical review […]

>>Script Language and Platform: Oracle 8i, Win2k This script will backup databases using the RMAN utility with remote Catalog (db-lin used). Author: SNUS Download Script: snus_backup.zip 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. […]

>>Script Language and Platform: Oracle If you want to copy the data from one database to another having many tables and constraints, all you need is this script, which will first disable all the constraints, delete the prior data, then copy the data from any remote database and finally enable all the constraints on the […]

[From Oracle Corp.] REDWOOD SHORES, Calif., 06-DEC-2006 05:15 AM Building on its comprehensive portfolio of identity and access management offerings, Oracle today announced availability of the Oracle(r) Enterprise Single Sign-On Suite. The Suite is a component of Oracle Identity Management and helps simplify and improve security by providing single sign-on, access control and password management […]

>>Script Language and Platform: MS T-SQL Do you have more than 10 sql servers you must manage? Most DBAs do; I have over 120 SQL instances to manage. I used to use ISQL/OSQL in a batch to execute a command on all of these instances. It works but not very nicely. Below is the code […]

[From eSecurityPlanet] Oracle database users take heed: December may be a tough month. A security researcher is warning of a week of Oracle database bugs. The revelation comes after Oracle’s recent quarterly patch cycle for its namesake database. It typically yields double-digits’ worth of fixes for security flaws. For example, Oracle released an update at […]

[From InfoWorld] Database security researcher Cesar Cerrudo is taking a page out of the MetaSploit Project playbook, annoucing that his company, Argeniss Information Security, will publish a previously unknown (zero-day) vulnerability for Oracle databases each day for the first week in December, according to a message posted on the Argeniss Web site. The article continues […]