(Conor O’Mahony) There is a new eBook that describes six reasons to move from Oracle to IBM. The eBook uses real world case studies to illustrate each of the six reasons. The six reasons are performance, cost savings, usability, scalability, flexibility, and reliability.
Other News
Tip: Transforming XHTML using XSLT identity templates
(Doug Domeny) XHTML isn’t just well-formed HTML: Certain tags must be properly closed. Improperly closed tags are valid XML, but browsers might incorrectly parse them, causing problems with dynamic Web 2.0 features. Whether transforming XML to XHTML or just filtering XHTML, discover the XSLT templat
Using DBMS_UTILITY to aggregate strings
(Alex Nuijten) In my presentation “Analytic Functions Revisited” there is a section on how to string together some columns, string aggregation. Why? There is a new function in Oracle 11g Release 2, called LISTAGG which allows you to do this. This LISTAGG function also has an Analytic counterpart and
11G R2 Cluster: Oracle DBAs please AVOID using sqlplus & lsnrctl for starting/stopping Oracle
(Yury) For last few months I was part of the Pythian’s team helping implement Oracle 11gR2 Clusters for different Oracle customers. All the implementations had different requirements and configurations, however, in all cases, the client’s DBAs made the same mistake over and over again.
How To Use XPath and an XML Data Island in a WPF Application
(Ged Mead) When you need to use XML data as a data source in a WPF application, most times you’ll probably pull the XML document down from the web, a server, a separate file, or other external source.
DB2 Security Row and Column Access Controls
(Dave Beulke) As I have talked about in previous weeks, another reason to request additional DBA resources are all the security configuration and settings involved with DB2 10 row and column access security. The setup, configuration and monitoring of these row and column access control settings enco
Represent String Values as Element Names with JAXB (“foo” as
(Blaise Doughan) In this example we will map a String value to an element name. Instead of bar we want . We will accomplish this by using @XmlAdapter and @XmlElementRef.
SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 3
(Charles Hooper) The previous article in this series included a test case that demonstrated significantly different performance for a SELECT statement and an INSERT INTO statement that used the same SELECT statement as the data source.
Drill down in SSRS Map Reports
(Jason Thomas) I have been always interested in the potential of map reports. So naturally, when I found out a site which had quite a number of shapefiles for free, I decided to blog something just for the fun of working with map reports. Being around in the forums, I had seen a lot of posts asking
Upgrading from SharePoint 2007 to 2010: Authentication Options
(Bart McDonough) If you’re doing a SharePoint 2007 to 2010 upgrade, one thing you’ll have to do is create one or more web applications in the 2010 farm for hosting the site collections you migrate.