This script will copy archived redo logs to a secondary standby destination for an NT implementation. This can be necessary if the standby exists on another server which is mapped.
Author: SSWUG Research
Cataloging XML Vocabularies
by Eric van der Vlist – I’ve been involved recently in many discussions and projects oriented around a simple and common question: “how do I create an XML vocabulary?” The formulation was often different — “how do I create a namespace?” or “how do I publish an XML schema?” — but the central issue
Support WebCast: Programming the SQLXML Managed Classes
Wednesday, July 31, 2002: 10:00 A.M. Pacific time – The objective of this session is to introduce the basics (and the architecture) of executing SQLXML queries in Microsoft .NET applications by using SQLXML Managed Classes. Code examples will be presented to illustrate how to execute different types
XML Watch: Finding friends with XML and RDF
Edd Dumbill explores an XML and RDF application known as Friend-of-a-Friend (FOAF). FOAF allows the expression of personal information and relationships, and is a useful building block for creating information systems that support online communities. Code samples demonstrate the basics.
California to cut ties with Oracle
By Alorie Gilbert – California’s doomed $95 million contract with Oracle may be officially canceled in about a week, officials said Friday, after two months of untangling the sprawling six-year deal that united scores of individual contracts under one megadeal.
How 11GB of SQL Server Data Mysteriously Disappeared and How I Ended Up Better Off than Before
by Brad M. McGehee – The previous weekend, I had spent most of it working, upgrading a SQL Server 7.0 cluster to a SQL Server 2000 cluster. Fortunately, the rather complex upgrade went without a hitch. What made the upgrade complex was that the cluster held a 31GB ERP database that was used on a 24/
Five Ways to Rev up Your SQL Performance
By Johnny Papa – In this month’s column I’ll demonstrate four techniques that can be used to either improve your SQL Server™-based application’s performance or improve its scalability. I’ll examine the use of LEFT JOINs, CROSS JOINs, and retrieving an IDENTITY value. Keep in mind that there is no ma
Changing Code Page from SQL Server 7.0 to SQL Server 2000
When you upgrade from SQL Server 7.0 to SQL Server 2000, you keep your existing sort order and code page by default. However, when you perform a clean installation of SQL Server 2000, you get the new sort order and code page. If you attach a database to a SQL Server 2000 instance, SQL Server keeps w
Database Design 101
by Anil Desai – Queries work well if the databases are designed correctly. Here’s what you need to know to build the foundations for your SQL Server databases.
Make SQL Server Respond to an ORDER BY Clause
SQL Server Views don’t support the ORDER BY clause, but that shouldn’t stop you from bringing order to your data. This article teaches you how to sort the results of a View, despite this small limitation.