Database Object Naming Conventions Yesterday I tossed out the question regarding the relevance of naming conventions for hardware and software services. Today I’d like to share some insights others have shared regarding naming conventions for database objects as well. Jim writes: I think the answer lies with a couple of facets to “it depends”. It first depends on how big […]
Other News
Are Naming Conventions Still Relevant?
Are Naming Conventions Still Relevant? I recall a discussion Steve introduced a couple years ago about naming conventions. In it we were discussing the value of how things were named that provided enterprise services. The discussion was targeted primarily at SQL Server. There was a lot of feedback with good ideas and good reasons behind them. Others simply used favorite […]
Soap Web Service – Introduction
(Joe) This article is to help us understand what is a soap web service. Through this tutorial, we will learn to create a simple hello world web service and a web service client to consume it, of course all in java.
Using XSLT as a stylesheet for HTML
(Jürgen M. Regel) As the name suggests, Extensible Stylesheet Language Transformations (XSLT) can be used as a stylesheet. Like Cascading Style Sheets (CSS), XSLT helps to separate style from content.
Modern platforms: flash, disk, log-structured, update-in-place
(Mark Callaghan) Someone who knows a lot about storage asked me whether we can spend IOPS to improve compression.
Turn XML data into columnar, relational format using SQL (lots of useful links inside)
(Henrik Loeser) The SQL standard offers many functions, some very useful are defined in part 14 of the SQL standard, “ISO/IEC 9075-14:2011 Part 14: XML-Related Specifications”. That part 14 was published 2003, so it is rather old. However, one of the gems in SQL/XML (the name for that XML addition t
WebSphere Commerce Stagingprop Doesn’t Copy OPTCOUNTER
(Ember Crooks) This post is specific to WebSphere Commerce. If you’ve always assumed that stagingprop copied the whole row and every change, I’ve found an execption. Stagingprop does not copy the OPTCOUNTER column.
New Feature in ODI 11.1.1.6: Smart Export and Import
(Jayant Mahto) Oracle Data Integrator 11.1.1.6.0 introduces a major new feature called Smart Export and Import. This post will give you an overview of this feature.
Why are developers in Prod? (Again!?!)
(Jeff Smith) I received a very interesting question from a reader the other day, which is awesome for two reasons. One, it gives me something to think about and play with. And ‘B’, it provides me with material for today’s blog post.
JDeveloper – Conditional Breakpoints saving time and a lot of clicking (IDE tip)
(Lucas Jellema) One of the biggest time-savers in in ADF 11g (R1) development, is working on the application while it is running on the WLS server in debug mode. In this mode, I can analyze the execution of my code, inspect variables and make many code changes that are applied ‘on the fly’. I can th