(Michael Panciroli) If you have seen the new Asset Library in SharePoint 2010 your probably as pleased as I am with the improvements in managing digital assets over SharePoint 2007. You also may have seen how metadata encoded in the image including dimensions, date taken, author, comments and copyr
Other News
Java & XML Tool Overview
(Jacky) As mentioned in the introduction Sun now provides these tools for XML Processing in Java
How to read XML file in Java – (DOM Parser)
(mkyong) DOM Parser is slow and consume a lot memory if it load a XML document which contains a lot of data. Please consider SAX parser as solution for it, SAX is faster than DOM and use less memory.
Passing Parameters to XSL
You can pass parameters from the JHTML page environment through the XMLTransform servlet bean to an XSL stylesheet. The parameters are matched by name with top-level elements in the stylesheet.
How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005
The Sqldumper.exe utility is included with Microsoft SQL Server 2005. This article describes how to use the Sqldumper.exe utility to generate a dump file for Watson error reporting or for debugging tasks.
SQL Server Resource Governor
(Mike Chapple) SQL Server’s Resource Governor feature, first available in SQL Server 2008, provides the ability to limit the resources consumed by SQL Server database connections. This functionality permits database administrators to regulate the CPU usage and memory consumption of various workloads
Covering Indexes: How many indexes do you need?
(Martin Farach-Colton) I’ve recently been blogging about how partitioning is a poor man’s answer to covering indexes. I got the following comment from Jaimie Sirovich:
Installing and Testing DB2 9.7.4 on Ubuntu 11.04
(Marius) The full refresh of DB2 Express-C 9.7.4 — the enterprise scale database server from IBM that is free to develop, deploy and distribute — was released last week.
Modify the attribute AUTO_START to ‘always’
(Maria Mundrova) With Oracle 11.2 database auto start policy in the clusterware is restore, which means that clusterware will remember the last state of the database. If the database was stopped normally then on the next restart of clusterware it won’t be started.
Oracle GoldenGate and Encrypted Tablespaces (TDE) in 11.2
(Miladin Modrakovic) To make GG work with encrypted tablespaces you have to apply database patch: