(David Allan) OWB’s flat file loading support is rich and there are a lot of configuration properties for mappings in general and the properties exposed for SQLLoader mappings are expansive. One of the things that OWB does is load the resultant logs from SQLLoader into the runtime audit tables throu
Other News
Controller Patterns for ASP.NET
(Alex Homer) This is the second in a series of three articles that looks at the built-in support for standard design patterns in ASP.NET, and how you can implement common patterns in your own applications.
Using HAProxy for MySQL failovers
(Mike Taluc) There are a number of solutions available for MySQL architecture that provide automatic failover, but the vast majority involve potentially significant and complex changes to existing configurations.
SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree
(Pinal Dave) Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space.
small data, BIG data on clouds
(Rav Ahuja) I have been talking about databases on the cloud for quite some time now. In earlier blog posts I’ve mentioned how cloud-o-nomics can accelerate testing and development of database solutions, get databases up-and-running quickly on public clouds, as well as using private clouds for deplo
Day 6: The Twelve Days of SQL: The execution plan is a tree
(Iggy Fernandez) An execution plan is a tree. This is not very obvious from the listing of DBMS_XPLAN or EXPLAIN PLAN but some pictures will illustrate the point (click on them to enlarge them). The following query joins the Employees table to the Jobs, Departments, Locations, Countries, and Regions
How to identify an item or sub item the users selects in a ListView
(Ged Mead) Here’s a little ListView trick that might come in useful sometimes. The user selects an individual sub item in a list view and you want to know what they selected.
common_schema, rev. 178: foreach(), repeat_exec(), Roland Bouman, query analysis
(Shlomi Noach) common_schema, revision 178 is now released, with major additions. This revision turns common_schema into a framework, rather than a set of views and functions.
XML SchemaValidator
(Azim Zahir) This article shows how to validate an XML document against a schema using C#. For demonstration of this, I have created a GUI application using Visual Studio 2005 Express Edition.
SQL Server sp_ prefix when and when not to use it
(Diana Moldovan) There have been many articles written about the issue with prefixing SQL Server stored procedures with “sp_”. In this tip we will take a look at some of these issues and also some differences between SQL 2000 and SQL 2005, 2008 and 2008 R2.