By Nirav Chanchani – Learn about the benefits of distributed applications. Learn unit-testing basics using one of the most popular open-source testing frameworks.
Author: SSWUG Research
Build a Servlet-based Application That Executes SQL Statements Via the Web
by Joel Murach – Learn how to use a Java servlet, a JavaServer Page, and a static Java class to create a SQL gateway application that enables users to interactively execute SQL statements against a database running on a server. This application allows you to work with a database as you’re developing
DB2 System Performance Metrics Revisited
By Joel Goldstein – DB2 is a complex database management system that has a major impact upon your overall processing environment. Installations are constantly looking for ways to measure, analyze, and control its resource consumption. It addresses the origins and data available for analyzing, tuning
Protecting DB2 against Non Concurrent Application Code
DBAs have learned that performance of an application can be influenced by many factors, which in turn can influence database performance. In this article, Marin Komadina explores a real-world example of an application with a locking problem.
Installation prerequisite for Query Patroller, Version 8
Installation prerequisite information for Query Patroller Version 8 with DB2 UDB Version 8.
Trapping DTS errors with Transact-SQL
By Joseph Sack – I’ve often been asked what the “best” method is for trapping DTS errors. This is a very broad question. What errors you care about capturing can differ from project to project, and package to package.
XML Consortium Announces Emergency-Response Specs
By Keith Ferrell – An industry group promoting XML standards for interoperability among disaster responders and emergency services announced completion of the first draft of its technical specifications Tuesday.The draft Common Alerting Protocol (CAP) announced by the technical committee of
SQL Server 2000 Service Pack 3a: What It Is, Why It Is, and Whether to Upgrade
Microsoft SQL Server 2000 Service Pack 3a (SP3a) update is available and replaces the previously released SP3. If you successfully upgraded to SP3, you may not have to apply SP3a. This Support WebCast will talk about what changed and how to decide if applying SP3a in your environment is appropriate.
Oracle once again extends PeopleSoft offer
By Jon Panker – As antitrust investigators continue to evaluate its takeover bid, Oracle Corp. is once again giving PeopleSoft Inc. investors more time to tender their shares.The deadline has been extended to midnight on Sept. 19. The offer would have expired on Aug. 15.
SQL Server interview questions
(Vyas Kondreddi) Here are some SQL Server DBA/Developer interview questions I faced myself personally and/or heard from people. I will try to answer these questions briefly here, but be advised that these answers may not be complete and it will be better for you to go through text books, books onlin