(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
Other News
Introducing MySQL Table Sync
(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.
Real-World AJAX Book Preview: Digging into the XInclude Binding
(Kurt Cagle) The XInclude Binding serves as a good example showcasing how such bindings can be created. If you are familiar with XBL bindings, the one aspect that is missing in the JavaScript version is the use of a specific template. This can be readily overcome within the constructor, especially s
Dynamic Warehousing – The Next Generation of Business Intelligence is Here!
(Susan Visser) IBM’s new Dynamic Warehousing initiative was recently unveiled. IBM is the first to fully understand and define this next generation of data warehousing. Only IBM can deliver all of the Dynamic Warehousing capabilities with a product portfolio that is best in class. Read the Dynamic W
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
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.
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.
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
Rman Compressed Backup and Duplicate Database Scripts
(Alejandro Vargas) Rman compressed backup provides an efficient way to save space and transfer time over the network when cloning databases.
IBM, Oracle, others create services consortium
(China Martens) IBM Corp. and Oracle Corp., more often rivals than partners, have joined in creating an industry consortium focused on establishing what it calls “service science” as both a key area for investment by companies and governments and as a full-blown academic discipline.