(Mitchell2.24v) This article describes a small utility that can be used to reset a database to a clean state. During development of applications that use databases this may be needed quite frequently. This utility was built quickly and will therefore not win any style points, but it works for m
Author: SSWUG Research
Database Normalization for the Real World
(April Wells) Why is normalization important? Many databases today are still denormalized for many reasons. This article, by April Wells, addresses some of the reasons and normalizes a claim table through the different normal forms for an insurance company. The changes in the table and the addit
Writing Better SQL Using Regular Expressions
(Alice Rischert) A new feature of Oracle Database 10g vastly improves your ability to search and manipulate character data. This feature, regular expressions, is a notation for describing textual patterns. It has long been available in many programming languages and a number of UNIX utilities.
Using a full-text search engine as a driver for native XML databases
(Dr. Hans Henseler) Native XML databases can be used to store XML document collections. Documents can be retrieved from such a database if their filepath is known. To enable contentbased document retrievel, each document should be loaded in an XML parser to check if the contents meet the specified
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
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
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.
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
Regular Expression Sample Application
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
Migrating your Oracle Unix environment to Linux with HP
Join HP experts for an informative UNIX to Linux webcast that examines the compelling reasons so many customers like you are considering making the move to Linux. This webcast will focus on the significant savings on IT operating costs and ROI which can be achieved by moving to Oracle on Linux.