(Chris Eaton) Now let’s look into locking snapshots. Before we get into the full script I want to cut and paste just a portion of the script here. There are 13 different lock modes that exist in DB2. Of course you are probably already aware of the common ones like Share and eXclusive, but there are
Other News
SQL Server 2005 Express Edition: A cautionary tale
(Arthur Fuller) Like thousands of developers, I eagerly downloaded SQL Server 2005 Express Edition mere moments after receiving an e-mail from Microsoft. Unfortunately, after installing it on my development box, I realized that I had a mess on my hands. Hopefully, by sharing my experience with S
Programming with Partial Classes in VB.NET 2005
(Paul Kimmel) Sometimes I wonder what motivates language developers to make some of the design choices they do. In fact, I’d like to arrange events called Authors Summits, where the language vendor, such as Microsoft, explains its decisions directly. Imagine gathering about 200 authors in a room.
Oracle Hints At ‘Lifetime Support,’ More Acquisitions
(Barbara Darrow) Oracle execs dropped some tantalizing hints at Oracle OpenWorld’s partner confab.
Tree structures in ASP.NET and SQL Server – Introduction
(James Crowley) Trees can be an intuitively simply way of organising large amounts of information. We’re exposed to them everywhere – from directories in file systems and categories in a web directory to hierarchies in organisations and family trees! Something like XML handles hierarchical data well
Perl functions 101
In this article we explore some of the most useful Perl functions for manipulating arrays and hashes, how each one works, and when it should be used.
Cutting Through the Hype: Where Web Services and SOA Are Really Working
(Louis Columbus) The move by database developers to include object-oriented programming languages has changed the scope of application development and is acting as a catalyst for web services development. Being able to define stored procedures in object-oriented languages is leading to an entirely n
Beginner’s Guide to Crystal Reports, Part II: Web Apps
(tvmogul) Part I of this article contained needed background information and dealt with Winforms. You should read it before reading this article. This article, Part II, deals with Web Apps.
FIX: An access violation may occur when a deadlock graph is written to the error log in SQL Server 2000
Consider the following scenario: • You enable the 1204 trace flag in Microsoft SQL Server 2000 to identify SQL Server deadlock events. • A deadlock event occurs, and a deadlock graph is automatically written to the SQL Server error log.
Sybase ASE 15 DB, Tools Hold SQL-XML Vision
(Vance McCarthy) The latest upgrade to Sybase’ enterprise database, ASE 15, does a great deal more than offer a faster, more scalable database.