(Wayne Berry) In previous versions of classic ASP and ASP.NET 1.x, there has always been a requirement that an attachment exist on the hard disk before it can be attached to an outbound email. For example, if you want to attach a file to an email in ASP.NET 1.x, you need to reference a location on t
Author: SSWUG Research
Building and using table UDFs in SQL Server
(Arthur Fuller) Table UDFs (user-defined functions) are one of my favorite features of SQL Server 2000 and 2005. If you’ve never used them, you may be in for a surprise.
Read the Alert.log File
(Seetaram Mehra) This tip lets you read the alert log entries from a SQL query (using SQL*Plus, TOAD, SQL Developer Worksheet, and so on). In this example, the query provides results for database startup_time/shutdown_time along with total number of days up.
Sending Email in ASP.NET 2.0: HTML-Formatted Emails, Attachments, and Gracefully Handling SMTP Exceptions
(Scott Mitchell) As detailed in last week’s article, Sending Email in ASP.NET 2.0, the .NET Framework version 2.0 includes a new namespace (System.Net.Mail) and new classes for sending email. (The namespace (System.Web.Mail) and classes used in the .NET Framework version 1.x still exist for backward
Prepopulation script generator for DB2
(Shishir Narain) Most business applications need data prepopulated within a database before an application can be used. Normally, prepopulation information can come from spreadsheets, flat files, and so on. This data is then abstracted in the form of Structured Query Language (SQL) scripts, a tediou
XML Matters: Lighter than microformats: Picoformats
(Dethe Elza and David Mertz) XML has been used to markup both documents and structured data, which has been variously interpreted as one of its greatest strengths or failings, depending on your point of view. Where the lines blur between document and data XML can be a winner, but as a general soluti
When running ‘SQL Server Management Studio’ the application may load slowly.
Opening “SQL Server Management Studio” may take a unacceptable time to load.
Simplifying SQL Code with the IS NULL Clause & the ISNULL() Function
(DDarren) There are two SQL statements that can save any database programmer a lot of trouble. One simplifies the code needed for conditionals in respect to data filtering, and the other makes sure that data return values are in the format you want them to be. The former statement is the IS NULL cla
CodeSnip: How to Create a Complete Dynamic SQL Statement Using SQL Server
(Nidal Arabi) Microsoft SQL Server 2000 does not allow the use of variables in some parts of your SQL Statement. Two examples of this non use are selecting a variable top number of rows and defining a variable where clause. However, there are several ways to overcome these obstacles. In this arti
Part 15: Creating database using DBCA on Redhat 4.2 Advanced Server
(Tarry Singh) Oracle RAC runs on various platforms. We have looked Windows, and we are almost done with Linux, but how many different RAC configurations are there? Taking a quick look at the Oracle website, we see the following. This applies to Oracle RAC 10gR2.