|
May , 2005
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Average Write Time to Online Redo Logs This SQL*Plus script is a query to show average write time to online redo logs on a day-by-day as well as an hour-by-hour basis over time, using data in the STATSPACK repository. Click here
for the script. |
||||||||||||||||
|
||||||||||||||||
|
Graceful Failover and Failback Procedures, in Non-Dataguard Environments This document describes the procedures to run “graceful” failovers and failbacks of hot standby databases, in environments that are not using Dataguard. A “graceful” failover is one that does not require databases to be opened with the “resetlogs” option – and as a result, graceful failbacks do not require the primary database to be rebuilt (i.e., they do not require the standby database’s datafiles to be copied to the primary server.) Graceful failovers and failbacks are also known as “switchovers” and “switchbacks”.
Click here
for the paper. | ||||||||||||||||
|
||||||||||||||||
|
Creating Stored Outlines - Part 1
Stored outlines bring stability to your application's SQL statements. It is
possible to make a better decision than the CBO, and then to want the application use your decision over the CBO's decision. Additionally, changes in the data distribution can alter an execution plan of a SQL statement, once the CBO has new statistics on the new data. Stored outlines are also great when working with third party applications, where you cannot touch the SQL statements, but you'd like to alter how they run. You can provide execution plan stability through the use of stored outlines.
Click Here for the topic. Steven Feuerstein's Oracle PL/SQL Spotlight Series: Three dynamic Webinars, offering in-depth training with world-renowned Oracle PL/SQL author, Steven Feuerstein, on key features of the PL/SQL language.
Webinar #1: Spotlight on Collections
Webinar #2: Spotlight on Native Dynamic SQL
Webinar #3: Spotlight on Exception Handling
Click Here for more information. |
||||||||||||||||
|
||||||||||||||||
|
A quick note from Kevin Kline, the Director of Technology for Quest’s SQL Server tools Hi everyone, I wanted to take a moment to thank you for your on-going support of Quest. Because of your support, the Quest tools for SQL Server have become some of the most popular tools in the industry. We’re now working to provide you even more value with our recently announced acquisition of Imceda. (Read our press release at http://www.quest.com/news/show.asp?ContentId=1496&ContentTypeId=2&site.) SQL Server Magazine is currently holding a readers’ choice award and I and everyone on the team would appreciate it if you would continue your great support for the Quest family by going to http://www.windowsitpro.com/sqlserver/readerschoice/ and, once you’ve registered, voting for Quest and Imceda. By voting for your favorite product in the 2005 SQL Server Magazine Readers’ Choice Awards you could win an iPod Shuffle from SQL Server Magazine or a SQL Server Magazine t-shirt. Hurry! Voting ends May 15!
Click Here for details. | ||||||||||||||||
|
||||||||||||||||
|
Effective Data Filtering
This is the second article intended to illustrate professional programming techniques using Visual Basic and MySQL. The first article discussed why we should avoid data binding. It can be viewed here. This article discusses writing software that helps the user effectively work with large amounts of data. The approach that I will describe is called filtering. I have expanded on my sample program from the previous article to exemplify the techniques that are described herein. You can download it here.
Click Here for the paper | ||||||||||||||||
|
||||||||||||||||
Many projects have one overall budget that includes all of the project labor costs, hardware/software costs, materials costs, etc. This is fine for smaller and medium sized projects. However, as a project gets larger it helps to have the overall budget broken down into smaller subsets. This is a similar to the concept of breaking down a project with long duration into a set of smaller projects. Having your budget allocated at a lower level allows you to keep better control of the details and it may point out potential budget trouble quicker than having everything rolled up into one consolidated project budget.
Click here
for more information | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Where Am I?"
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
