(Gboyega Sanni) The realization of a service-oriented application is a hybrid process that is still evolving. In this article, we will introduce an emerging concept that may help readers develop such an application based on a new terminology called layered aggregated Web services (LAWS) via XML deve
Author: SSWUG Research
Exploiting SYSDBA Invoker Rights Using Trigger on Database
(Alex Gorbachev) This is a follow up on my previous post about SYSDBA keeping invoker rights when calling PL/SQL procedure. There was no direct privilege escalation but I mentioned that you need to craft your code so that it gets called by a SYSDBA user. This is what we are going to do now and here
Beware: New Query Hints Added to SQL Server 2005
(Brad M. McGehee) If you have spent much time reading the tips, FAQs, and articles I have written on this Web site, you have probably noticed that I am not in favor of using query hints in queries. For those of you who may be a little new to SQL Server, a query hint is a way to force the […]
db2pd to monitor log utilization
(Chris Eaton) Another interesting option on db2pd is the -logs option. This will show you the status of your log archiver as well as how quickly you are filling up your logs.
The Baker’s Dozen: 13 Productivity Tips for Crystal Reports Redux
(Kevin S. Goff) In this follow-up to my January/February 2005 article, “The Baker’s Dozen: 13 Productivity Tips for Crystal Reports and .NET,” I’ll offer some changes to the original article and some new material for Crystal Reports development. While I’ll focus on the version of Crystal Reports tha
Creating a Custom DataGrid Paging Control
(mendhak) As a web developer, you may have come across situations in which you wish you were not stuck with the default paging system provided with the ASP.NET DataGrid. But, at the same time, not having to write a custom DataGrid control or relying on a third-party DataGrid control would have made
Why Haven’t You Started Using Real-Time Statistics?
(Craig S. Mullins) To maintain efficient production DB2-based systems, you must periodically monitor the DB2 objects that make up those systems. This type of monitoring is an essential component of post-implementation duties because the production environment is dynamic. Fluctuations in business act
Unloading Bulk Data Selectively from Large and Heavily Chained Oracle
(Subhra P. Dey) In one of our systems, we have several extract, transform and load (ETL) processes written in Ab Initio that regularly unload the latest changes from very large tables. Many of these processes unload few hundred thousand records in every run. Ab Initio has provided a component (Input
A utility to parse fixed length flat files in C# using XML templates
(Zach Smith) Fixed length flat files hold data without delimiters between the fields of data. Usually the layout of a fixed length flat file is shown in a series of columns with each column having a starting point and a length to indicate the position of the column. This allows developers to parse t
XUL-Enhanced Web Apps
(Cedric Savarese) This article presents a little-known use of XUL (Mozilla’s user-interface language) and shows how to take advantage of its superior performance and accessibility over HTML while maintaining cross-browser compatibility. I will illustrate this using a proof-of-concept JavaScript libr