(Yaniv Etrogi) Monitoring the distribution queue is an important link in the chain of transactions delivery over a replicated topology. A chain that includes the log reader agent scanning the published database’s transaction log for commands to be moved to the distribution database from which a dist
Author: SSWUG Research
Compare tables to find missing rows
(Jen McCown) Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a list of orders to an imported set of data in a staging table. Or, we’re identifying customers in the database that aren’t on the call list. Whatever the application, finding out the
Migrating SQL Server Database to Windows Azure – Resolving Incompatibility Issues
(Marcin Policht) In our recent articles published on this forum, we have been discussing the process of implementing data services in Windows Azure, focusing in particular on SQL Database (formerly referred to as SQL Azure Database). While creating new databases in such scenarios is straightforward,
Understanding How System Resources Affect SQL Server Performance
(Dusan Petkovic) The SQL Server Database Engine runs on the Windows operating system, which itself uses underlying system resources. These resources have a significant impact on the performance of both the operating system and the database system. Performance of any database system depends on four m
Maintaining the sequence of messages processed by an IBM Integration Bus message flow
(Karl Gaffney) In certain business scenarios where IBM Integration Bus or IBM WebSphere Message Broker are utilized, it is critically important to process messages in a message flow and route them on to target in the order that they were sent to the flow. This article describes the usage of IBM Inte
XMeLon Schema
(Alejandro Xalabarder) One problem with applications based on XML is that in order to access data contained in files quite often a specific parser has to be developed. Even having tons of libraries and tools that can, for instance, generate a big part of the parser, the required effort is still high
Table Manipulation using jQuery – Performance Tips and Best Practices
(Suprotim Agarwal) HTML Tables can be pretty boring to look at! Although you can add a dash of CSS and beautify them, users demand more interactivity by representing and manipulating tables, at runtime.
Delete Archived Logs from Standby
(Jeremy Schneider) This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system. (Specifically, a RAC/thread aware script.)
Generating Temporary Download URLs
(Bipin Joshi) Sometimes you need to generate temporary links – URLs that expire after a certain timespan – so that a resource indicated by the link can be accessed only for a specific period. The URL if accessed after the stipulated time window refuses to serve the intended resource. Consider, for e
SAP Integration with IBM DB2 Analytics Accelerator for z/OS
(Rajeev Kamath and Paolo Bruni) The IBM DB2 Analytics Accelerator for z/OS is a powerful appliance that delivers near real time analytics to SAP on System z with DB2. SAP, a highly integrated business management application, supports most of an enterprise’s business processes and usually is a missio