(Bob Watkins) One of the trickiest problems to troubleshoot is the interaction between multiple applications that access the same data. Although each application in itself may be well-behaved, each app may make assumptions about the data that another doesn’t. As a result, rows can appear, get change
Author: SSWUG Research
Set Your Web Site’s Navigation Structure Easily with ASP.NET 2.0 Site Maps
(Bipin Joshi) If you’ve ever traveled to unfamiliar destinations, you know the importance of maps. They help you to travel easily, making your journey more pleasurable. The same holds true for Web sites. A Web site should present visitors with a simple yet flexible navigation structure so that they
Powerful, Flexible Text-Formatting Solutions in SQL Server
(Alex Kozak) Removing extra empty spaces is a pretty common task that seems very simple, but in reality it is not as trivial as you may assume. The first impulsive solution that many programmers try is replacing two empty spaces with one, which works as long as the number of empty spaces doesn’t exc
Maximize the performance of WebSphere Information Integrator with Materialized Query Tables
(Anjali Betawadkar-Norwood, Valer-Alin Crisan and Eileen Lin) A materialized query table (MQT) is a table that materializes the pre-computed result of a query involving one or more tables or nicknames. After the MQT is created and populated, an arbitrary subsequent query may be satisfied by the MQT
XML Matters: Up and Atom
(Dethe Elza and David Mertz) As a syndication format, Atom grew out of experience with the various flavors of RSS (of which there are many), not to create something entirely new, but to tighten up places where the specification of RSS was too vague to be useful (for instance, RSS does not specify wh
Introducing the MySQL Sandbox
(Giuseppe Maxia) Installing a side instance of MySQL for testing purpose is a task that many administrators can perform without breaking a sweat. If you need to do that only once in a while, you need just to read the manual carefully, or to have some experience in this matter, and the task is accomp
First Look at the Class Designer
(Bradley Jones) In Visual Studio 2005, Microsoft has added a new tool called the Class Designer. This now workspace and toolbox can be found in most of the editions of non-free versions Visual Studio 2005.
Reporting Services tool set in Management Studio goes real-time
(Jeremy Kadlec) In SQL Server 2000 Enterprise Manager, the Task Pad view was really the only native-reporting interface available and it was limited to database and object-related information. In SQL Server 2005, Microsoft integrates Management Studio and Reporting Services to provide snapshots of r
Oracle Bid For Portal Software Delayed
(David A. Utter) Portal CEO Dave Labuda announced the sale of his company to Oracle in April. The $220 million deal appeared to be a fait accompli given the company’s shaky history according to a Mercury News report.
OpenAJAX Alliance Sets Road Map
(Darryl K. Taft) The semiformal effort to set a direction for Asynchronous JavaScript and XML-style development got off to a sound start, setting the tone for the group’s goals and establishing a name for itself: the OpenAJAX Alliance.