Users demand not only performance and scalability, but availability of the applications they use. Achieving high availability requires a whole solution, part of which includes the SQL Server 2000 Server failover clustering. This white paper will explain what failover clustering is: how it works, con
Author: SSWUG Research
DBCC IndexDefrag is your Friend!
(William Ryan) Quite often, databases evolve into things that their original designs never had in mind. This usually isn’t good. There’s also not much you can do about it, ‘feature creep’ is a fact of life in the IT field. However, as a develoep or DBA, you often get ‘deal breaker’ requests that
Successfully installing Oracle Applications 11i on Windows 2000/NT, part 1
(Richard Stroupe) Oracle provides a utility, called RapidWiz, to automate the 11i Apps installation process. RapidWiz prompts the user for specific locations of prerequisite software, as well as the locations to install the underlying components used by the E-business suite. All three tiers are inst
Walkthrough: Encrypting and Decrypting Strings in Visual Basic
This walkthrough shows you how to use the DESCryptoServiceProvider class to encrypt and decrypt strings using the cryptographic service provider (CSP) version of the Triple Data Encryption Standard (TripleDES) algorithm. The first step is to create a simple wrapper class that encapsulates the 3DES a
Performance Monitoring – Garbage Collection
(Raymond Lewallen) I see this topic quite a bit on newsgroups and in microsoft chats. People ask how and what to monitor to check out the performance of their application. First and foremost, I tell people to get CLRProfiler.
Nested declarative data binding in ASP.NET 2.0
(Fritz Onion) I’m becoming more and more enamored with the declarative databinding model of ASP.NET 2.0 the more that I use it. One issue that it deals with rather nicely is the asymmetric nature of join queries and their corresponding update statements, which I find to be one of the most common que
SAP BW and DB2 for z/OS V8
This IBM Redbook describes the benefits of DB2 V8 for SAP. It explains why to run SAP BW in a zSeries environment. It also lists best practices and provides performance and tuning recommendations.
Weaving WebSphere: Secure, Reliable Web Services
(Joe Pluta) “Web Services.” With the possible exception of “object-oriented” and maybe “grid computing,” there hasn’t been a more promise-laden phrase in Information Technology since “CASE.” And while the concept of Web Services hasn’t fizzled out like some of its peers (can you say “Extreme Program
Asked and Answered
(Robert Catterall) We’re considering going to DB2 data sharing to reduce planned outages. We’re currently using z/OS 1.4 (going to 1.7 in a few months) and DB2 V7 (at least a year away from V8). The Central Electronic Complex (CEC) is a 2064-107 running at about 85 percent in prime time. This CEC se
Monitoring Oracle 10g RAC with Quest Spotlight on RAC – Part III
(Tarry Singh) In the concluding part of this series, we will discuss the cluster latency and overhead alarms, the Global cache alarms and the ASM alarms.