(Alexander Shirshov) Developers working with Microsoft SQL Server enjoyed declarative handling of transactions since Windows NT 4.0 days. With .NET Framework this usually means we need to inherit a class from ServicedComponent, apply TransactionAttribute to it and use SetAbort/SetComplete methods to
Other News
Unlocking The Secrets Of Open-Source Success
(Larry Greenemeier) The story of open-source software has largely been one of success to date. Open source has grown exponentially in popularity among Web users, and it’s making headway in corporate application-development environments, even influencing the ways in which proprietary app vendors crea
Data Warehousing Lessons Learned: Very Large Data Warehouses Challenge Backup
(Lou Agosta) As the number of data warehouses at least one terabyte in size has grown from 21 percent in 2002 to 43 percent of enterprises in 2004, many have asked Forrester: Is it feasible to back up the database? Complaints have included: 1) the backup won’t fit in our batch window, 2) we don’
Oracle technology platform drives Egypt’s comprehensive e-government initiative
As part of a comprehensive e-government initiative, Egypt’s Ministry of Communications and Information Technology (MCIT)/ MSAD/MOF has licensed a comprehensive range of Oracle technology to ultimately power and link up to 5000 financial units throughout the country.
Object Interaction in PHP: Introduction to Aggregation, part 2
(Alejandro Gervasio) This second part of this series gets a little more technical with the basics of Aggregation. It begins working with a MySQL abstraction class and a useful paging class, and is starting to get into writing portable code and introducing the technique of aggregation.
Attributed Programming in .NET Using C# – Introduction
(Deepak Dutta) An attribute is a powerful .NET language feature that is attached to a target programming element (e.g., a class, method, assembly, interface, etc.) to customize behaviors or extract organizational information of the target at design, compile, or runtime.
Creating XML from legacy data
(Edmond Woychowsky) Nebulous is a great word, not only is it fun to say, it is also useful in describing the requirements for a project that I worked on recently. The requirements went something like this; take a flat file, that was produced by an upstream mainframe application and produce an XML do
Custom user-defined string functions by Igor Nikiforov
(Serdar Yegulalp) Montreal-based SQL Server programmer Igor Nikiforov has written a number of useful Transact-SQL custom string manipulation functions that can be put to work in a variety of database projects. Many of these functions would normally be performed by business logic (for instance, in an
Control text formatting in .NET using the IFormattable interface
(Tony Patton) Every application seems to present unique challenges for displaying text. These hurdles are easily cleared by utilizing format classes. The .NET Framework includes basic format objects for standard types, and it is easy to develop custom classes to fit your needs.
Use Heterogeneous Services to access non-Oracle data
(Scott Stephens) Oracle’s Heterogeneous Services (HS) allows users to access data stored outside Oracle as if the data were in a local Oracle table. It can be intimidating setting up HS in Oracle SQL*Net, so check out these simple examples.