(Xaprb) MySQL Table Sync efficiently finds and resolves data (not structural) differences between two MySQL tables, which may be on different servers. It offers two search algorithms to find the rows that differ, and several methods to bring the destination table into sync with the source.
Author: SSWUG Research
SQL Server 2005 Integration Services – Part 45 – Bulk Insert Task and Format Files
(Marcin Policht) In the previous article of our series dealing with SQL Server 2005 Integration Services, we have presented a straightforward approach to importing data from delimited text files into database tables and views, using Bulk Insert Control Flow task (which, in turn, leverages T-SQL BULK
The Answers (and the Questions) in the Hunt for Data Quality
(Robert Heidenreich) Do you know the answers to the seven key questions concerning data quality? Let’s face it, data integrity is a monumental problem for business-to-business marketers – a problem that is often ignored. Without good data, however, your organization can’t make decisions about to
Exporting to Excel from any ADF Table
(Lucas Jellema) No matter how fancy the application you develop, no matter how sophisticated the user interfaces: end users will always clamor for Excel. All data eventually will end up in some Excel Spreadsheet it seems. And grudgingly or not, we will of course oblige them. Depending on how difficu
Improve XPath Efficiency with VTD-XML
(Jimmy Zhang) For the past several years, XPath has been steadily gaining popularity as an effective tool when developing XML applications. XPath was originally viewed as an adjunct element for the W3C’s XSLT and XPointer specifications, but developers found its simplicity appealing. With XPath, ins
DB2 Top Tips: A ‘Hat Trick’ – Three Tips for Busy DBAs
(Damon Anderson) Need a matrix of tables and the plans and packages that use them? How about a technique to avoid mass deletes and inserts? Or, how about a REXX program that retrieves all of your subsystem parameter values and puts them into a data set in a nicely formatted list? If so, read on for
MySQL Archive’s Compression Method
(Brian "Krow" Aker) In 5.1 I modified the compression methodology in response to seeing some schema’s which were only seeing compression in the 50% range (which is low compared to what I had seen in most common cases). The main problem I identified was that the compression of rows with NULLS and lon
SQL Server Wait Events: Taking the Guesswork out of Performance Profiling
(Mario Broodbakker) Measuring what is actually happening is always the best course of action when investigating performance issues on databases, rather than relying on cache hit ratios, or best practices, or worst of all, guesswork.
Using Includes in VBScript
(Nilpo) There is one very useful feature missing from both VB and VBScript—the ability to have includes. Includes allow you to create code snippets in separate files and import them into your script at runtime. We’re going to create a cool work around to allow us to use them.
Data Manipulation Using Java in Oracle
(Steve Callan) Is Oracle always the best tool or application to manipulate data? The answer lies within what you mean by manipulate. Data can be transformed via data manipulation language, and it can also be transformed via string or numerical manipulation. To distinguish between the types of manipu