(Rafe Colburn) One feature that seems to eventually creep into every web application is the ability to send email. Generally, it’s a very specific kind of email, like a password reminder, welcome message, order confirmation, or receipt. Despite the fact that the content of these emails differs from
Other News
Learn XML Parsers Tutorial
In the XML Parsers Zone you will learn about the Microsoft MSXML XML Parser (now renamed Microsoft® XML Core Services) and how to make use of it in your applications.
Oracle 10g Top 10 New Features
The latest release of Oracle Database 10 g contains new and improved functionality that directly benefits Business Intelligence & Data Warehousing applications. Here’s our top ten list of new features.
Oracle Tip: Use the correct looping control in PL/SQL
When you process an index-by table in PL/SQL, there are times when you cannot be sure of the indices that exist on the table, so you can’t use the most obvious form of the FOR loop to loop through values.
SQL Server 2000 Security – Part 5 (Application roles)
(Marcin Policht) In our previous article, we started our discussion about SQL Server 2000 authorization, focusing initially on permissions assigned to standard fixed server and database roles. We also explained that on the database level, SQL Server 2000 provides more flexibility, since it allows yo
Introduction to Database Replication
(Baya Pavliashvili) SQL Server 2000 supports three distinct types of replication: snapshot, transactional, and merge, each of which has its own purpose.
Creating a Script from a Stored Procedure
(Ryan Randall) A simple task, I thought, but it took me to some interesting places. The method is broadly this: 1) Create an instance of SQL-DMO SQL Server, and use the script method to save the create table text in a file. 2) Get the text from the file into a sp variable. 3) Delete the text fi
DB2 Command Line Processor Tips and Tricks
(Paul C. Zikopoulos and Roman B. Melnyk) If you are an experienced database administrator (DBA) you likely use a mix of graphical user interface (GUI) tools and the IBM DB2 Universal Database (DB2 UDB) command line processor (DB2 CLP) to accomplish your day-to-day tasks. In some cases, the diffe
Data Mining For the Masses
(Seth Grimes) Data mining as an analytic discipline is neither as obvious as query and reporting nor as carefully positioned, marketing wise, as online analytic processing (OLAP). It encompasses several disparate techniques, and, although it has achieved noteworthy results in applications such as cr
Tip: Use XML to send SMS messages
(Nicholas Chase) Many developers tend to think of Web services as a way to easily move information from one place to another, but it’s important to realize how integral a Web service can be to the overall application. This tip gives some examples of using XML for Short Message Service (SMS) messages