(Kailash Awati and Arati Apte) Applications often require row-level access control to data – i.e. users should be able to see only rows that they are authorized to. As a concrete example: consider an order processing system where a number of clerks enter orders into a single table. In such a sit
Other News
An Overview of SQL Server 2005 for the Database Developer
(Matt Nunn) This document provides an overview of new features for database development in Microsoft SQL Server 2005.
The Fallacy of the Data Layer
(Rocky Lhotka) It is commonly held as a truth that applications have a UI layer, a business layer and a data layer. In most of my presentations and writing I use a four layer model: UI, business, data access and data storage. In this case the “data storage” layer is really the same as the traditiona
Automating Reindexing In SQL Server 2000
(Tom Pullen) In all OLTP environments, virtually all indexes will become fragmented over time. Nearly all UPDATE, INSERT or DELETE activity will cause your indexes to become less well organized than they were when they were first created. There will be more page splits, there will be a greater n
What’s new in JAXP 1.3? Part 2
(Neil Graham and Elena Litani) In this article, the authors follow up on their overview of JAXP 1.3 in Part 1. They touch on utilities that add support for concepts defined in the Namespaces in XML specification, and describe changes to the javax.xml.transform package. They also discuss the new Java
The Cloudscape Detective
This tutorial introduces new users of IBM’s Cloudscape Database to relational database concepts through a fun and interactive game called Cloudscape Detective. (R)
Database Templates with MySQL
(Russell Dyer) Once you’ve built several MySQL databases, you’ll learn some shortcuts to database design. Many databases are very similar. When creating new databases, developers often build the same basic tables with only slightly different names and some adjustments to columns. Rather than sta
DDL Triggers for SQL Server 2005
(Vinod Kumar) There are loads of features we can explore in SQL Server 2005. Here is one such feature that I personally would call it as the DBA’s requirement. Here in this article we will take a snapshot to what DDL triggers are and how it can be extended to our needs. DDL Triggers are new in SQL S
Oracle Session Tracing Part III
(James Koopmann) Explore how to enable and disable Oracle tracing with DBMS_MONITOR package in 10g.
Delphi 2005 Architect Review
(Glenn Stephens) Delphi has grown up since it launched nearly ten years ago. The latest version – Delphi 2005 provides support for developing Win32 and .NET applications as well as now supporting the C# language as well. There are many enhancements to almost all areas of the new release with the mai