(Irina Medvinskaya) You’ll find that using enumeration in your VB.NET code comes in handy whenever you need to establish a set of related constants in your application and set their values. In this quick tip, I give an example of how using enumeration makes code easier to develop and read.
Author: SSWUG Research
How to go hand-in-hand with DB2 and Informix
(Suma C Shastry, Mohan Kumar and Prasad Srinivasachar) Database technology is a constantly growing field of knowledge. Leveraging your current knowledge on one product and applying it to another similar product is one way to keep up with the constant change. This article demonstrates how you can lev
Create Your Own Custom Ajax-Enabled Accordion Component
(Kris Hadlock) Adding massive amounts of data to one web page is not a recommended design approach because it can be completely disorienting to the user, and might cause him to go to another site. There are always exceptions, though, which is the case when using an accordion component to display dat
Oracle 10gR2 Security, Part 4: Securing Data Extracts, Exports and Recovery Files
(Jim Czuprynski) Oracle 10gR2 includes some security features that have been long-overdue: the ability to encrypt DataPump Export dump sets and Recovery Manager (RMAN) backup sets. This article – the fourth and final in this series – discusses and illustrates how any Oracle DBA with a reasonable lev
11i: Transparent Data Encryption Certified with Oracle Applications
Oracle has certified Oracle 10g (10.2.0.2) Transparent Data Encryption (TDE) with Oracle Applications 11i — TDE is part of the Oracle Advanced Security Option (ASO), which is a database option and is an additional cost.
DS4000 Best Practices and Performance Tuning Guide
(Bertrand Dufrasne, Bruce Allworth, Agung Indrayana, Christian Schoessler and Brian Youngs) This IBM Redbook represents a compilation of best practices for deploying and configuring DS4000 Storage Servers. Setting up a DS4000 Storage Server can be a complex task. There is no single configuration tha
New Conference Riveted on RPG and DB2 Education
(Dan Burger) Not everyone believes that continuing education and training is necessary or that it provides a return on investment to businesses that emphasize it with their IT staff. That’s an unfortunate reality in today’s workplace that is more prominent today than it was 10 or 20 years ago. At th
Microsoft’s Lineup of SQL Server Related Webcasts for February 2007
Seven new webcasts are scheduled for February, covering such topics as Migrating Oracle Databases to SQL Server 2005, Managing Team Data with Visual Studio Team Edition and more.
QUEST CODE TESTER : Unit Testing Your PL/SQL Code – III
(Partha S) Quest Code Tester Beta was released last week. As I had pointed out in my last two entries on the tester, I have been having problems getting the Tester to run properly on Oracle 10g XE. The latest beta version 1.5 resolves these issues, and finally I was able to get it to run correctly.
Calculate columns and averages with SQL Server’s HAVING clause
(Arthur Fuller) As an instructor of database language and usage, I find some topics particularly difficult to explain. One of those subjects is SQL Server’s HAVING clause. In this tip, I offer a brief overview of the clause and then provide code examples, which I think best convey the proper usage o