(Adam Machanic) If you were to ask a group of database administrators which key personality trait they have that helps them do their jobs well, the most important and popular answer would be an excellent sense of organization. Great DBAs organize everything in the database — from the data itself to
Author: SSWUG Research
Controlling Backups with Database Control
(Steve Callan) The newer version of Oracle Enterprise Manager, aka Database Control, offers an easy way to learn RMAN, Oracle’s server managed physical backup utility. The basic or Oracle recommended version of an RMAN backup is useful, but it is the custom backup which exposes more of RMAN’s capabi
Domain Objects Caching Pattern for .NET
(Iqbal M. Khan) Caching greatly improves application performance because it reduces expensive trips to the database. But, if you want to use caching in your application, you must decide what to cache and where to put your caching code. The answer is simple. Cache your domain objects and put caching
A More Efficient Method for Paging Through Large Result Sets
(Greg Hamilton) It is amazing the amount of cycles, hardware and brain ware, go into paging results efficiently. Recently Scott Mitchell authored an article titled Efficiently Paging Through Large Result Sets in SQL Server 2000 that looked at a stored procedure that returned a particular “page” of d
Central Key Management
(Brian Bayless) I worry about things. For instance, I collect, from a client, data that is sensitive, and I want to encrypt it. It bothers me to pass this data around my network in the clear, possibly even storing it in session data. Securing data in a distributed application is very difficult, invo
JavaScript, the Ajax Web service client language
(William Brogden) These days JavaScript’s main claim to fame is the J in Ajax (asynchronous JavaScript and XML), but as a scripting language it has been popular for years. The scripting language started life as "LiveScript" in Netscape Web browsers, living in the environment of the browser and manip
XML Matters: Pipestreaming microformats
(Dethe Elza and David Mertz) The pipes and streams metaphor is very successful in UNIX, and can apply with varying degrees of success to many other systems. It’s available, in one form or another, in most programming languages and operating systems. In XML usage, the most common form of pipes and st
FIX: You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor
When you use linked servers in Microsoft SQL Server 2000, you may receive one or more of the following error messages: Error message 1 SQL Server Assertion File : , Line = 501 Failed Assertion = ‘FALSE’ Invalid switch value
IBM DB2 Content Manager for iSeries
(Jack Boswell) DB2 Content Manager Standard Edition Version 8.3 provides an entry-level content management solution for small and medium-sized businesses. It shares common code with the Enterprise Edition and provides a single, open, comprehensive, and consistent framework to manage, share, reuse, a
MySQL Data Methods
(Paul Dubois) Virtually everything you do in MySQL involves data in some way or another because the purpose of a database management system is, by definition, to manage data. Even a simple SELECT 1 statement involves expression evaluation to produce an integer data value.