(Don Peterson) Everyone knows that a transaction is defined as a “Unit of work.” The transaction completes only if all the individual steps are successful, otherwise it all rolls back as if nothing ever happened, right? That simple definition belies some devilishly complex behavior on the part of SQ
Other News
Display Your Data Your Way with Custom Renderers for Reporting Services
(James Yip) SQL Server 2005 Reporting Services from Microsoft is a great tool that offers a centralized approach to storing and rendering reports. It also allows users to view and download reports without installing additional software. But what’s most convenient for users is that reports can be sav
Extracting Privilege Sets and ACL Codes from DB2 Content Manager for z/OS
This document shows you how to extract privilege sets and ACL codes from IBM DB2 Content Manager for z/OS.
Cybermation: Oracle Tamed
(Lyne Bourque) So you made that New Year’s resolution to spend more time generally bettering yourself and excelling in various aspects of your work. Right? But lo’ and behold, the Oracle database needs attention.
Find TCP/IP Sockets Net-Libraries port number used by SQL Server 2000
(Muthusamy Anantha Kumar) When a DBA is managing many different SQL Server boxes, it can be a tedious job to find the port numbers used by all of the SQL Servers. In this article, I would like to discuss several methods for finding the Port numbers used by SQL Server.
Five Undiscovered Features on ASP.NET 2.0
(Jeff Prosise) By now, developers everywhere have had the opportunity to download the first beta of the Microsoft .NET Framework 2.0. ASP.NET developers who have played with it are no doubt salivating at all the cool new features. From Master Pages to declarative data access to new controls to a
PostgreSQL 8.0 tackles the Windows market
(Ingrid Marson) The recent release of PostgreSQL 8.0 means that Microsoft users will now be able to run the open source database PostgreSQL natively on Windows. Previous versions required the Cygwin Unix emulation toolkit to run on Windows servers.
Editing XML Files with Microsoft Excel
(Andrew Mooney) With all the talk about integrating XML into business applications you would think that at least one of these programs would allow you to edit XML without coding the HTML tags. Well, you’re right Microsoft Excel 2003 can do it for you.
Microsoft .NET – The Big Picture
(Andrew Hudson) The goal of this paper is to provide a business overview of Microsoft’s .NET initiative, how it ties together a variety of products into a corporate strategy, how it was used to respond to competitors, what strategies Microsoft used to drive .NET forward, and what problems occurred d
Oracle Real Application Clusters
(Kevin Loney) In an Oracle Real Application Clusters (RAC) environment, multiple instances access a single database. The instances are commonly created on separate servers that are connected via a high-speed interconnect with access to a shared disk area. The database files reside on a shared set of