By Keith Regan – A mid-size corporation moving from an Oracle database probably would have to rewrite dozens — at least — of proprietary SQL queries in order to ensure that all of its data migrated successfully.
Other News
Automate scheduled backups for all databases
By Mike Weaver – This script will 1) go through all SQL Server databases on a single server and create a device for each database and 2) schedule a single job with a task for each database to be backed up to a local directory of your choice.
Windows Server 2003 RTM Delayed–Again
By Barbara Darrow – If you don’t like the latest RTM date for Microsoft Windows Server 2003, wait a minute. The latest target date to start duping disks is now March 28, sources close to Microsoft said. A company insider also confirmed that this is the latest proposed release-to-manufacturing
Explain Away Your Troubles
By James Koopmann – Determining when things change in a database is the first step in zeroing in on problems. One of the prime culprits to change is the very SQL that we attempt to run every day. Here is a no-frills method to help sniff out those changes that occur.
Certifying: DBA Fundamentals II
By Jim DiIanni – This column includes a discussion of topics you will likely encounter on the Oracle9i DBA Fundamentals II exam. The Oracle9i DBA Fundamentals II exam is one of two that you must take to achieve the Oracle Certified Professional (OCP) level of certification. In this column, I’ll disc
Move tables between tablespaces
By Sergey Solodilov – This script generates a script that moves tables from one tablespace to another. Also, it rebuildes indexes of these tables and doesn an analysis. The script can be fixed for a range of sizes for tables and size extents for new tables. It is based on an article by Brian Peaslan
Coding Defensively
By Michael Otey – One of the most dangerous system attacks–SQL Injection–is code-based, and defending against it falls squarely on the application developer’s shoulders.
Microsoft Consolidates SQL Server Tools
By Lisa Vaas – Microsoft Corp. has consolidated the database security tools that shield SQL Server 2000 and MSDE 2000 installations from the Slammer worm. SQL Server 2000 SQL Scan, SQL Check and SQL Critical Update are now available in a single download, the SQL Critical Update Kit, which can be dow
Integrate XML Into ASP.NET Web Sites
by Dan Wahlin – Learn how to integrate XML into an application that relies on .Net classes to generate topical information from any XML source.
A close look at incremental builders
In his latest installment on Eclipse and XM, Benoît Marchal implements a builder that recompiles the project automatically when a file is added or changed. He also looks into future enhancements for XM.