(Serdar Yegulalp) SQL Server has two basic administrative options that control how much memory is used by the program: dynamic and static allocation. Dynamic allocation allows the administrator to declare a range of memory sizes; SQL Server can allocate up to the maximum amount of memory allowed for
Other News
Jump into LAMP development with XAMPP
(Brendon Chase) If you have ever had to set up a Linux, Apache, MySQL and PHP or Perl installed and running at the same time you know what hassle it can be. If you are new Linux it can be a rather daunting experience just trying to set everything up, nevermind learning scripting languages like PHP,
IBM Gets Help Finding ISV Talent
(Darryl K. Taft) In a continuing effort to expand its developer base, IBM is tapping venture capital firms to find hot new companies in emerging technology areas to support IBM’s middleware platform.
Lightweight UI Test Automation with .NET
(James McCaffrey) Manual user interface testing is one of the most fundamental types of software testing and it’s the kind of testing that most software engineers first experience. Paradoxically, automated user interface tests are probably the most technically challenging kind of test to write. The
The beauty of ones, zeros, and powers of two.
(John Sample) One of the most unused features in .NET I have come across is the ORing and ANDing of enum values. I’ve been finding myself explaining this technique several times in the last week, so I figured I’d write it all down here.
Avoiding Disaster: The Database Planning Process
(Mary Duffy) When it comes to databases, disaster is easy to come by. You may have heard (or experienced) the horror stories: you spend thousands of dollars on the database you think you want, only to find out that it isn’t compatible with everyone’s system, and it doesn’t track that one essential d
Achieving Adaptivity for OLAP-XML Federations
(Dennis Pedersen and Torben Bach Pedersen) Motivated by the need for more flexible OLAP systems, this paper presents work on logical integration of external data in OLAP databases, carried out in cooperation between the Danish OLAP client vendor TARGIT and Aalborg University. Flexibility is ensured
SQL: Joins
A join is a query that combines rows from two or more tables, views, or materialized views ("snapshots"). Oracle performs a join whenever multiple tables appear in the query’s FROM clause. The query’s select list can select any columns from any of these tables. If any two of these tables have a colu
Build an XML-based Tree Control with JavaScript
(Tom Duffy) fter writing the Build an Object-Oriented Tree Control Using JavaScript article, it occurred to me that using XML as the data source for the tree would be a natural fit. I wanted to create a solution that was both maintainable and extensible. That is, I wanted to create an automated syst
Execute Remote Stored Procedures from the iSeries
(Michael Sansoterra) In multi-application, mixed-platform environments, it’s often necessary to have a job run on platform A to collect data for a job to be run on platform B. Since these diverse platforms often do not know how to “speak” to each other, one common solution has been to put the jobs o