(Gregory A. Larsen) Are you a Database Administrator that has a desire to work remotely but don’t have access to your databases while you are out of your office? Would you consider using a web interface to manage your SQL Server databases and Logins? If so, then you might want to consider checking o
Author: SSWUG Research
SQL Server Yukon: Advantages of the new PIVOT operators
(Sanders Kaufman, Jr.) Database developers who use Microsoft products have often experienced frustration at the disparity of functions between Access and SQL Server. SQL Server, which uses Transact-SQL (T-SQL), is a step behind Access in its range of features, although it is several steps ahead in t
IBM’s New Stinger Database to Zap Pain Points
(Clint Boulton) After months of unveiling features by the piece for its next-generation database, IBM is planning to launch the finished product in late April or early May, according to a source familiar with the company’s plans.
Find Out Where Your PL/SQL Session Is
(Sudhindra Chillarige) Suppose you run a relatively long PL/SQL procedure that processes several rows, and you want to track its progress. The following procedure lets you see the total number of rows and the current row being processed, using client_info in the V$SESSION view.
Oracle awaits grid database upgrades
(Paul Krill) Oracle anticipates a spur in upgrades to its grid-enabled Oracle Database 10g this June, when the first patch set will be released for the new system.
W3C Advances Specs For Web Interoperability
(Sean Michael Kerner) The World Wide Web Consortium (W3C) has approved Document Object Model (DOM) Level 3 Core and Load and Save specifications as official W3C recommendations, a move that stamps out vestiges of the browser wars and makes way for Web interoperability. The specification means th
Content Management with XML
ZDNet Editor in Chief Dan Farber and Gilbane Report Editorial Director Frank Gilbane take a look at how XML can help businesses take content management to the next level. (R, webcast)
The path to an executable DB2 program
(Craig Mullins) Could you please explain the difference between a package and a plan, the process of precompilation, compilation and running a COBOL DB2 program as well as a COBOL CICS DB2 program? (R)
Creating Primary and Unique Keys in XML Schemas
A primary key defines a column in a table as unique and required (null values are not allowed), whereas a unique key defines a column in a table as unique and optional (null values are allowed).
Raising The Bar: DB2 for OS/390 & z/OS V8 64-Bit Exploitation
(Julian Stuhler) As I’m sure everyone reading this will know by now, DB2 for z/OS Version 8 (hereafter referred to simply as “V8”) has finally become available on 26th March 2004. V8 is a very significant release of DB2 – not only in terms of the new functionality delivered to the user, but also in