In the June 2003 issue of MSDN Magazine, Aaron Skonnard shows us how to implement the IXmlSerializable interface in order to serialize classes derived from IDictionary. The example deals with simple types such as int and string. I needed to serialize a dictionary of one of my classes. I’ve expanded
Other News
Developing a Database Security Plan
Oracle Security: Chapter 7, By Marlene Theriault & William Heney – There are many steps to securing your system and its data. But one of the first–and one that too few organizations take–is the development of a security policy that outlines and maps out the enforcement of a security plan. We’ve in
Rock-Solid Replication
By Cameron O’Rourke – Replication involves synchronizing some or all of your application data across multiple databases in a distributed system. In this column, I explain why you might use replication and describe some Oracle technologies you can use to implement it.
Getting started with DB2 application tuning
This article looks into some of the steps necessary to locate and tune DB2 application performance problems. It will: Discuss the tools and structures needed for DB2 tuning.
IBM Integrated Cluster Environment
The IBM DB2 Integrated Cluster Environment for Linux is a completely integrated, high-performance and pre-tested solution that incorporates best-of-breed software, hardware and services. It provides you with a high performance, reliable data management system that can scale from 2 to 1,000 nodes. Yo
Speed SQL Server Development with mssqlXpress
by Randy Dyess – MssqlXpress is a small tool that goes a long way in replacing the old standby that many of us use every day: Query Analyzer. While the developers have not recreated all the functionality of Query Analyzer yet–they still need to create execution plans before mssqlXpress will replace
SQL Server 2000 Web Services Toolkit
Download the Microsoft SQL Server 2000 Web Services Toolkit to get tools, code samples, white papers, and SQLXML 3.0—everything you need to build XML Web services and Web applications with SQL Server 2000.
spAllTables
This script the full version of an example script for my article Is a Temporary Table Really Necessary? and will loop through all databases obtain the user tables in the database and perform an action on each of those tables (in this case sp_spaceused) without the use of a cursor or an undocumented
Pressing for the Nines?
By Brian Moran – Thinking about an unscheduled reboot, just for the heck of it? Forget about it. Microsoft is always looking for ways to improve SQL Server so that customers can achieve higher levels of availabilty.
Book Review: “Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide”
Joe Lax used this book to study for both the Administration and Backup exams that are part of the Oracle Certified DBA program. Find out why he feels this is a great text to study from.