|
March, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
SQL Server Adventures for the Oracle DBA by Janet Wong This article explains one woman's transition from the familiar world of Oracle to the foreign SQL Server realm, and many lessons she learned along the way. She now would like to pass those lessons on to you! Click here for the article.
|
|
Table Spaces And Locking Levels, Part 2 The LOCKSIZE parameter is part of the CREATE TABLESPACE data definition language. What are the options for that parameter? In general (without regard to table space type), we can choose from five LOCKSIZE parameter values: TABLESPACE, TABLE, PAGE, ANY, and ROW. The larger the LOCKSIZE value (the farther to the left in that list), the lower the overhead and the less concurrency (in other words, one or two locks can buy you access to everything you need to see, but might cause others to have difficulty accessing the data that you control). The smaller the LOCKSIZE (the farther to the right in the list), the more overhead, but also the more concurrency (in other words, for the price of more locks, more people can be using the data simultaneously without getting into each other's way). These locksizes are referred to as locking levels (as in, "I am doing page-level locking," or, "this table space is defined with row-level locking").
Click here
for the article.
Developing DB2 9 Pure XML Applications Using TOAD for DB2 Using the Silver Castles analogy described and developed in the article “Use DB2
Native XML with PHP”, from Hardeep Sing and Amir Malik. The goal of this
demonstration is to illustrate the different database environments and their impact
on the application code by performing a side–by-side comparison of the application
code needed for (i) DB2 9 pure XML and (ii) a relational database without any XML
capabilities, e.g., MySQL. The analogy stems from an application modeled around
an online shop selling antique silverware to registered customers. The Silver Castles
application demonstrates that DB2 9’s pure XML capability can be extremely
powerful to simplify and adapt your applications rapidly to new business demands.
In this paper, we will describe how TOAD can be used to develop the Silver Castles
application using DB2 9 pure XML as the database. TOAD provides a powerful
database development and administration tool that has integrated wizards for
design and database administration, editors for developing queries and stored
procedures, and debugging support. At this time, the TOAD wizards have not been
extended for DB2 9’s XML support. However, we will show that TOAD can be used
quite effectively to develop DB2 9 XML applications.
Click here
for 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.
|
| Partitioning with Dates in MySQL 5.1 Many of you have responded very positively on the first and second partitioning articles that I wrote some time back. It’s clear that a lot of you are excited about the upcoming MySQL 5.1 release, and in particular, the new data partitioning feature that’s being offered. That’s no surprise because, as we covered in the previous two articles, partitioning has some excellent performance and management benefits for anyone who’s building data warehouses or other large databases with MySQL. Click here to see this article.
|
|
Most organizations recognize that they need to do a better job delivering their projects on schedule and within budget. So, why don’t all organizations do a better job of embracing project management principles? Click here for more information on organizations use of good project management discipline..
|
| Webcasts
|
|
|
|
Interactive Crossword
Puzzle: "The 'F' Word"
|
|
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
