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
Author: SSWUG Research
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.
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
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
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.
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.
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
How to serialize IDictionary with XmlSerializer
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
How to use XLink with XML
by Brett McLaughlin – Start using XML Schema to constrain XML documents. This brief tip tells how to reference an XML schema from your XML documents. Five pieces of sample code show how.
Comments in a “No comment” World
From XML.com – In this month’s XML Q&A column, John E. Simpson examines two issues related to documentation of, and comments in, XML documents and schemas.