Welcome to 48 edition of Log Buffer. While I read Log Buffer regularly for many months already it's first time I do review of databases blogosphere. Thanks to Dave Edwards from Pythian for inviting me.
This edition will be mostly related to development tools, techniques and
environments for database applications. Let start with
Oracle APEX where Patrick Wolf presents
of APEX Repository. In turn
Gielis is discussing how to
Oracle APEX components effectively. If you still do not know what APEX is,
you can begin with
Application Express—What’s it All About? by Peter Lorenzen.
Jonathan Bruce at his
is reviewing and recommending
Connect for ADO.NET Oracle provider for Visual Studio.
Anton Scheffer from
Sudoku with single SQL statement using MODEL Clause; really impressive
method, I must find time to experiment with MODEL clause as it seems to be very
Linear Algebra is not commonly known feature of Oracle database. Marcos M.
Data Mining and Analytics is presenting how it can be used for
Components Analysis and Visualization. Unfortunately complexity of examples
rather will not help with wider usage of UTL_NLA package.
Jonathan Lewis on his
Scratchpad presents differences in new (Oracle 10g) and old
algorithm. Difference is visible only for those who were using side effect of
sorting by ROWID in previous oracle releases.
Jorrit Nijssen alias
Jornica issued an
warning on using
statement trigger and returning clause together as there is an side effect.
For many of Oracle DBAs it might be weird idea: Kevin Closson is
proposing to install
over NFS. He states that it's cheaper, simpler and will be even better with
upcoming Oracle 11g. By the way
11g will be launched on 11th of July according to Eddie Awad. This
announcement made big rumour in Oracle blogosphere and Lutz Hartmann is
now documenting new feature of
statistics in 11g.
Laurent Schneider is discussing
Practices for Aliasing columns in SQL queries. Dominic Delmolino on
Musigns suggest another method: uniquely
columns. Also Steven Feuerstein on Toad World shows good practice:
put COMMIT; in you code!".
Burns discuses what is the role of Oracle, OTN, Technorati and readers
for bloggers community.
Jeff of his
SQL Server Weblog that
design should not be made due to desired output. "We often see bad
designs submitted at SQLTeam.com with the justification of that design being the
client wanted it that way! ... you need to demonstrate to them that even when
storing the data properly, we can *still* create a View which returns those
exact results, making them happy".
Quality: Where to Validate? Beth on
of a database geek is reviewing levels where validation should occur also
giving some recommendations.
Roland Bouman shows
MySQL can do to enter the off-line Web. In my opinion the idea of using Web
applications offline will be very hot in nearest future.
Peter Zaitsev is discussing an issue with degraded
after upgrading MySQL 4 to MySQL 5. He also presents some workaround for
Paul McCullagh on
PrimeBase XT shows
how to manipulate
in MySQL using BLOB Streaming Engine.
Ronald Bradford on
Notes and Articles of Interest reviews
solution for MySQL database.
Kevin Burton is predicting
of RAIDs . Instead he proposes to use many instances of MySQL with
Archiver 0.9.1 tool to archive content of critical OLTP tables.
JonC is answering most common
Questions Applied to MySQL and pointing that biggest challenge is to deal
with human errors. Alex Kornbrust is presenting
Orakel new tool to Sniffer Oracle Passwords. He also points few errors in
white-paper that is accompanying the tool.
Mark Rittman is on vacations leaving us with lot of
Articles and Links to read.
Steve Jones on
Musings talks over
Availability of SQL Server.
Garden on his blog announces interesting
Casts about new features of SQL Server 2008. While Jamie Thomson show
by Grouping Sets will work in Katmai: SQL Sever 2008.
Berkus is reporting on
2007 PostgreSQL Conference and his keynote on "PostgreSQL Today and
Tomorrow". "This was the most challenging conference for me so far since the
entire conference was in Japanese, a language of which I have no
At the and some news from my country. Jakub Pawlowski is summarizing
PLOUG (Polish Oracle Users Group) Seminary - "Oracle Application Server 10g
R3: applications, productivity, security, reliability."
That's all for today. Wait for next Log Buffer on June 15th presented by