You may not be able to connect to an instance of SQL Server, and you may receive one of the following error messages. Error message 1 [Named Pipes]SQL Server does not exist or access denied. [Named Pipes]ConnectionOpen (Connect()). Error message 2 Unable to connect to server <SQL Serve
Other News
Transferring Operating System Files from within Oracle
(James Koopmann) Within Oracle 10g we are given the opportunity to move operating system files without ever ‘physically’ logging into the operating system itself. This in itself provides us, as DBAs, many options when doing common database administrative tasks that we will typically do. These ta
Terms to know before implementing Oracle E-Business Suite 11i
(Susan Foster) Oracle applications have specific terminology. A sample of terms a user must comprehend before navigating or setting up Oracle E-Business Suite 11i will be discussed below. (R)
9i RAC: Cloning to a Single Instance
(Shankar Govindan) Cloning is a process that most DBA’s are aware of that needs to be done often to keep the production database from being vandalized by then developers and UAT’s. A production database needs to be cloned to test or development or training databases, so that the Application developm
Improve hierarchy performance using nested sets
(James Simpson) This article and accompanying code demonstrates the theory and practice behind “Nested Sets”. The theory is applicable with any type hierarchy in any database, however the example code was written using SQL Server 2000 and every attempt has been made to make it compatible with most
Utility to generate DSN1COPY jobs using the REXX DB2 interface
(Jaiwant K Jonathan) DSN1COPY is an IBM utility that is very useful in recovering dropped tablespaces. When a tablespace is dropped, all references to it are removed from the catalog tables, including the SYSCOPY entries. However, if the DDL of the table, before it was dropped, is available, then, u
News Standards: A Rising Tide of Commodotization
(Jo Rabin) The News Standards Summit took place late last year (December, 2003) in Philadelphia. It examined in some detail a number of standards in the news industry. It led to an open forum on, as described in the agenda, “how to achieve hassle free news exchange”. The goal of the meeting was,
INF: Frequently Asked Questions – SQL Server 2000 – Server
This article covers some of the most frequently asked questions about Microsoft SQL Server 2000, version 8.0 servers.
Its Not Fair! It’s Not a Level Playing Field for DB2 Backup and Recovery
(Jim Mulkey and Nancy Lilly) In the world of DB2 utilities, great emphasis is placed on the contrasts between one vendor’s performance benchmark and another’s performance benchmark. But benchmarks no longer tell the whole story. The requirements for backup and recovery, as well as the method us
Hidden Power of UNION
I used to think that UNION was useful only when you needed to combine the results of two queries from different sources (e.g., tables, views) into one result set. However, using UNION is sometimes the quickest way to select from just one table. (R,$)