> Watch SelectViews, the SQL Server Show, Here. Featured Article(s) Increasing Query Performance Using Oracle 11gs SQL Query Result Cache Oracle 11g has a new feature called the SQL Query Result Cache. This feature is useful when a query returns large amounts of data that is fairly static. When this situation occurs, the feature may improve query performance. This article […]
Other News
The enhanced DB2 inside V6R1
(Mark Fontecchio) Along with i5/OS V6R1 is the DB2 that comes with it, and as there are enhancements in V6R1, so there are for DB2, IBM’s relational database management system. Let’s go over some of the details of those enhancements. (R)
MDM is Not Enough – Semantic Enterprise is Needed
(Semyon Axelrod) This article introduces the concept of semantic enterprise and outlines a connection between semantic enterprise and master data management (MDM) concepts. The article also shows that successful transitioning to semantic enterprise requires significant improvements in enterprise met
Using XMLDIFF for Database Change Management
(Marco Gralike) I was triggered by a presentation of Dominic Delmolino during Hotsos 2008. He demonstrated a cool way of applying DDL database change management while making use of the Oracle database audit functionality. I combined the idea with Laurent Schneiders “out of the XML box thinking“, lik
DataSets, Xml Schemas and Excel – Oh My!
(George Zabanah) This article explores the power of the DataSet in a way that you might not be familiar with. Two important (and very helpful) aspects of the DataSet are uncovered here: –A DataSet can be used to write to Excel and read from Excel using an OleDbConnection very easily. –A Data
CodeSnip: How to Run Any Oracle Script File Through Shell Script in UNIX
(Deepankar Sarangi) By using the above mentioned method, the user can run a useful oracle script through UNIX shell script. The insert script can contain millions of DML operations which can be executed at one go. Also, the prompt output can be redirected into a UNIX file for tracking any possible e
Browse ListView data with .NET’s DataPager control
(Tony Patton) Microsoft .NET 3.5 introduces the DataPager control, which delivers a paging interface that is tied to the ListView control. DataPager also communicates with its corresponding ListView control regarding user input. Here’s an explanation of how you can use the DataPager control to page
Autocomplete Combo Boxes
(Lalit Dwivedi) When you develop an application in Microsoft Access, your combo boxes will, by default, incorporate autocomplete. However, Visual Basic does not include this intrinsic support. If you want autocomplete in VB, you’ve got to do it yourself. This tip shows you how.
DB2 9.5 and IBM Data Studio: Part 8: The SQL Builder Development Accelerators – The Rest of the Story
(Paul Zikopoulos) So far in this series about the IBM Data Studio integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2)
Search and Replace with Regular Expressions
(Paul Kimmel) Neither male or female parents are superfluous. Parents teach children things implicitly by their habits and sometimes explicitly when the kids are listening. Sometimes, a parent has a bad habit; the child sees the consequences and says “I don’t want that bad thing to happen to me!” So