(James F. Koopmann) Often times a single search condition with a singe WHERE clause is not enough and we need to search on multiple conditions.
Author: SSWUG Research
Generating Office Documents using the New XML Open File Formats
Generate, read, and modify documents without going through the object model of the hosting Office application. (video)
Working with Web Services Using ASP.NET
(Sanjit Sil) XML Web Services provide a simple technique for accessing a method on an object that is running on a local or remote computer. Web Services can be accessed by an application written in any language and running on any operating system. They utilize HTTP as the underlying transport, whi
Mastering OLAP Reporting: Prototype KPIs in Reporting Services
(William Pearson) In Mastering OLAP Reporting: Reporting with Analysis Services KPIs, a member of my Database Journal MSSQL Server Reporting Services series, we introduced an exciting new feature within MSSQL Server 2005 Analysis Services (“Analysis Services”), Key Performance Indicators (“KPIs”). I
XML Matters: Roundup of XML editors, Part 1
(David Mertz) In this two-part series on XML editors, the author looks at the progress of commercial tools in the year-and-a-half since he last looked at this tools category. These tools have progressed from largely cosmetic wrappers around text editors to fleshed-out development environments that s
Handle bulk binding exceptions in PL/SQL
(Bob Watkins) Bulk binding in PL/SQL is an important technique for efficient processing of dynamic DML. Instead of looping within your program, and submitting one UPDATE statement with each iteration, you use the FORALL statement to submit a single UPDATE statement with bind variables in it. Collect
FIX: The ‘Audit Logout’ event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000
When you run a profiler trace against a linked server instance in Microsoft SQL Server 2000, the Audit Logout event does not appear in the trace results file. This problem may occur in the following scenario: • You have one instance of SQL Server 2000 (Instance A). • Instance A has a linked se
SQL & XQuery tutorial for IBM DB2, Part 2: Basic queries
(Pat Moffatt, Bruce Creighton and Jessica Cao) Through a series of simple examples, this tutorial illustrates how to retrieve data from an IBM DB2 database with standard SQL SELECT statements. This tutorial describes how to retrieve rows from a relational database table, retrieve specific columns, r
How to Build an ASP.NET Web Site Using DB2 Data with Visual Studio 2005
(Paul Zikopoulos) In a previous series of articles, I showed you all the great integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).
.NET Tip: Searching System Event Logs for Valuable Info
(Eric Smith) One of the more tedious tasks a system administrator has to do is review the system event logs using the Event Viewer. These logs can provide valuable information, but manually finding the worthwhile details in them can be difficult. Luckily, .NET provides some easy, automated ways to r