|
September, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Partitioning to Perfection "Divide and conquer"—that figurative principle has never been better illustrated than by Oracle Database's partitioning features. Since version 8, you can partition a table or index into multiple segments and then place them in different tablespaces. The table is still addressed as a logical entity while the individual partitions are stored as separate segments, which allows for easier manipulation of data. In version 11, enhancements such as reference partitioning, interval partitioning, partitioning virtual columns, and extended composite partitioning enable infinite partitioning design possibilities and boost manageability. Click here to read the article.
|
|
Data Security Beyond Regulatory Compliance In increasingly complex technical and business environments, no one security approach can deal with all the new and innovative intrusions. But the lack of a security silver bullet doesn't mean data security is impossible. It simply means that businesses have to take a multi-pronged approach to data security. Today, enterprises must comply with industry and government regulations that require businesses to ensure the security of sensitive information. At the same time, databases are at increased risk from both internal and external attackers who no longer simply seek notoriety but, instead, want financial rewards. Although layered approaches are required, there is one truth in data security: The sooner sensitive data gets encrypted, the more secure the environment. Early data encryption will protect sensitive data at rest and while it’s moving between the applications and databases and between different applications and data stores.
Click here
to read the article.
|
Engineering Better PL/SQL for Simpler, More Effective Database Applications |
by Bert Scalzo PL/SQL is relatively simple to learn, is well integrated into the Oracle database, and is often the most efficient way to perform complex or large-scale database operations. However, there is no guarantee that your programs will be easy to read, maintain as well as, effective, error-free and efficient. This paper examines some commonly-used manual methods and their shortcomings, and then offers scientific advice for improving upon the PL/SQL development process. Click here for the paper.
An ODTUG Seriously Practical Conference for Oracle Developers and DBAs who rely on PL/SQL to get their jobs done.Click here to register!!
|
Monitoring File Sizes in SQL Server - Part 4 | by Roy Carlson I was all set with this great intro when reality barged in. We just had an incident today where this script made my day. We monitor server freespace and overnight our space dropped from 19.23g to 12.51g almost 7g on a allocated 30g partition. We looked for the cause and no major dump of files under 100 meg occurred. We checked and all files over 100g looked normal. We rebooted and the missing space reappeared. The only file difference was a cache file that disappeared after reboot but it only had 152 meg, nowhere near the 6+g. Obviously a problem with the 2003 Server. We are not sure what specifically happened. The logs showed no abnormalities. I have seen this with NT servers, but never on a 2003 server. The trouble was detected was not related to the SQL database size but server space, but two more days with drops like these could have shutdown the database. This time we are going to read the size of the SQL Server size, freespace, used space, get the percentage free, put it all into an Excel spread, part Lake Michigan and make a mocha latte. Okay maybe I kind of lied about parting Lake Michigan and making a mocha latte, but the rest was true - honest.! Click here to see the article.
Microsoft SQL Server Cluster Vs Standby Server The concept of High Availability is not limited to an Enterprise world anymore. It has already sneaked through the doors of SMB market which brings up new potential challenges for DBAs. This paper discusses specifically two out of various options available for SQL Server high availability, Microsoft SQL Server Cluster (active/passive configuration) and Standby Server. Click here to see the article.
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.
|
|
Issues are a “formally defined” problem that will impede the progress of the project and cannot be totally resolved by the project manager and project team without outside help. The term “formally defined” means that you understand the issue well enough that it can be documented. In other words, if you do not understand the problem well enough to document it, you are not in a position to resolve it. The Issues Form and Issues Log are used to “formally define” the issue on large projects. You can manage issues differently depending on the size of your project. The
following issues management process can be used on large projects, where more
project management rigor and structure are required.
Click
here for more information on using
this process.
Webcasts Toad Project Watson is currently in Beta and seeking additional testers. To join the beta program, go to the link below: http://www.toadworld.com/DevTeam/ProjectWatson/tabid/147/Default.aspx Get a Toad t-shirt for reporting a verifiable bug and a 4GB Apple iPod® Nano for reporting the most bugs during the beta program! Interactive Crossword
Puzzle: "Important Dates"
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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Toad Project Watson empowers effective decision making by giving you insight into your business
data, enabling IT professionals to access and understand their data from any source with one tool.
It has the ability to define relationships; gather and understand where the data resides; and query,
export, publish and automate the reports for the business community.
Refer a Friend!
