|
October, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
More Partitioning Choices Learn when and how to use new partitioning schemes in Oracle Database 11g. In Oracle Database 11g, the partitioning schemes have been greatly expanded to offer more functionality, including the ability to define new composite partitioning, choose a partition interval, specify a foreign key to inherit the partitioning key of its parent table, and partition on virtual columns. Consider a hypothetical company, Acme Hotels, for which you are building a hotel reservation system. One core table, named RES, stores the reservation information. Here are the columns of the RES table . . . Click here to read the article. Query Organizer Tool for Oracle DBA
This paper presents the need and details of a SQL Query Organizer tool which organizes the queries in a specific format and runs them against the oracle database. Architecture of the web base tool developed is discussed along with new advancements like running on click, sharing in XML format and formatting output using graphical tools that can be added are suggested. Click here for the paper.
|
Automated Refactoring Arrives for PL/SQL Developers! |
by Steven Feuerstein Here I sit in the Praha (Prague) airport waiting for a flight back to Chicago. Over the last ten days, I have been on a whirlwind round of trainings and seminars in Prague (Czech Republic), Zagreb (Croatia), Ljubljana (Slovenia) and Bratislava (Slovakia). Very nice countries, wonderful people. And some really sharp technologists, too. I was inspired by their questions and ideas to finally build a tool to automatically refactor PL/SQL programs to improve modularity, reuse, and readability. As far as I know, what you are about to read and the code you are about to get your hands on, offer the first automated refactoring capability in the world of PL/SQL. Click here for the article and utility.
|
Modifying Tables and Keeping Like Columns Together | by Edgewood Solutions Engineers When designing tables you may not always know what columns need to exist prior to when the table is created. Therefore over time table changes are made where you may add or drop columns. Based on this table modification you may want to have certain columns next to each other for easier management and grouping of like data in the table structure. It doesn't really matter to SQL Server where the column is located, but to us humans it sometimes makes a difference. Dropping a column is not a big deal because the column just goes away, but when adding a column the default process is to add the column to the end of the table. So how can you modify the table structure so all of the like columns are next to each other? The short answer is that there is not an easy way to move columns around once the table has been created, but let's take a look at a couple of examples and why this is not that straightforward. Click here to see the article.
Disaster Recovery & Business Continuity for SQL Servers Through a Standby Approach Businesses of all sizes must take backup and disaster recovery seriously. As companies grow and data becomes more and more prevalent, users of all types, either internal or external, require access to all this information. This is essential at a time when even the smallest business may find operations impossible with any single point of failure. The ability to recover critical data quickly after a disaster is a fundamental requirement of economic viability and business continuity. With the launch of Microsoft SQL Server 2005, Microsoft SQL Servers are becoming increasingly popular for use in mission critical environments. With such important dependencies on software solutions, recovering from failures is crucial for business continuity. To initiate movement towards redundancy and failure protection, Microsoft offers SQL Server Log Shipping (SQL Server 2000 and 2005) and SQL Server Database Mirroring (SQL Server 2005) in its core products. In addition to Microsoft, third party vendors, including Microsoft Gold Certified Partners such as Sonasoft, provide enhanced software solutions that simplify disaster recovery scenarios through easy to use Management Console and automating most of the manual steps. These components are focused on minimizing downtime while maximizing data retention in the event of catastrophic failure. Click here to see the paper.
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.
|
| MySQL Tips and Tricks MySQL is an open source relational database management system that's been around for quite some time now. It's mostly used for backing webbased blogs, CMSes, calendars and other online collaborative tools. It's also a vital part in the so-called LAMP system architecture, where LAMP depicts:
Because of this hugely popular software base, MySQL has gotten a lot of attention and users over the last years. There are many who would argue that MySQL is inferior to other open-source offerings like PostgreSQL and in a way they're right. MySQL is only recently becoming a viable software package for trusting your database to. In this article, which will be updated over time to become a central source of information about MySQL ins and outs, I will present some techniques which will make your life easier. Especially the administration and tuning of the database server will be described. Click here to see this article.
|
|
Inherent risks are those that exist based on the general
characteristics of the project. These are risks that can appear regardless of
the specific nature of the project. None of the inherent risks by themselves
mean that the project is in trouble. Even if you identify an inherent risk as
high, other project factors will come into play as well. For instance, the
checklist below states that a large project is inherently more risky that a
smaller project. This is generally true. However, an experienced project manager
can mitigate many risks associated with large project size. Also remember, if
your project falls into a high-risk category, it does not mean you will not be
successful. It only means that you should put plans into place to manage the
risks.
Click
here to learn more about identifying project risks.
Webcasts Interactive Crossword
Puzzle: "Word Play"
Click here
to Play! 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/
Do you know someone who would like to
receive the Pipeline Newsletter? If so,
click
here!
Past Issues of the Pipeline
Newsletter
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Refer a Friend!
