Security audit in SQL server captures only successful and failed logins. It does not capture the application that uses the login. Login used by an application may have full read and write access on all of the tables and procedures but the application restricts the users by providing a front-end whic
Other News
SQL Server Developer price reduced to $49
Effective August 1st, 2003, Microsoft reduced the price of the Developer Edition of SQL Server 2000 to US$49.00.
DB2 UDB Version 8.1 Overview
IBM DB2 Information Management is pleased to announce IBM DB2 Universal Database V8.1 for Linux, UNIX and Windows. DB2 UDB V8.1 marks the next stage in the evolution of relational database providing for new levels of information integration within your e-infrastructure. DB2 UDB V8.1 allows you to ac
Linking Databases and More
By Priscilla Emery – Time to add a content management app? You’ll find a little homework goes a long way.
Copy DB2 Table
How do I copy data from a table from the existing table to a new table?
Learning Oracle PL/SQL
Sample Chapter – Designed for both new programmers and those experienced in other languages, this book presents the core features of Oracle’s PL/SQL language in an easy-to-read format. Learning Oracle PL/SQL will bring programmers up to speed on the most important aspects of PL/SQL, including web an
Certifying: DBA Fundamentals II
By Jim DiIanni – The Oracle9i Performance Tuning exam is the second exam you must take to achieve the Oracle Certified Professional (OCP) level of certification. This is the first of two columns regarding the topics you will likely encounter on the Oracle9i Performance Tuning exam, and it includes a
XQuery, the Query Language of the Future
XQuery 1.0 still has to reach W3C Recommendation status, but the available implementations and technology previews show that it is a very potent query language.
The New Role of XML
by Carl Sjogreen – As XML has become more mainstream, and there is much more XML data floating around the enterprise, new technologies have been developed to better process and manipulate XML inside applications. As a result, the role and location of XML use in applications is shifting. We are start
Why Choose RSS 1.0?
by Tony Hammond – Part of RSS 1.0’s value is in retaining its roots as primarily a metadata specification. A journal publisher explains why they chose RSS 1.0 as the basis for distributing RSS feeds of their publications.