(Bill Hatfield) Looking for a way to add dynamic pop-out menus to your website? (video)
Author: SSWUG Research
Quest Capacity Manager Review
(Gregory A. Larsen) How much of your time is spent dealing with disk space management issues on your SQL Server machine? What methods do you use to identify which SQL Server databases contain lots of unused space? Do you have the space usage statistics necessary to allow you to accurately forecast t
Create Web services for DB2 stored procedures using Rational Application Developer V6
(Peter Y. Xu) Create DB2 stored procedures, and then expose them as Web services using IBM Rational Application Developer V6 or IBM WebSphere Developer for zSeries V6.
Seven Steps to XML Mastery, Step 1: Read Before You Write
(Frank Coyle) Reading and understanding the structure of an XML document is the first step toward XML mastery. In this first step, we’ll examine RSS, a simple XML vocabulary for describing news stories, weblogs, and just about anything else on the Web that can be summarized and linked to. The power
Optimizing Your Asp.Net Pages for Faster Loading and Better Performance
(John Belthoff) If you read the internet and all of the websites dedicated to Asp.Net you will inevitably read about the wonders of the DataGrid, DataList, and Repeater controls. While each of these has its place, if you are only displaying data there is a much faster and more efficient means to do
Optimising Oracle performance
(Philip Howard) It is rare that I get a chance to use what I learned in my degree course (and even rarer that I remember what I was taught), so it was a pleasure recently to be briefed on BEZProphet, a database performance management tool for Oracle databases.
FIX: You may intermittently experience an access violation error when a query is executed in a parallel plan and the execution plan contains either a HASH JOIN operation or a Sort operation
When you run a query in Microsoft SQL Server 2000, you may intermittently experience an access violation error in the CQList::Remove function.
A Revolution in Database Technology – Oracle Database 10g Release 2
This white paper by Oracle discusses the Oracle Database 10g, Oracle’s largest, most innovative release ever. Product features and capabilities are discussed in detail. (R)
What’s the Data Model Scorecard?
(Steve Hoberman) An application’s flexibility and data quality depend quite a bit on the underlying data model. In other words, a good data model can lead to a good application and a bad data model can lead to a bad application. Therefore we need an objective way of measuring what is good or bad ab
Calculate the Date After a Given Number of Business Days
(Wade Wilbur) An issue came up recently where a client needed to wait a certain number of business days before taking an action. To accomplish this I wrote a user defined function (UDF) in SQL Server 2000.