(yas) I was trying to decrease the number of parses for a 9.2.0.7 production database when I realized that the top parsing sql was coming from another database through a database link. This sql has a parse/execute ratio of 1 meaning it is parsed every time it is called. I have searched the bug datab
Other News
Accessing Oracle Database from Microsoft.NET 2.0 using Oracle Data Provider for .NET
(John Charles Olamendy) This article is intended to show how to access the Oracle database using ADO.NET programming model and Oracle Data Provider for .NET (ODP.NET) that Oracle makes available.
Transferring Data Using SqlBulkCopy
(azamsharp) Transferring data from one source to another is common practice in software development. This operation is preformed in many different scenarios which includes migration of the old system to the new system, backing up the data and collecting data from different publishers. ASP.NET 2.0 in
Audit data using SQL Server 2005’s COLUMNS_UPDATED function
(Tim Chapman) Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has been modified, it is also useful to track the individual field names that have been modified. This information is grea
Oops! Were did that piece of data go?
(Willie Favero) In my not to distant past, I spent a bunch of time doing stuff with recovery. In fact, at quite a few past IDUGs, both in the US and Australia, I did a full day seminar on recovery. With my return to IBM, I stopped doing the Sunday seminars. However, when I was given the opportunity,
PHP 5 Security Techniques
(Larry Ullman) With more and more personal information being stored on the Web—credit card data, social security numbers, maiden names, favorite pets—today’s PHP developer cannot afford to be ignorant when it comes to security. Sadly, most beginning programmers fail to understand the truth about sec
9 Reusable Parallel Data Structures and Algorithms
(Joe Duffy) This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal. Selecting the right data structures and algorithms is, of course, one of the most common yet important decisions a programmer must ma
Using delayed JOIN to optimize count(*) and LIMIT queries
(Peter Zaitsev) In many Search/Browse applications you would see main (fact) table which contains search fields and dimension tables which contain more information about facts and which need to be joined to get query result.
Scrum, Agile development methodologies mix with VSTS projects
(Colleen Frye) .NET developers that want to adopt more agile development methodologies, while still towing the line with their project management offices, may soon begin to tap into templates available with Visual Studio 2005 Team System.
Programming for the New DB2
(Maria Sarikos) So what exactly is data skew? In the DB2 context, it happens when DB2 creates an access path based on certain assumptions, but those assumptions are wrong, so the access path created is just plain inefficient. For example lets say you were selecting all the names in your client table