(Vadivel Mohanakrishnan) I have seen in the forum that many of the members are either writing sample stored procedure in their questions / answers with a name starting as “SP_”. Its not a good practise and it would have a major hit on the performance of their Database. So just thought of warning the
Author: SSWUG Research
Oracle DBA FAQ – Working with Database Objects in PL/SQL
This is a collection of 23 FAQs on working with database objects in PL/SQL. Clear answers are provided with tutorial exercises on running DML statements, assign table data to variables, using the implicit cursor, defining and using RECORDs with table rows.
On finding changed values in a table with flashback
(René Nyffenegger) The as of clause in a select statement allows to see the data as of a past SCN or past point in time. So, it’s possible, for example, to compare the current data in a table with a previous data set. This is what I try to do.
Multiple form-based programming in ASP.Net
(Sanjay Kumar) The ASP.Net relies on Single Form Interface (SFI) instead of Multi Form Interface (MFI), because SFI is a key element for the implementation of the ASP.NET state maintenance feature. Thus if you host two or more server side form then you will get run-time error ‘A page can have only o
Parse Tab Delimited Log Files With Visual Basic 2005 ‘My’ Namespace
(Mike McIntyre) Fields of data in log text files is often tab delimited. To access the fields of data in a tab delimited log file, or any tab delimited text file for that matter, the file must be parsed. Parsing a tab delimited text file is the process of transforming input text into a data structur
Hyperscale Messaging in .NET with Amazon’s Simple Queuing Service (SQS)
(Gautam Shah) Message Queuing (MQ) has long been a foundation for applications that require asynchronous and disconnected communications. Implementations of Message Queuing such as Microsoft’s MSMQ, IBM’s WebSphere MQ, TIBCO’s Rendezvous, and Progress Sonic’s SonicMQ are all mature, highly reliable,
Licensing distributed DB2 9 data servers in a high availability environment
(Paul Zikopoulos) Customers choose the IBM DB2 data server because of its incredible time to value, its ability to scale and integrate across disparate environments, its robustness, and for the minimization of ‘down-time’ (both planned and unplanned). In this article, I focus on the high-availabilit
Sifting through the different versions of the Web
(Tony Patton) During a recent meeting, a client demanded his application be Web 2.0 enabled; it was clear he had been reading many of the articles out there about Web 2.0. I responded by explaining the evolution of the Web and its technology, and the fact that the Web 2.0 is only a concept. In the e
Using IBM DB2 UDB with IBM System Storage N series
(Alex Osuna, Jawarhar Lal, Roger Sanders and Jeremy Brumer) Database cloning is the process by which you create an exact copy of a DB2 database, either by physically copying the data or by performing what is known as a redirected restore. (pdf)
SQL Server Triggers
(Chris Kemp) Triggers are stored procedures which are fired when data is modified in an underlying table.