(Thomas LaRock) We’ve all had those moments. It’s late in the day. You are about to head home a few minutes early so you can bring your daughter to soccer practice on time. Your phone rings.
Other News
A Little Web Scraping Excercise with XML-Package
(Kay Cichini) Some months ago I posted an example of how to get the links of the contributing blogs on the R-Blogger site. I used readLines() and did some string processing using regular expressions.
Using an RDF Data Pipeline to Implement Cross-Collection Search
(David Henry and Eric Brown) This paper presents an approach to transforming data from many diverse sources in support of a semantic cross-collection search application. It describes the vision and goals for a semantic cross-collection search and examines the challenges of supporting search of that
Using multiple connections on a single table
(Cathy Dumas) Sometimes it is nice to mash data from multiple connections into a single table. One case for using multiple connections for a single table is to analyze data feeds. For example, suppose you are nosy (like me) and you like to check on home valuations on Zillow.
Various memory errors are logged to SQL Server error log when using SQL CLR objects
When using SQL CLR stored procedures, user defined functions, user defined data types, or user defined aggregates, you many notice one or more of the following error messages being logged in the SQL server error log when running on a 32 bit instance of either SQL Server 2005 or 2008.
Updating key-preserved inline views
(Scott Wesley) I learnt something today – there is a scenario where you need update privileges on a table you aren’t updating.
Parsing a CSV file in PL/SQL
(Christopher Beck) The ability to parse a CSV file in PL/SQL seems like a simple requirement and one would think that you could either a) easily implement it yourself, or b) find some examples of it on the web.
How to do table column based data manipulation in SQL and XQuery
(Frank Zhou) The following SQL pattern can be used to stragg all the table column data together.
DB2’s Got Talent Finals – Round 3
(Susan Visser) I had to miss the show on March 30th, but hopefully you were able to attend the show live. I’m listening to the replay and here’s a summary of what took place.
Cascading with jQuery AutoComplete
(pranay) In this post I am going to show how to achieve cascading functionality with the help of jQuery AutoComplete UI control rather than we are doing with the help of comobo-box controls till date.