(Bob Violino) While the potential benefits of SOA are clear, like the ability to reuse existing assets, the standards picture looks anything but settled.
Author: SSWUG Research
XSD Tutorial – Part 2 of 5 – Conventions & Recommendations
(Simon Sprott) There is often some confusion over when to use an element or an attribute. Some people say that elements describe data and attributes describe the meta data. Another way to look at it is that attributes are used for small pieces of data such as order id’s, but really, it is personal t
Roll Your Own Data Snapshot Utility
(Ian Stirk) Databases are often the primary cause of poor application performance.
SQL Server Interview Questions and Answers – Part 6
(Pinalkumar Dave) What are the properties of the Relational tables?
Table of MySQL Parameters
(Yannick Gratton) I got tired of going all over the place to get information about mysqld variables, so I decided to make a summary of most of them (for version 5.0.27 linux). (Due to lack of horizontal space, I had to make two tables — the second one containing a short description of the variable.)
Generate synchronization scripts in SQL Server with TableDiff
(Tim Chapman) DBAs often have to find the differences between lookup tables in different database environments (i.e., development, quality-assurance, staging, and production). The data in these lookup tables are required to be the same across environments to ensure that your testing is accurate.
Capturing Incremental Data Changes in Oracle Database 10g
(Meenakshi Thanikachalam) There are various ways to identify new or changed data in a data warehouse. One technique to determine the changes is to include a timestamp on each row in the operational system as the record is changed.The data extraction program then selects the new or changed source dat
From Rows to Column
(Amit Zhankar) This script starts with rows and then returns results in one column.
Ajax and XML: Learning from Ajax’s best
(Jack D Herrington) Take a tour through some of the best Asynchronous JavaScript + XML (Ajax) applications in the Web 2.0 world. Discover how these applications succeed at the user level and find techniques you can explore for your own Web 2.0 applications to create an exciting user experience.
Quest Code Tester for Oracle
(Steve Callan) If you write any significant amount of PL/SQL code, your day of salvation has arrived, and the salvation is in the form of Quest Code Tester for Oracle (QCTO). If you work in a structured development environment (even minimally so), the responsibility for performing unit tests falls u