(Drew Georgopulos) Permissions are restricted in most environments. Even in development environments, only members of the sysadmin and serveradmin fixed server roles can execute the sp_sdidebug and sp_addmessage extended procedures to grant use of SQL Server’s debugger and custom error messages, lea
Other News
Want to Change Your Identity? Consider Sequence Objects in Version 8
(Susan Lawson) In the past two colums I have covered topics regarding Version 8 features that we may want to consider in the databases and applications that we are designing today. We have talked about the new data partitioned secondary indexes and additional index changes, and in the last issue we
Heterogeneous Database Query Optimization in DB2 Universal DataJoiner
(Shivakumar Venkataraman and Tian Zhang) DataJoiner (DJ) is a heterogeneous database system that provides a single database image of multiple databases. It provides transparent access to tables at remote databases through user defined aliases (nicknames) that can be accessed as if they were local ta
SOAP, .NET, and COM – an Introduction
(John Godel) SOAP is a protocol specification to invoke methods on servers, services, components and objects. The available procedure of using XML and HTTP as a method invocation mechanism is implied by SOAP. A small number of HTTP headers that facilitate firewall/proxy filtering are authorized by t
Stored Procedures, Triggers and User Defined Functions on DB2 Universal Database for iSeries
(Hernando Bedoya) Stored procedures, triggers and User Defined Functions are the key database features for developing robust and distributed applications. In V5R1, SQL Triggers are supported on DB2 Universal Database for iSeries to give much more portability to the database. This IBM Redbook inc
The CIO’s Seven P’s of Enterprise SQL Server Management
(Jeremy Kadlec) The quiet buzz has turned into a big bang with enough people saying IT needs “to do more with less!” Now is the time to satisfy these demands for your Enterprise SQL Server implementation. As your staff takes on this initiative “to do more with less,” do not fall victim to sacrifici
Atom API Update
(Joe Gregorio) Version 8 of the draft Atom API for weblog authoring has just been released. The new version contains substantial changes from version 7, which was covered by Mark Pilgrim in a recent XML.com article “The Atom API “. Despite the changes, the API hasn’t left its guiding principles behi
Empowering DB2 with your Excel spreadsheets using Apache’s POI and HSSF
(Michael Epley and Kulvir Singh Bhogal) In this article, you’ll learn how to build an application that will allow for the efficient transfer of Microsoft Excel spreadsheet data into a DB2 UDB database using Apache’s POI and HSSF.
Generating New SQL Server Logins
(Gregory A. Larsen) If your organization has the kind of revolving-door staff turnover that many businesses are facing, you create new logins frequently. So how do you create a new SQL Server login that has the same permissions as an existing login? Each time you create a new SQL Server login that m
Oracle JDeveloper 10g: Application Development Framework
(Harshad Oak) Developing Java 2 Enterprise Edition (J2EE) applications using Java Server Pages (JSPs)/Servlets and Enterprise JavaBeans (EJBs) is quite popular. However there is no denying that J2EE can get quite complex at times. You need to understand many things to be able to deploy a quality J2E