(Naveen Karamchetti) The SQL Transport Schema Generation Wizard in BizTalk Server 2004/2006 does not permit the selection of multiple tables for updating when generating a schema for an Updategram.
Other News
Two Oracle PL/SQL Features You Probably Don’t Know About
(Eddie Awad) Oracle PL/SQL has a neat and little known feature called forward declaration. In this post I’m going to do a quick review of what forward declaration is, how it can be used and a situation in which forward declarations are absolutely required, mutual recursion.
updatable views and instead of triggers
(Laurent Schneider) I am data-modeling those days. Each table has it own description table (yes, it is Java). To keep it simple, FRUIT[id,description] and MEAT[id,description] (35 of them right now). There must be one table which contains all descriptions in it GLOBAL[type,id,description]. I wish
An easy way to export performance data from mysqld
(Mark Callaghan) Chip Turner has begun work on a new storage engine that makes it easy to export files as if they were database tables. Why is this good? I have written code to export data from /proc in SHOW STATUS. This makes it possible to track changes in system resource consumption, such as the
Secure, Reliable Web Services with Apache
(Kyle Gabhart) Open source computing has gained a tremendous degree of momentum in the last few years. Nowhere is this more evident than in the area of web services and Service-Oriented Architecture (SOA). The Apache Foundation alone has more than 20 SOA/WS projects. One of the common obstacles for
DB2 Express-C – free to build, deploy, distribute – now backed by IBM Support
(Chris Eaton) A year ago, IBM delivered DB2 Express-C with the tag line free to build, deploy, distribute. That’s was pretty cool to have a free version of DB2 that includes pureXML and is the same codebase that you get with DB2 Enterprise for Linux and Windows. I really think the best thing here is
Dealing with case and accents in SQL Server
(Arthur Fuller) Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. I often see collation handled on a per-database scale. For instance, in my experience, most DBAs in North America go with the default collation, which is case insensitive. The co
Processing with C# and Oracle PL/SQL
(Dimitar Madjarov) This article actually is an heir of my first article from this topic about programming with Oracle and C#. The first article is available for reading on next web address “Processing with C#, Oracle transactions and Oracle exceptions”. In my first article I describe an alternative
Planning Redundancy and Scaling the SharePoint Environment
(Colin Spence and Michael Noel) Any enterprise platform needs to be able to adjust, grow, and scale out to fit the needs of a changing organization. SharePoint is no exception to this rule, and the creators focused on the ability to scale certain components within SharePoint to be able to adjust to
Client asks master to start replication from impossible position
(Dathan) I get this question a lot. Why does a slave report that it’s trying to replicate from an impossible position? 9 times out of 10 it’s because the master crashed and when it came back online a new binlog file was made.