(Leo Sauermann) Social technologies and collaboration tools start to find broad acceptance in the enterprise domain. As well, semantic technologies have been around for a while, offering a range of benefits in the handling of information, including the pervasive linking of content, fostering new for
Other News
JAXB and Inhertiance – Using XmlAdapter
(Blaise Doughan) In previous posts I have covered how to map inheritance relationships in JAXB. This can be done by element name (via @XmlElementRef), by the xsi:type attribute, or in EclipseLink MOXy using another XML attribute (via @XmlDescriminatorNode/@XmlDescriminatorValue).
When up isn’t enough: Techniques for scaling SQL Server out
(Don Jones) Given the choice, any sane person would scale a SQL Server database up rather than out. Up is easy: You get bigger hardware, more processor power, more memory, faster disks, a faster network. The idea is that you still leave the database running on a single server, but you make that serv
Non-Specific Index Hints
(Charles Hooper) As I read the “Troubleshooting Oracle Performance” book for the second time a couple of months ago, I made note on page 385 that it was possible to specify table columns in an index hint, rather than specifying specific index names (or just specifying the table name).
Dropped Partitions do not go in the Recycle Bin
(Martin Widlake) If you alter table TEST drop partition Q1, does it go in the recycle bin?
OBIEE 11g: Where’s the Compare Repositories Dialog?
(chet justice) Recently I decided to try out the new patching capabilities for the metadata in OBIEE 11g. The big reason for me was to avoid having to reset my connection pools. Each time I did a 3 way merge, the connection pools would get over-written with their development credentials. When I was
MySQL replication monitoring on Ubuntu 10.04 with Nagios and NRPE
(Brian Buchalter) If you’re using MySQL replication, then you’re probably counting on it for some fairly important need. Monitoring via Nagios is generally considered a best practice.
TechTip: Simplify Tracking of DB2 Table Metrics
(Kent Milligan) On other database servers, database administrators have to keep a close watch on the size and number of rows in a table to make sure that enough disk space has been allocated for the table object.
Working with Application Role – SQL Server
(Paresh Prajapati) In last post we have seen custom database roles as how can we create it and assign required access to users. We also noticed that we can add multiple members with same role. That was the security with database roles and members comes into the picture. Now here we will study of App
Analyzing Deadocks – the old way
(Ember Crooks) In 9.7, DB2 started offering a new monitoring method for deadlocking. Though this post describes the “old” way, this method also works in db2 9.7. Detailedeadlock event monitors have been deprecated, but not yet removed. This means that even in 9.7, you can still create them and work