(Roger Sanders) Here’s a quick way to stay on track with your preparation for the DB2 9 DBA certification exam, even at this busy time of year: Try these sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The q
Other News
How to construct and use SQL OUTER JOINs optimally
Learn the basics of a SQL Server OUTER JOIN in this excerpt from “SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition.” You’ll discover how to construct LEFT, RIGHT and FULL OUTER JOINs with how-to examples through sample statements and tables. Authors John L.
Oracle Tuning Using Tracing, STATSPACK, AWR and Toad
(Steve Callan) Depending upon what you’re investigating when it comes to performance, one tool may be all you need to answer the question at hand. For more complex questions, chances are several tools may be needed. Tools, in this scenario, can consist of using an explain plan, monitoring sessions a
Manage an HTTP server using RESTful interfaces and Project Zero
(Dan Jemiolo) WS-* users and REST users have an ongoing debate over which technique is most appropriate for which problem sets, with WS-* users often claiming that more complex, enterprise-level problems cannot be solved RESTfully. This article puts that theory to the test by trying to create a REST
Using VS2008 to Target .NET Framework 2.0 with ASP.NET AJAX
(Brad Abrams) As I mentioned last month, VS 2008 fully supports building applications for .NET Framework 2.0… This is very important as it will take time for some hosters and IT organizations to fully deploy .NET Framework 3.5, but you don’t want that to block you from taking full advantage of t
MVCC: Transaction IDs, Log Sequence numbers and Snapshots
(Peter Zaitsev) MySQL Storage Engines implementing Multi Version Concurrency Control have several internal identifiers related to MVCC. I see a lot of people being confused what they are and why they are needed so I decided to take a time to explain it a bit. This is general explanation, it does not
XForms and Ruby on Rails at the Doctor’s Office, Part 1: Setting up IBM DB2 9 pureXML
(Michael Galpin) This is the first article in a four-part series about using XForms, IBM DB2 pureXML, and Ruby together to more easily create Web applications. In this series you will develop a hypothetical application for managing patient information at a doctor’s office. You will get a taste of th
Creating a Data Access Layer for Paging in SQL Server 2005 – Part 2
(David Beahm) In the first part of this two-part article, we created the SQL database objects and .NET classes that will provide the database backend for an ASP.NET website. In this part, we will tie that logic to an ASP.NET page with a GridView and DetailsView. In contrast to the first part’s empha
Manageability
(Arup Nanda) Deep down, an Oracle Database Instance is a collection of processes such as PMON, SMON, and memory areas such as System Global Area (SGA) and Program Global Area (PGA). Within the SGA, there are several sub areas such as database cache, the large pool and so on. How do you decide how bi
Renaming xml attributes in VS2005 using Regular Expressions
(Mitch Fincher) In our product at work we have zillions of xml test files to feed nUnit. Refactoring becomes a problem when we want to rename an attribute in all those files.