(Carvin Wilson) The SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. The first article in this series entitled “Using the SQL Distributed Management Objects”, provi
Other News
IBM Launching Search Tools For XML Documents
(Clint Boulton) IBM has improved the ability of its content management software to handle XML-based documents, broadening the scope of data types the products can capture, manage and search.
Master the FilteredRowSet Interface for Disconnected Data Retrieval
(Kulvir Singh Bhogal) The latest version of Java, J2SE 5.0 (version 1.5 of the JDK) is the first to deliver the concept of disconnected RowSet objects to the Java language. The FilteredRowset interface extends from the WebRowSet interface, which in turn extends from the javax.sql.Rowset interface.
Oracle: Collecting Real Time Wait Events
(Alexander Bubernak) Wait event tuning has become very popular in recent years. Many DBAs are moving away from the cumbersome Ratio approach of tuning and using wait events. Ratio tuning has been proven unreliable in general and it can lead to a hit or miss way of troubleshooting and fixing problems
Fulltext Search for Firebird SQL
(Dan Letecky) In this article, we will talk about searching the data in a Firebird database using DotLucene full-text search engine. We will focus on storing the index directly in the database (the source code of the solution is attached).
Building a Linux Cluster, Part 1: Why Bother?
(Robert Lucke) Linux clusters have escaped. As the general popularity of the Linux operating system increases, more complex solutions built with it are becoming increasingly common in the “traditional” (more conservative) IT world. Linux computer clusters, whose provenance was originally universitie
Add ‘Select All’ to parameter lists in SQL Reporting
(Sven Cipido) Like every other report, we have some filters when displaying your data. This is also the case for SQL Reporting. But most of the times, those filters have several options to select from. In this article, we will dig deeper into how to add a “Select all” option. With “Select All”, we m
XML on a Chip
(Jimmy Zhang) As the lingua franca of the Internet, XML has become an indispensable part of IT infrastructure. As more web services applications start to exchange XML messages over the network, we begin to see the emergence of the new generation of “XML-aware” network routers and switches. However,
Update a referenced column in a MERGE statement
(Ravinder Bhalla) One of the most powerful features in Oracle 9i and above is the MERGE statement, which lets a single SQL statement either conditionally insert or update a table by selecting rows from another table. If the row already exists, an update is performed; otherwise, an insert is performe
TechNet Support WebCast: I/O performance problems and resolutions in Microsoft SQL Server 2000
This Support WebCast session will explore I/O-related performance problems and resolutions for Microsoft SQL Server 2000. The session will discuss in-depth monitoring of I/O using System Monitor and Profiler, and will briefly introduce features of MOM 2005 SQL Management Pack. The WebCast will outli