(Darren Green) DTSBackup 2000 is a designed to help with both backup and transfer of DTS packages. Whilst it is not recommended as a substitute for your normal file and database backup routines, it is an additional layer of protection, with the benefit of package level granularity. See the article B
Other News
Reading an XLS from SQL Server 2000
(Vinod Kumar) In the first part of the article we have seen how we can write an tables data into SQL Server using simple DTS techniques (read Part I). In this article we look at the other side of getting data out back from an Excel sheet back into SQL Server.
Autonomic DB2 Tools
(Bryan F. Smith) If you have seen the announcements from IBM entitled “E-business On Demand,” you know that an important element of this strategy is autonomic computing. The term is derived from the human nervous system-a system that automatically increases your heart rate when your oxygen supply is
What options do I have when shutting down a database?
Databases can be shutdown with one of the following commands: –shutdown normal –shutdown transactional (Oracle 7.3 and above only) –shutdown immediate –shutdown abort In Oracle 7 or 8.0, these commands must be issued within the Server Manager utility, because shutting down a database
Database Designer Considerations for Oracle Databases
If you are creating database diagrams using the Oracle database server, you can take advantage of features specific to that server. Although the Database Designer is designed to work well with Oracle databases, there are some important differences in how the Database Designer works with Oracle datab
CONFIGURE This! Taking Advantage of Oracle 9i Recovery Manager (RMAN) Features During Backups
(Jim Czuprynski) Oracle Recovery Manager (RMAN) features have been expanded significantly in Oracle 9i. This article discusses several of these new features and includes examples on how to implement them to make any Oracle DBA’s backup, restoration, and disaster recovery plans more effective. Ora
DB2 Backout Point-in-Time Recovery
The native DB2 recover utility always processes logs forward when performing a point-in-time recovery. This means that, in almost every case, either image copies or a pack backup must provide the basis for the log processing. Today, indexes are generally rebuilt from the tablespace data. In DB2 V6.1
Intelligent Documents Headline XML 2003
(Edd Dumbill) At the opening of this year’s XML USA conference in Philadephia, PA, smart XML documents were the star. Keynotes from Jon Udell of InfoWorld and Shantanu Narayen of Adobe focused on XML documents that conveyed the nuance of real world communication. Udell spoke of the importance of
Analyze non-XML data with XSLT
(Chuck White) This tutorial explores how to create string parsing routines in XSLT so that you can tokenize straight, non-XML text, thus turning that text into a series of XML elements. Specifically, this tutorial examines how to convert such documents as weblogs and Web configuration files into XML
Tapping Partner Power
(David Beulke) My job (yours, too, most likely) has gotten tougher lately. I’m doing more work in less time with fewer people to help me. The daily challenges of application changes, on-call maintenance, and opportunities to improve performance would make a great reality TV show — but no one would b