(Stephan) If you’re an XSLT guru, you need to know the XML structure you’re working with. Getting into the guts of SharePoint isn’t always a walk in the park, but Microsoft has made it easy to view the XML structure in FAST.
Other News
Reading XML Configuration Files using TSQL
(ItayBraun) Sometimes the result of a query depends on a parameter in a configuration file. Today, for example, I needed to write an SSRS report with a URL to another IIS.
Parsing XML files with Objective-C
(Tyler Wilson) Perhaps the simplest app to create is a blog feed reader. Typically you will not find a native mobile app that’s there only to display a feed. Normally, this is a task best left for a website or a web-based application.
MySQL monitoring: storing, not caching
(Shlomi Noach) I’ve followed with interest on Baron’s Why don’t our new Nagios plugins use caching? and Sheeri’s Caching for Monitoring: Timing is Everything. I wish to present my take on this, from mycheckpoint’s point of view.
Coca Cola Bottling Move from Oracle Database to IBM DB2
(Conor O’Mahony) At the 2011 IBM Information On Demand (IOD) Conference, Coca Cola Bottling spoke about their experiences when moving from Oracle Database to IBM DB2. I have included some very brief video segments shot at the conference below. It is really interesting to heard about the experiences
Managing a Virtual Environment
(Troy Coleman) IBM has a facility that establishes performance-monitoring parameters through a set of profile tables. These parameters are activated and deactivated through the START PROFILE command. I covered the profile tables and commands in a previous blog entry.
How to transform a database table dataset into HTML table in SQL
(Frank Zhou) The following SQL pattern can be used to tranform the database table dataset into data in HTML table format by utilizing the XSLT functionality. The query also handles NULLs in the data columns.
SQL Developer: Tastes Great, Less Filling?
(Jeff Smith) The ‘Holy Grail’ of software tools is the environment where things are made easy, but not at the expense of usability or simplicity. You use a tool because it makes something ‘easier’, but some software products are anything but.
Dynamic Sampling And Indexes
(Randolf Geist) There is a lot more to say about Dynamic Sampling and indexes, and I’ll try to cover these basics in my Dynamic Sampling series on AllThingsOracle.com, but two recent discussions on the OTN forums and on Charles Hooper’s blog prompted me to publish this blog post.
Database Mirroring Failover Considerations
(Chris Shaw) Database mirroring is a great option for many disaster scenarios. If using a witness server automated failovers can be achieved. However, just like any other disaster recovery solution database mirroring should be tested. Before you execute your first test of failing over a database f