Regular expressions represent a powerful tool for describing and manipulating text data. These are supported by a wide variety of programming and scripting languages, text editors, and now by Oracle Database 10g SQL and PL/SQL. It is a method for simple and complex patterns for searching and mani
Other News
Rain Day XML
(John E. Simpson) The five weeks up to and including the middle of September were interesting (to say the least) here in sunny Florida. Depending on how you count, we had somewhere between three and five named tropical storms and hurricanes pummel our coastline and interior. We knew in advance t
Automating Smart-Client Report Deployments
(Anthony Glenwright) This article will show you how to use Microsoft SQL Server’s Reporting Services Web service to install your reports and execute them from a smart client application.
How to change a clustered SQL Server Network Name
Cluster Administrator provides a method to rename cluster resources. To do this, right-click the resource in Cluster Administrator and click Rename. However, if you rename the SQL Server Network Name resource, a variety of situations could occur, the most critical being that the SQL Server virtual s
Understanding Query Filters and Clauses
(Itzik Ben-Gan) T-SQL query can use any of three clauses—ON, WHERE, and HAVING—for specifying logical expressions that SQL Server uses as filters. The three filters play different roles, but sometimes it can be difficult to know which clause you should specify a logical expression in. Most T-SQL
A Preview of SQL Server Yukon From a Developer’s Perspective…
(Chris Sully) The intention of this article is to provide a brief overview of the main features of the new version of SQLServer (Yukon) that will be of interest to developers. Note that the information presented is based on the Beta 1 release. This is not available as of the time of writing, and
Information Retrieval Optimization in OLTP and OLAP applications
(Syed Hasan Adil) Imagine yourself in front of an exquisite buffet filled with numerous delicacies. Your goal is to try them all out, but you need to decide in which order. What exchange of taste will maximize the overall pleasure? Although much less pleasurable and subjective, this is the kind
Application Performance using DBI and mod_perl
A common web application architecture is one or more application servers which handle requests from client browsers by consulting one or more database servers and performing a transform on the data. When an application must consult the database on every request, the interaction with the database
Evolutionary Database Design
(Martin Fowler and Pramod Sadalage) In the last few years, we’ve seen the rise of a new breed of software methodologies, the agile methodologies. These make some new and significant demands on database design. One of the most central of these demands is the idea of evolutionary design. On an agi
Sample Chapter: Efficient PL/SQL
(Garry Robinson) In this chapter, we discuss PL/SQL efficiency. We have deliberately avoided the term “performance” because efficiency is more than just performance. We’ll define exactly what we mean by “efficient PL/SQL” and explain how to ensure that the PL/SQL you build meets that definition.