(Steve Jones) My company is moving towards DB2 as a standard. Not necessarily in all areas and I’m not particularly worried about SQL Server being displaced, but moving forward, most of our software is targeted for DB2. So I got stuck into an installation/admin class for a week. After a day and a ha
Other News
Write .NET Code in SQL Server
(Bob Beauchemin) All versions of SQL Server prior to SQL Server “Yukon” provide two ways to write procedural code that executes inside the database. The usual way is to use Transact SQL (T-SQL), a proprietary implementation of a portion of the SQL standard known as persistent stored modules (SQL/PSM
Using INSTEAD OF triggers
(Alexander Kuznetsov) First introduced in DB2 UDB V8.1, INSTEAD OF triggers are very useful when you need to modify the database structure without changing the applications running against the changed database. In other words, you may use INSTEAD OF triggers and views to isolate applications from ch
MS Office XML lags on Mac
(Matthew Cooney) Microsoft Corp. is readying a new version of Office for Macintosh for release in the first half of 2004 — but it won’t support many of the XML (Extensible Markup Language) features of its Windows cousin, Office 2003.
Oracle AppsWorld Online
Tune in and explore the latest Oracle applications, watch insightful keynotes from top industry leaders, see product demos and more! Or watch keynotes from recent OracleWorld and AppsWorld Conferences.
Which Distributed Edition of DB2 Version 8 is Right for You?
(Paul C. Zikopoulos and Roman B. Melnyk) This popular article is updated with the latest news in product features, editions, and pricing for Version 8.1.4 and DB2 Express. This article lays out the options and includes a quick reference that maps typical user environments to the suggested DB2 editio
Arm Yourself Against Performance Erosion
(Casey Young) Has your once speedy database gradually slowed? If so, finding the performance leak may be harder than you realize. Here are five tips to help you on your way. If you have a sudden drop in DB2 performance, your customers know it, your internal users know it, your manager knows it,
Getting Started with XForms
(Bob DuCharme) The XForms standard, which became a W3C Recommendation last month, lets us define forms that are much more sophisticated than those of HTML. Perhaps more importantly, it makes it easier for applications that we write to grab and use the data entered into forms, because an XForms clien
Implementation of Server Level Security and Object Level Security
SQL Server 2000 checks whether the security identifier (SID) or group membership SIDs of the user have been specifically denied access to the server. If so, the user will not be granted access to the server. If the user is not specifically denied access, the server checks whether the user has been g
An Oracle Programmatic and General Reference
(Robert Cordingley and Charlie Russel) Functions, like operators, act on data to return a result. However, unlike operators, functions can operate on zero, one, or more arguments. Of the built in SQL functions in Oracle 9i, there are single row functions, aggregate functions, analytical functions an