Embarcadero Technologies, Inc., a provider of application and database lifecycle management solutions, announced Embarcadero® DBArtisan. Workbench for managing complex databases across the enterprise. DBArtisan Workbench combines Embarcadero’s flagship database management solution, DBArtisan, with E
Other News
Automation Alley
by David Stodder – The race is on between DBMS and tool providers to see who can “self-heal” the database first.
Recreate/Move a (or all) Tablespace(s) from a Database to …
by Rajesh Puneyani – This script extracts the definition of a tablespace (if a specific tablespace name is provided by user @ run time) or all the tablespaces of a database (if wildcard – % – is entered @ runtime). The extracted script can be used as it is to create those tablespaces in another data
PeopleSoft Lodges A Suit Of Its Own Against Oracle
By Barbara Darrow – Another day, another lawsuit.<br><br>In what is fast becoming a forest-killer of an acquisition battle, PeopleSoft late Friday said it sued Oracle in an attempt to stop what it is terming "a sham tender offer aimed at destroying PeopleSoft’s business."
MSDN TV: Passing XML Data Inside the CLR
The .NET Framework offers several options for passing XML-based data between components within a single process and AppDomain. This episode looks at the available options and discusses the design tradeoffs of each approach.
General-purpose Water Dissolves XML Complexity
by Glen Kunene – Despite all its promise for free data exchange among disparate applications, Web application developers still contend with XML’s shortcomings. Startup Clear Methods claims to have developed a powerful yet simple solution: XML as a general-purpose programming language called Water.
A Couple of ASP Functions for XML Data Transfer
One of our visitors decided they would give something back. It’s not much, but here are a couple of ASP functions for XML Data transfer that they found to be very useful.
New DB2 UDB Fastpath DBA course for V8
Are you an experienced relational database administrator who’d like to learn DB2? Then this updated self-study course is for you — at no charge. The DB2 Universal Database Administration Fastpath course helps experienced database administrators gain DB2 UDB V8.1 skills quickly and easily.
Multiple sorts without using dynamic SQL
By Jim Haire – Have you ever wanted the order of your data sorted differently based on some condition? You could do it by coding multiple cursors or creating dynamic SQL. Here is a way to do it with static SQL and only one cursor.
SQL Server 2000 SP3a Available for Download
Microsoft has released SQL Server 2000 Service Pack 3a (SP3a) to address specific issues discovered in SQL Server 2000 since its ship date. Because SQL Server service packs are cumulative, SP3a includes all fixes from SP1, SP2, and SP3. However, if you’ve applied SP3, Microsoft says you don’t need t