Scott Ambler recently contacted me to tell me that he is now an employee of IBM working in the Rational area and that he and co-author Sadalage Pramodkumar have published a book that might be of interest to the database community. Scott gave me a copy of the book and it certainly looks interesting. Take a look at the abstract of the book and let me know what you think:
Refactoring Databases: Evolutionary Database DesignAuthors: Scott W. Ambler, Pramodkumar J. SadalageISBN: 0321293533
This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments.
The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.
Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.
*****Save 40% on Select DB2 Books For a limited time, you can save 40% plus free US shipping on three of our most popular DB2 books. Enter case-sensitive coupon code: IBMDB2 at Step #3 during checkout to receive the discount, and complimentary shipping. Order now as this offer expires 12/31/06.
Keep on Learning
svisser1 2700018UK9 3,234 Views
svisser1 2700018UK9 3,222 Views
I'm very much looking forward to this BLOG experience! I enjoy writing and hope that I am able to share some valuable tips with everyone who is reading.
My passion is getting books published that will help people become more effective when using IBM technology. Although I would love to write and publish more books myself, I feel there are people more qualified than I am. I enjoy meeting with intelligent and talented people and working with them to get their books published so they may enjoy the experience of having a book or two published!
I plan to give tips to authors about how to approach a book and hope to build further awareness for the books that we've already published. I'm constantly surprised that not everyone is aware of all the great books that IBM Press has published over the past few years.
In my job as proctor for DB2 exams, I am asked many questions about how to prepare for exams, how to benefit from certification, and what exams should be taken. I plan to give some advice in this area as well. I give about 300 exams a year to IBM employees at the Toronto Lab and about 2000 per year at conferences. I enjoy talking to people about their experiences and hope to pass some of that knowledge on to you.
I work with a very passionate team of people who are trying to increase the number of skilled DB2 people around the world. I thank my team in advance for giving me the confidence to run this blog and for the tidbits of information that they will ask me to pass along to you. My team has specialists in academia, tutorials, CBTs, certification, training channels, content developers and more! If you have any comments or questions about training programs or opportunities, feel free to post a commment here and with the help of my talented team, I will ensure that you get an answer!
I think that adequately covers my motivations for wanting to own a BLOG. As for my expecations, I hope to be able to find the time to post 2 or 3 times a week and really look forward to hearing from any readers.
That's all for now.
IBM Press Program Manager
The postings on this site are my own and dont necessarily represent IBMs positions, strategies or opinions.[Read More]
Sam Poon dropped by today to take a certification exam and reminded me about a recent article that he and Cindy Wong had published on developerworks, called:
"Recommended reading list: DB2 UDB for Linux, UNIX, and Windows database administration"
This reading list covers primarily articles that you will be able to find on dworks, as well as a couple of websites and redbooks. I'd like to add a few additional resources to the list for your awareness.
1) Website: DBA Central - Resources for IBM Information Management database administrators
Bookmark this page to keep up to date with all the latest information that a DBA will find essential.
2) Webcast: The Future of the DBA, November 1.
Join Evan Bauer as he discusses the value of a DBA to the IT organization in these days of new initiatives that lead to the reduction of operational and admistrative costs. Register for the webcast, listen to it, and perhaps you'll be one of the people who is awarded a free IBM Press book. You can register for the webcast from the DBA Central: http://www.ibm.com/developerworks/db2/zones/dba/.
3) Retail books:
High Availability Guide for DB2
by Chris Eaton and Enzo Cialini
Start-to-finish guide to delivering high availability with DB2 Universal Database for Linux, UNIX and Windows. Written two of IBM's leading DB2 high availability experts,
thoroughly reviews options related to both the database engine and the underlying platform, and addresses the entire lifecycle, from planning and architecture through day-to-day administration.
DB2 Universal Database V8 Handbook for Windows, UNIX, and Linux
by Phil Gunning
Written by a leading database consultant to help the DBA on the front line. The real-world examples make it easy to learn how to leverage the powerful features of DB2 UDB V8.
DB2 Universal Database V8.1 for Linux, UNIX, and Windows Database Administration Certification Guide, 5/e
by George Baklarz and Bill Wong
Straight from IBM, the ultimate guide for running DB2 V8 and preparing for the IBM DB2 UDB Database Administration Exam! This definitive reference and self-study guide covers every aspect of deploying and managing DB2 Universal Database V8, including best practices for DB2 database design and development; day-to-day administration and backup; and much more.
Whether you're a DBA, a developer, a DB2 certification candidate, or all three, DB2 Universal Database v8 for Linux, UNIX, and Windows Database Administration Certification Guide is the one book you can't afford to be without.
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX, and Windows, 1/e
by Dwaine Snow / Tom Phan
Whether you're a long-time DB2 UDB professional or an experienced DBA who's migrated from another database platform, there one sure way to demonstrate the highest level of skills in DB2 UDB database administration: pass the challenging IBM DB2 UDB Advanced Database Administration Exam.
This book is a guide to administering the advanced features of DB2 Universal Database Version 8. The book will discuss how to build a database in order to ensure optimal performance. It will discuss the manner in which to build table spaces and assign bufferpools based on the system usage and underlying disks system. The book will discuss the functionality built into DB2 to ensure system availability and will clustering and fail over discuss configuration options. The book will also discuss how to monitor a DB2 UDB system to determine if any bottle necks exist
All of these books can be found at the DB2 Bookstore: http://www.ibm.com/software/data/education/bookstore/ref.html
Happy Reading![Read More]
Have you had a chance to see any of these highly rated IBM Redbooks? Here are the most popular downloads, along with a reader comment about each book:
Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows"It's very useful to reference, most of all, the features between DB2 and Oracle."
DB2 9 pureXML Guide "This is a great book! Why don't you attach it to or recommend it when someone purchases DB2 Express-C."
Working with IBM Records Manager"Very informative! I never knew that there were so many record management standards and industry specific legal requirements."
svisser1 2700018UK9 3,192 Views
Here are some of the IBM classes that were recently updated for the DB2 9 for z/OS platform:
DB2 9 for z/OS Programming Using JavaCG140 or CG14GAcquire the skills you need to produce application programs in Java that manipulate DB2 for z/OS databases. Also, learn how to take advantage of advanced programming techniques to access DB2 for z/OS database servers in the workstation environment. Emphasize using the Java Database Connectivity (JDBC) to connect DB2 from a Java program and embedding static SQL statements using SQL for Java (SQLJ). Also, learn how to write Java stored procedures from a remote station using the Development Center tool.
DB2 9 for z/OS Stored ProceduresCG730 or CG73GLearn how to recognize when an IBM stored procedure is the correct solution for an application. Also learn how to: * Set up the environment to support stored procedures * Use the DB2 Development Center * CALL a stored procedure * Create a stored procedure using Data Definition Language (DDL) * Troubleshoot a stored procedure This course is taught using classroom lectures and machine lab exercises. Your workstation is on a Windows platform. The database server is a DB2 for z/OS system. You utilize the facilities of the DB2 Development Center, create COBOL stored procedures, and troubleshoot stored procedures using the DB2 Development Center.
DB2 9 for z/OS Implementation WorkshopCV860This course is for installers of DB2 UDB for z/OS V8 and/or migration to DB2 9 for z/OS using the Install CLIST. You will be involved in lectures to understand DB2 UDB for z/OS and DB2 9 Components and pointer and the processes involved to install and or migrate DB2. To reinforce the lectures a series of labs are provided to give you hands-on experience installing DB2 UDB V8 and migrating to DB2 9 for z/OS.
PS.. I reposted this entry with corrected links.[Read More]
svisser1 2700018UK9 3,191 Views
You have until Monday, June 30th to register for a certification voucher that entitles you to a 50% off the price of an exam fee... if you've purchased one of the cert guides. For details see: http://www.ibm.com/developerworks/blogs/page/SusanVisser?entry=follow_the_pig
Follow the pig!
The promotion has been hugely successful! If you were one of the many people who has already received a voucher, good luck on your exam! You'll be happy to know that the book you bought is proven to help people prepare for the exams... not only because of the content, but because of the sample questions and answers that are in the books.
Paul Zikopoulos just reminded me of a series of articles that he's written that I'm sure you'll find useful. The articles will help you figure out which edition of DB2 you need. Check it out:
Do you know how to license a DB2 Connect Unlimited Edition for iSeries server? Did you know there was such a product? How about which edition of DB2 supports an authorized user? Do you know you can buy DB2 ESE on a per user basis (it's the answer to the last question). Do you know how you license high availability? Did you know how to license DB2 installed on a dynamic processor pool with a capped or uncapped partition? Are you aware that DB2 Everyplace is free with any DB2 Connect or DB2 server? Do you know how an idle DB2 machine isn't really idle, but it's considered the same as IBM SWG's Cold and Warm machines, but licensed differently?
You may be able to answer all of those questions, but I guarantee you that your clients can't. All of my packaging, licensing, and edition information articles have been updated for September 2005 (circa the DB2 UDB V8.2.3 code level).
You can quickly access these articles at the following URLs.
Which Distributed DB2 Edition is Right for You?
This popular article is updated with the latest news in product features, editions, and licensing for IBM DB2 Universal Database Version 8.2.3. The author lays out the options and includes a quick reference that maps typical user environments to the suggested DB2 edition. This article is available at: http://www.ibm.com/developerworks/db2/library/techarticle/0211zikopoulos/0211zikopoulos.html.
Comparing the Distributed DB2 Server Editions
In a side-by-side comparison table, author Paul Zikopoulos makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed IBMDB2Universal Database(DB2 UDB) server family. This article is available at: http://www.ibm.com/developerworks/db2/library/techarticle/0301zikopoulos/0301zikopoulos1.html.
Which Edition of DB2 Connect is Right for You?
DB2 Connect is IBM middleware for connectivity from distributed systems to zSeries and iSeries-based DB2 systems. This article introduces DB2 Connect at a very high level and discusses the different editions and pricing models to help you decide which edition of DB2 Connect is right for you. This article has been updated to include packaging considerations up to and including DB2 Connect V8.2.3. It's available at:
Licensing Distributed DB2 Servers in a High Availability Environment
Are you trying to ensure you're licensing your IBMDB2Universal Databasefor Linux UNIX and Windows(DB2) servers correctly in a high availability environment? Don't have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? Author Paul Zikopoulos explains it all in plain English. It's available at: http://www.ibm.com/developerworks/db2/library/techarticle/0301zikopoulos/0301zikopoulos.html.
DB2 UDB using Dual Core or Sub-capacity Licensing
Learn about some of the latest hardware technologies, namely dual core processors and sub-capacity partitioning, and their respective considerations when licensing a supported IBMDB2Universal Database(DB2 UDB) server product. This article is available at: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0505zikopoulos/.
Stay tuned for information on the latest book that Paul co-wrote: Apache Derby -- Off to the Races : Includes Details of IBM Cloudscape
svisser1 2700018UK9 3,181 Views
Along the same lines as my last post, I'd like to give you a suggestion as to how you can prepare to pass for Exam 733. We do NOT have a book in the works to accompany the DB2 9 Application Development Exam 733. If you are getting ready to take the exam, here are a few ideas to help you prepare for the test despite the lack of a dedicated book.
Read the book by Roger Sanders: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide. This book prepares people to pass the V8 Application Development Exam 703. If you want this book... buy it right away. The series of V8 study guides published by IBM Press are considered out of print by the publisher, so the only copies of the book that you can get are the ones that are sitting in inventory. No reprints are possible.
Tip: You may be able to save 35% on the purchase of this and any other books at the IBM Press Bookstore. For a limited time, you can save 35% off your order when you make a purchase at the IBM Press Bookstore on or between October 15, 2007 and December 31, 2007. PLUS you can receive FREE ground shipping in the U.S. To take advantage of this special offer, simply visit the IBM Press Bookstore, select your books and enter case-sensitive coupon code SAVEDB2 at Step 3 during checkout. See IBM Information Management Books for links and details.
Read the IBM DB2 9 New Features book to learn the new functions for DB2 9. I'd pay particular attention to the XML sections.
Exam 733 also has a series of tutorials that were created to help you prepare to pass it: DB2 9 Application Development Certification Exam Preparation TutorialsThis series of nine tutorials has been developed to help you prepare for the DB2 for Linux, UNIX, and Windows Application Development Certification Exam (733). Each tutorial includes a link to a DB2 for Linux, UNIX, and Windows trial download at no charge to you! These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF.
For this exam, I recommend that you gauge your readiness by taking the assessment exam.
I've had quite a few people in the Toronto Lab successfully pass Exam 733 using this strategy.
svisser1 2700018UK9 3,177 Views
I know that it is very difficult for some people to arrange to go to a conference at their company's expense. Even IBMers who are trying to attend an IBM conference, it can be challenging. It seems that the rule is to now have 2 presentations or more accepted at the conference. Maybe this is a requirement for many other companies as well. If it's tough to get approval if you volunteer to be a speaker at the conference, you can imagine how difficult it is to get approval to attend the conference to be educated.
A friend of mine suggested that we look into providing a scholarship to one or more people that would entail a free registration to the conference. I like the idea and will promote this idea for future conferences where I can. As I was thinking of this, I came across this news item:
Got 10 minutes? Enter the DB2 9 Compression ChallengeThe DB2 9 Compression Challenge is less than a month away from closing and we need your entry. There is no purchase necessary and it takes only 10 minutes to enter. You don’t need to be running any version of DB2 to participate. First Prize - Full-event registration to one of IDUG's 2008 events. Second Prize – Upgrade Membership for the same eventsIDUG 2008 - Australia (March 2008 in Sydney, Australia) IDUG 2008- North America (May 5-10, 2008, in Dallas, Texas) IDUG 2008 - Europe (Dates/Location TBD)
So a "scholarship" to attend an IDUG conference in 2008 is possible! All you have to do is to enter this challenge. My friend is working at a shop that isn't running DB2... yet, so I like the caveat that You don’t need to be running any version of DB2 to participate.
I hope this gives an opportunity to one or two people who have not been able to go to conferences... and would like to. Conferences are a great way to keep up to date on a large variety of related topics. It helps you network with people who can help you in many different ways. And, perhaps most obvious of all, going to a conference gives you an opportunity to earn several certifications.... normally the tests are $150 US, regardless if you pass or fail, so taking exams is a very easy way to justify attending a conference.
But, if you are still unable to go a conference, don't despair. IBM provides many learning opportunities that you can take part in, either for free or inexpensively. I'll use books as an example... see our Bookstore Page for links to excellent books that can be used for self-study.... and we try to point to the lowest cost provider of the books. The other book example is of course the IBM Redbooks. For free you can download PDF versions of technical books that are excellent references as well as self-study resources. DeveloperWorks is another example where you can find a variety of helpful technical documents... free of charge. As for classroom education, our new ILO offerings are an excellent way to take award-winning education, right at your desk.
svisser1 2700018UK9 3,173 Views
Today's online issue of CIO Insight includes the article Fall Reading for IT Managers. I haven't read any of the books on the list, but the titles sound interesting. I'd like to make my own list of business titles in the IBM Press series that you should consider as well:
Can Two Rights Make a Wrong?: Insights from IBM's Tangible Culture Approachby Sara J. Moulton Reger
This book leverages the lessons learned during IBM’s $3.5 billion acquisition of PricewaterhouseCoopers Consulting: insight that IBM has crystallized into a powerful methodology for transforming business culture. The authors introduce “Business Practices,” an actionable surrogate for “culture” that business people can identify with, gauge, and act upon. Whether you’re involved with M&As, joint ventures, major transformation, internal restructuring, or any other initiative where culture is important, this book can help you take culture from a worrisome risk to a competitive advantage. Irresistible! Markets, Models, and Meta-Value in Consumer Electronicsby George Bailey, Hagen Wenzek
In this book, two world-renowned consultants preview the industry’s future–from online gaming to telehealthcare, and beyond. Next, they present a powerful new blueprint, offering indispensable guidance on everything from technology platforms to user interface design, branding to channel strategies. You’ll discover how to uncover new sources of value, design better models for doing business, and fuel growth by reaching new geographical markets.
Inescapable Data: Harnessing the Power of Convergenceby Chris Stakutis, John Webster
As communications, computing, and data storage converge, data is becoming utterly ubiquitous...and that changes everything. In this book, two leading data management visionaries reveal how data transforms the way you do business, the technologies you use, the investments you make, the life you live, and the world you live in. ...More Reaching The Goal: How Managers Improve a Services Business Using Goldratt’s Theory of Constraintsby Dr. John Arthur Ricketts
Managing services is extremely challenging, and traditional “industrial” management techniques are no longer adequate. In Reaching the Goal, Dr. John Arthur Ricketts presents a breakthrough management approach that embraces what makes services different: their diversity, complexity, and unique distribution methods. Ricketts draws on Eli Goldratt’s Theory of Constraints (TOC), one of this generation’s most successful management methodologies...thoroughly adapting it to the needs of today’s professional, scientific, and technical services businesses. He reveals how to identify the surprising constraints that limit your organization’s performance, execute more effectively within those constraints, and then loosen or even eliminate them. This book’s relentlessly practical techniques reflect several years of advanced IBM research and consulting with enterprise clients. Step-by-step, Ricketts shows how to apply them throughout your most crucial business functions...from project management to finance, process improvement to sales and marketing.
The New Language of Business SOA and Web 2.0by Sandy Carter
The New Language of Business: SOA and Web 2.0 is based on thousands of interviews with analysts and industry leaders at organizations of all sizes in over 50 countries, who shared their views, experiences and challenges of aligning technology with business goals. IBM SOA Strategist Sandy Carter examines the best practices methodologies behind hundreds of successful SOA implementations, from companies large and small.
Outside-in Software Development: A Practical Approach to Building Successful Stakeholder-based ProductsBuild Software That Delivers Maximum Business Value to Every Key Stakeholderby Carl Kessler, John Sweitzer
Imagine your ideal development project. It will deliver exactly what your clients need. It will achieve broad, rapid, enthusiastic adoption. And it will be designed and built by a productive, high-morale team of expert software professionals. Using this book's breakthrough "outside-in" approach to software development, your next project can be that ideal project.
In Outside-in Software Development, two of IBM's most respected software leaders, Carl Kessler and John Sweitzer, show you how to identify the stakeholders who'll determine your project's real value, shape every decision around their real needs, and deliver software that achieves broad, rapid, enthusiastic adoption.
The authors present an end-to-end framework and practical implementation techniques any development team can quickly benefit from, regardless of project type or scope. Using their proven approach, you can improve the effectiveness of every client conversation, define priorities with greater visibility and clarity, and make sure all your code delivers maximum business value.
Mining the Talk: Unlocking the Business Value in Unstructured Informationby Scott Spangler, Jeffrey Kreulen
In Mining the Talk, two leading-edge IBM researchers introduce a revolutionary new approach to unlocking the business value hidden in virtually any form of unstructured data–from word processing documents to websites, emails to instant messages.
Search Engine Marketing, Inc.Driving Search Traffic to Your Company's Web Siteby Mike Moran, Bill Hunt
Effective search engine optimization (SEO) and search engine marketing (SEM) is now crucial to the success of your business. But it™s never been more challenging—especially if you’re responsible for a large, complex site. Finally, there’s a definitive guide source of reliable information for implementing a successful program in your business or organization. In Search Engine Marketing, Inc., the ibm.com site architect and world-leading enterprise SEO consultant present best practices, step-by-step techniques and hard-won tips for driving maximum traffic at minimum cost. Do It Wrong Quickly: How the Web Changes the Old Marketing RulesStart Fast, Fix Fast, and Fix Again: Marketing for Breakthrough Resultsby Mike Moran
For decades, marketers have been taught to carefully plan ahead because “you must get it right–it’s too expensive to change.” But, in the age of the Web, you can know in hours whether your strategy’s working. Today, winners don’t get it right the first time: they start fast, change fast, and relentlessly optimize their way to success. They do it wrong quickly…then fix it, just as quickly!
In this book, Internet marketing pioneer Mike Moran shows you how to do that–step-by-step and in detail. Drawing on his experience building ibm.com into one of the world’s most successful sites, Moran shows how to quickly transition from “plan then execute” to a non-stop cycle of refinement.
If you look through these links to amazon.... you'll notice that the rated books all scored 4 1/2 stars or greater... out of a max of 5 stars..... and most of the amazon prices are discounted by 34%.