(Caleb Small) Transportable Tablespaces are the most efficient way to move large amounts of data from one Oracle database to another. When combined with a properly designed table partitioning scheme this feature provides an ideal method of refreshing a data warehouse or archiving transactional data
Author: SSWUG Research
Fast Infoset for Web services
(William Brogden) Anybody who wrote communication programs in the old days of slow modems and expensive long lines before the Internet probably had the same reaction on first seeing XML. “What a wasteful format!” Admittedly it is hard to give up those give up those old byte-saving instincts to gain
Security Issues with MySQL
(Paul Dubois) If you maintain a MySQL database, you understand the importance of security. This article covers that topic in detail.
XML in Databases
(Ari Kaplan) In a world of competing proprietary data formats, XML is a neutral and generalized format that is ideal for data exchange. It is especially suited for applications employing service-oriented architectures (SOAs), because to simplify reuse of program components, the individual services n
VB DataGridView Automatically Saving Updates to Bound Database
(Andrew Timberlake-Newell) It seems like it should be easy. It even is easy. But finding out how to configure bound DataGridView controls to automatically update the source data can be a challenge.
Surviving Common DB2 Performance Problems
(Craig S. Mullins) In today’s modern enterprise, information is power; and database systems are the predominant technology for storing, managing, and accessing the data that enterprises use to turn into information. And DB2 is one of the leading database systems on the market. (pdf)
Web services programming tips and tricks: Attachments using the wsi:swaRef XML type from WSI
(Russell Butek) This tip describes how to use the XML attachment type defined by the Web services Interoperability organization: wsi:swaRef.
eWEEK Labs Bakeoff: Open Source Versus .Net Stacks
(Jim Rapoza) Open-source and .Net zealots can both take away positives from eWEEK Labs testing of various application stacks, but a mix-and-match approach wins the day. Bottom line: Open source and .Net better learn to play nice.
Shorten development time by using parameterized queries in ADO.NET
(Zach Smith) For some time now stored procedures have been the preferred method of data access for enterprise application development. Stored procedures offer better security, better encapsulation, and can implement complex logic without cluttering up application code.
OK, One more time with BIND. But this time in regards to V8 NFM
(Willie Favero) I am a bit of a control freak. I like to know when things are going to happen and have some control (or least have the impression of control) over when they happen. Along those same lines, I really don’t like surprises. It drives me nuts when something happens that I had no idea was