(kylewalker) Chances are, if you’ve used SSIS in any capacity, you’ve used an Execute SQL Task. I would say that about 95% of all the packages I write include at least one.
Other News
Using XQuery across Application Server and Database Server
(Matthias Nicola) In my previous post I discussed the native XML capabilities provided by the IBM WebSphere Application Server V7.0 Feature Pack for XML. This Feature Pack allows you to manipulate XML in your Java application directly with XQuery, XPath, or XSLT.
Security Functions with DB2 10 for z/OS
(Paolo Bruni, Marcelo Antonelli, Hyun Baek, Rick Butler and Ernie Mancill) DB2 9 and 10 for z/OS have added functions in the areas of security, regulatory compliance, and audit capability which provide solutions for the most compelling requirements.
Performance Tuning SQL Server: Tools Overview
(Buck Woody) In a previous article, I explained a process to follow for beginning a performance tuning effort. I think you should start with a good approach first, but it is often tempting to learn a particular tool and just start with something you know, and let the process develop from there.
SQL_IDs and baselines
(Dom Brooks) There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id.
Display a formatted time difference
(Hector R. Madrid) This is a simple query to display the difference between two dates in a formatted way.
Saving space when using sdo_geometry data
(Simon Greener) There is a little known side effect of using too many digits of precision when describing and storing spatial data using Oracle’s SDO_GEOMETRY object type. That side effect is that the storage requirements can be significantly greater than expected.
Why You Should Use XMLHttpRequest Asynchronously
(Dom R) 8.4% of all hangs in IE9 in the past month are caused by XMLHttpRequest objects blocking the UI thread with a synchronous request. That’s a huge number! With some manageable code changes, these hangs can be avoided, and developers can give their users a better experience across their website
Send XML over a Socket fast
(Peter Lawrey) XML parsers are designed to handle any type of XML message you can send. However if you assume the XML will always follow a specific format how fast can you make it.
Video: Intro to Semantic Web for the Publishing Industry
(Angela Guess) Publishing Technology has released a new video that provides an introduction to the semantic web and explains why it is important to the publishing industry.