(Christoph) In this part of my series of blogs about dynamically modifying SSIS Packages I describe how to programmatically add or modify an Aggregate component.
Other News
DB2 Performance Maintenance – Saving Resources and CPU with the Correct Setting
(Dave Beulke) Last week I talked about the basics of evaluating DB2 for z/OS and LUW compression. DB2 compression saves a huge amount of disk storage space and improves performance by eliminating I/O within your system.
Ways to instantiate a variable in Oracle Service Bus based on a static XML document
(Lucas Jellema) Today we had an interesting exploration into the many ways available in the Oracle Service Bus to load a piece of XML into a variable in a message flow – to use as the source for populating part of a to-be-forwarded request message to the business service or for enriching the respons
Debugging .NET 4.0 applications using SOS extension
(Suprotim Agarwal) The SOS (Son of Strike) debugger extension is an invaluable resource for debugging .NET 4.0 managed applications using native debuggers.The SOS extension lets you view information about code that is running inside the CLR. When you install .NET on your machine, the SOS.dll debugg
Logging MySQL queries from the client instead of the server
(Baron Schwartz) The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal of additional performance and other diagnostic information.
Custom Reports in SSMS
SSWUG Free Expo Event: Real-World SharePoint Administration Today from 9 a.m. – 1 p.m. PST Be ready if you signed up for the SharePoint Administration Expo today…It starts at 9am Pacific Standard Time DBTechCon – Spring 2011 The SSWUG Spring 2011 virtual conference is quickly coming together. You can go to the registration page and see profiles for presenters, and […]
Detecting Ontological Conflicts In Protocols Between Semantic Web Services
The task of verifying the compatibility between interacting web services has traditionally been limited to checking the compatibility of the interaction protocol in terms of message sequences and the type of data being exchanged.
New Dates and Cities announced for Semantic Technology Conference
(Tony Shaw) SemanticWeb.com and MediaBistro are pleased to announce the expansion of the Semantic Technology Conference to additional cities and dates in the near future. Following is the schedule of 2011 events in San Francisco, London, and Washington DC:
TIMESTAMP or SCN for Oracle’s Flashback Query?
(James Koopmann) Taking advantage of Oracle’s flashback query feature, for SQL-driven flashback, the SELECT statement makes use of the AS OF or VERSIONS BETWEEN clause to retrieve data from the past from tables, views, or materialized views.
Instrumenting OBIEE for tracing Oracle DB calls
(rnm1978) Cary Millsap recently published a paper “Mastering Performance with Extended SQL Trace” describing how to use Oracle trace to assist with troubleshooting the performance of database queries.