|
September, 2006
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
How Much Do Concurrent Updates Impact Query Performance in Oracle? by Roger Schrag Oracle has a strict read-consistency model coupled
with high concurrency that sets it apart from other database
products such as Microsoft’s SQL Server. You can update rows in a
table while I query those very same rows. Your updates will not get
lost, my query results will not be corrupted, and neither of us will
block the other from doing their work. The net result is that with
Oracle we can run batch jobs, data loads, and reports all at the
same time and never worry about things like “dirty reads” or “read
locks.” However, this great functionality comes at a cost to
performance—Oracle has to do more work to ensure read-consistency if
one user is updating a table while another user is querying it. This
raises the question: Just how much slower will a report run if a
batch update job is running at the same time? Click here for the paper.
It’s Almost Here! This fall’s BIG Toad™ announcement is just around the corner. Don’t miss out - sign up today and be the first to hear the news!
| ||||||||||||||||
|
||||||||||||||||
|
Managing DB2 Performance Across Linux, Unix, Windows and z/OS Obtaining optimal performance from your DB2 applications is a multi-faceted exercise. DB2
performance optimization cannot be limited to simply tuning SQL. You need to have an
understanding of how factors such as memory, physical design, and maintenance can
affect performance. If you are a DBA having to manage DB2 on multiple platforms, it is
important that you have an understanding of what needs to be monitored.
Click here
for the white paper. | ||||||||||||||||
|
||||||||||||||||
|
Design Patterns In PL/SQL—Pre-Inventing the Wheel Some of those Java upstarts may try to dazzle you with their frameworks, object orientation and most of all: their precious Design Patterns. Although sometimes these patterns are pretentious and hollow, more wrapping than gift, there is definitely a lot to be learned from some of these design patterns. And not just for Java programming: many patterns are applicable to the world of PL/SQL as well. This article will show how we can improve the design of our PL/SQL applications by making use of some of the popular Java/J2EE design patterns. We will look at the Template Pattern and the Observer Pattern, as well as aspect-oriented programming (AOP) and see how they all apply to PL/SQL programming. Click here for the article.
|
||||||||||||||||
|
||||||||||||||||
|
Capturing Executing Queries Using sys.dm_exec_requests In addition to capturing queries in SQL Server Profiler, you can also capture the SQL for currently executing queries by querying the sys.dm_exec_requests dynamic management view, as this recipe demonstrates. Click here for part 2 of the excerpt from the book, SQL Server 2005 T-SQL Recipes (Apress).
In A Nutshell
Interested in learning more tips and techniques for SQL Server? "In A Nutshell"
is what you are looking for. Kevin Kline,
author of O'Reilly's "SQL in a Nutshell" and "Transact-SQL Programming" and President of The Professional Association for SQL Server,
offers tips, techniques and much more. Updated numerous times a week,
there is always valuable material to be had!
Click
here
to see what Kevin is up to in the SQL Server world. | ||||||||||||||||
|
||||||||||||||||
|
Connecting the MySQL GUI Tools to a Remote Server through a Firewall A large percentage of MySQL users are using MySQL on a web server hosted by an ISP. Most hosting providers block port 3306 (the MySQL server port) at the firewall, preventing outside access to MySQL. This is an important security practice and you should be very concerned if your ISP does not block port 3306. In this article I will demonstrate how to connect the MySQL GUI tools, including MySQL Administrator and MySQL Query Browser, to a remote server using SSH port forwarding. This article will be written with the assumption that the reader is using Microsoft Windows, but the principles presented will be applicable to Linux users.
Click here to see this article. | ||||||||||||||||
|
||||||||||||||||
Many people are not sure of the differences between product management and project management. The roles should be clear. Project management is focused on the projects that are used to create or enhance a product. Product management is the process associated with the long-term care and feeding of the product once the project ends. The role of a project manager is to plan and manage a project. The role of a product manager is focused on the long-term support of the product within the organization. The product management role is as follows.
Click
here for more information on the
product management. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Sudoku
Puzzle
|
||||||||||||||||
|
||||||||||||||||
|
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, it will be mailed to over 28,000 subscribers. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please visit http://qlist01.quest.com/UnsubMailingList/ Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
||||||||||||||||
