(Jeff Hunter) This article provides a brief overview on configuring and using Oracle’s Advanced Queuing features using PL/SQL. This will demonstrate the basic functionality of Oracle Advanced Queuing (AQ). AQ was first introduced in Oracle8 and has been extended and improved on into future versions.
Author: SSWUG Research
DB2 Error, UTIL_HEAP_SZ value is too small
This is a DB2 configuration problem where there is not enough storage available in the heap UTIL_HEAP_SZ to process the statement.
SQL Server Security – Encrypting Connections
(Buck Woody) The best security method for a database system is to limit its exposure, removing it completely from the network. Of course, for most of the applications you need to run this isn’t an option. Most database server systems are connected directly to the corporate network, if not the networ
Create Excel-files with a simple class
(e-DJ) When I wrote my latest application, I had to find a way to print data from a CListCtrl. Since I am not very familiar with printing in MFC, I thought about exporting the data to Excel and leaving all the formating and printing to Excel.
Designing Forms for Microsoft Office InfoPath and Forms Services 2007 (Part 1)
(Scott Roberts and Hagen Green) At this point in the book, you not only know how to design form templates that look nice but you can also take advantage of most of the basic (and some not so basic) features available when using InfoPath in design mode. Now you can create professional-looking forms i
Special: A Methodology for Troubleshooting and Tuning SQL Server 2005
Pro-Center Video Programming for IT Professionals
SQL Server Security Workbench Part 1
(Robyn Page and Phil Factor) SQL Server Security is sometimes rather a blind spot to application developers. This has been widely illustrated by the success of very simple attacks on database-driven websites, which would have been prevented by even moderate security measures>
Define and Store MySQL ADO Connection String in VB.NET 2005
(Ernest Bonat) In Windows and Internet web business applications development the connection to the MySQL database server is critical and requires high-level of security. In ADO.NET database technology the connection is defined in the Connection String property of the connection object. Defining and
ASM Enhancements
(Sreeram Surapaneni) ASM enhances the performance that raw disks provide, without the pain or difficulty of administrating the raw disks. Moreover, ASM provides storage mirroring policies that can be configured on a file level rather than at the volume level that traditional volume managers provide.
UDR enhancements in IBM Informix Dynamic Server V10
(Vinayak Shenoi) This article explores the following enhancements to the user-defined routine (UDR) feature available in Informix Dynamic Server: –Multiple OUT parameters (Dynamic Server 9.4 and above) –Multiple INOUT parameters (Dynamic Server 10.00 and above) –Named return parameters (Dy