Keep on Learning
I recently invested in good headphones... and I'm glad I did. I've already used them for an ILO course, listened to the many podcasts, watched the new IBM commercials on YouTube, watched the videos on ChannelDB2, and will likely find many more purposes.
IBM's list of ILO courses is growing steadily. My recommendation... Make sure that you fully test your headphones and mic BEFORE the session. You'll have a much more productive ILO session if you do.
Kate blogged about the many podcasts that are available right now, and today the IBM Press newsletter featured many more. Podcasts are available from the following people: Danny Arnold, Dwaine Snow, Sandy Carter, Larry Klosterboer, Sara J. Moulton Reger, Raul F. Chong, Paul Zikopoulos, John Arthur Ricketts, Mike Moran, Tara Woodman, Ellice Uffer, and Scott Spangler.
I've been trying to mention as many of the IBM commercials as I can... here is the latest... . this one is called "When it Rains".
IDUG also has a growing list of courses and podcasts that you may find helpful.
ChannelDB2 contains a broad spectrum of resources including videocasts, podcasts, and more. If you would like to contribute your unique view on the DB2 products, film or record yourself and add the result to ChannelDB2.
Are you looking for a unique gift this December? Consider giving someone you care about the means to improve their skills. You can never have too many skills when the economic climate is as rough as it currently is!
Here are my suggestions.... surprised?
Architects* Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more => Save 10% from amazon.com* Enterprise Master Data Management – An Architectural Perspective => Save 35% from IBM Press bookstore
DBAs* DB2 9 New Features => Save 31% at amazon.com* Understanding DB2 9 Security => Save 35% from IBM Press bookstore* DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep => Save 35% from IBM Press bookstore
Everyone* Understanding DB2 9.5 => save 37% at amazon!* Administering Informix Dynamic Server, Building the Foundation => save 10% at amazon* Beginning DB2: From Novice to Professional => save 36% at amazon!
Certification Candidates* DB2 9 Fundamentals Certification Study Guide => Save 20% at Digital Guru* DB2 9 for Linux, UNIX, and Windows DBA Guide, Reference, and Exam Prep => Save 35% from IBM Press bookstore* DB2 9 DB2 z/OS DBA Certification Study Guide => Save 20% at Digital Guru* DB2 9 Database Administration Certification Study Guide for Exam 731 => Save 20% at Digital Guru* DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 => Save 20% at Digital Guru* DB2 9 Advanced Database Administration Certification Study Guide for Exam 734 => Save 20% at Digital Guru
Business Intelligence specialists* Mining the Talk: Unlocking the Business Value in Unstructured Information => Save 35% from IBM Press bookstore* Cognos 8 Business Intelligence: The Official Guide => Save 37% at amazon.com* Managing Your Business Data: From Chaos to Confidence
Database Programmer* Building an Intelligent Web: Theory and Practice * DB2 for Developers => Save 20% at Digital Guru
Note that the savings mentioned are accurate today... and may change without notice.
If you are in India, check for these books at: shroffpublishers.com.If you are in Canada, check for the IBM Press books at: www.pearsontechnology.ca/DB2.If you are in Europe, check for the IBM Press books at: www.pearson-books.com/ibmpressbookshop.
I have a lot of books on my desk.... I mean a lot! On days that are slow, like today (everyone is on vacation but me!??) I read a chapter or two in one or more of these books. Recently I've been going through "The Myths of Innovation" by Scott Berkun and have been telling everyone I know how much I'm enjoying this book!
Scott briefly tells the stories of many key inventors / innovators through time stressing the points that none of these came as a-ha moments... but rather took lots of determination and yikes... failure! Most if not all key inventions were thought up by multiple people over time and the "winner" is a result of many coinciding factors: timing, funding, reproduction, and competition.
For all you creative thinkers out there, you'll see lists of negative responses that you've likely heard over your lifetime. Scott put together a list of "idea killers" and "idea helpers" on his blog that you might want to check out.
I hope you take a look at this book and if you do read it, I hope you enjoy it as much as I am....
One of the things I'm doing this summer is planning for the IOD conference... specifically arranging for books to be at the bookstore and authors to be available for book signings. I have a lot of work left to do, but here are some of the people I know who are ready to sign your books:
Carlton Doe for his soon to be published book: Administering Informix Dynamic Server: Building the Foundation
Roger Sanders for his entire cert prep series, but especially DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide.
Martin Oberhofer and possibly his co-authors of Enterprise Master Data Management: An SOA Approach to Managing Core Information.
Martin Short... just kidding! It would be great if we could arrange for him to sign something that he's produced, but don't count on it.
Stewart Friedman will be a speaker at the conference. Read this article that appeared in the NY times: Hot Ticket in B-School: Bringing Life Values to Corporate Ethics. The book that he wrote and will sign is Total Leadership: Be a Better Leader, Have a Richer Life.
I'll be at the conference and hope you will be too!
I'll post more secrets about the conference when I find them!
Thanks again to Kate Kurtz who is guest blogging for me this week as a first time attendee & presenter at IDUG.
Today was my last full day at IDUG. There are still some sessions tomorrow, but I have an early flight, so I won't be able to attend any of them. I really hope I can make it back to IDUG next year - it was an amazing experience and I had a wonderful time. I am already thinking of topics! :-)
First up today was Haider Rizvi's session on "IBM Smart Analytics System - A Technical Update". Haider invited me to cover a section in that presentation as well, and it was great to have another opportunity to present and participate in the customer discussions. I covered the overview section, and then Haider did a deep dive into the architecture and design of the IBM Smart Analytics System. The people in the room loved it, and there were a lot of questions about the system design and how to plan for system growth with multiple generations of an IBM Smart Analytics System.
Later on in the day I attended Albert Grankin's session, "DB2 LUW Operational Performance Troubleshooting - Finding CPU Bottlenecks". Albert's session was very detailed, giving a thorough overview of the tools you can use for performance analysis, as well as really good case study through which he illustrated how to use all the utilities he introduced in the first part of his session. There was also some solid common sense tips:
I also attended Chris Eaton's session, "Workload Optimized Systems: Don't Run a Marathon in High Heels". A great title and a great session! Chris' session was a competitive analysis of Oracle Exadata, the IBM pureScale Application System and the IBM Smart Analytics System. I asked Chris afterwards if he would be willing to give this session again, for our development teams, since I think it would be interesting for them, and also useful to understand the market in which our products compete. (He said yes :-) Chris is in the Speaker Hall of Fame for IDUG, and I paid a lot of attention to how he presented his sessions, as it was a great chance for me pick up some tips from an expert speaker.
One of the best parts of the day was the number of customers that stopped me to ask a question in the hall, at lunch or in the expo. I really enjoy getting to meet new people, and having a chance to talk about data warehouse, best practices, DB2, IBM Smart Analytics System ... Well, it was just a lot of fun. The ideas were all interesting, and there were a lot of people here who had passion for their work and that led to some great conversations.
After all of that, I finished the day participating in a Special Interest Group: IBM DW Trends - LUW, z/OS and Netezza. This session was an informal discussion group where customers could come in and ask anything they wanted about data warehousing. There was a panel of experts - Beth Hamel (z/OS), Namik Hrle (z/OS), Haider Rizvi (IBM Smart Analytics System/DB2 LUW), Michael C Lee (Netezza) - and then the not-so-expert me :-), all there to discuss whatever came up. There were a lot of questions about the Smart Analytics Optimizer for z/OS, as well as Netezza.
It really was a privilege to be able to attend IDUG and have the core concepts of pureScale, IBM Smart Analytics System, DB2 LUW and DB2 for z/OS explained by the people who developed the code and designed the systems.
Thanks Kate! I don’t have much to add today… just a couple of things:
Not only do IDUG attendees get FREE certification tests at the conference taking place May 10 - 14 in Tampa Florida, but in the weeks before the conference, you can take the assessment test FREE of CHARGE!
Check your email as once you register for the conference, you'll receive the promotion code and instructions by email.
Good luck on the exams! Have fun at the conference!
Check out my previous entries about the IDUG last week:
Expected to publish July 17, 2009, order now from amazon.com and save 37% ($18.50)
Authored by two of IBM's leading experts provide the single most comprehensive coverage of DB2's pureXML capabilities. This book explains DB2 pureXML in more than 700 practical examples, including 250+ XQuery and SQL/XML queries, taking the reader from simple introductions all the way to advanced scenarios. The authors have distilled their hands-on experience with many pureXML applications so that you can benefit from best practices, tips & tricks, performance guidelines, and other gems that are not documented elsewhere. This book is invaluable for database administrators and application developers, beginners and DB2 experts. The topics are organized by typical user tasks throughout the life cycle of XML database projects, from planning, designing, and implementing databases all the way to tuning, problem determination, and application development. It includes code samples for Java, .NET, COBOL, PL/1, C, PHP, and Perl programmers. The DB2 pureXML Cookbook provides proven recipes rather than a mere reference of ingredients.
About the Authors
Matthias Nicola is a Senior Software Engineer for DB2 pureXML at IBM's Silicon Valley Lab. His work focuses on all aspects of XML in DB2, including XQuery, SQL/XML, XML storage, indexing and performance. Matthias also works closely with customers and business partners, assisting them in the design, implementation, and optimization of XML solutions. Matthias has published over a dozen articles on various XML topics and is a frequent speaker at DB2 conferences. Prior to joining IBM, Matthias worked on data warehousing performance for Informix Software. He received his doctorate in computer science from the Technical University of Aachen, Germany.
Pav Kumar-Chatterjee has worked with DB2 since 1991 on DB2 for z/OS and since 2000 on DB2 for Linux, UNIX, and Windows. He is currently employed by IBM as a technical sales specialist for Information Management in the United Kingdom. He has helped customers implement the XML Extender product with DB2 V8 and has presented on DB2 and XML in the UK and around Europe.
To tie you over till the book is in your hands, here are some websites for you to check out:
Sadly I will not be attending IDUG in Denver next week. At first I was OK about this, but when I started going through the speaker list, it made me realize all the great people I'll be missing! I can't mention all the people who I'll miss... but let me tell you about the authors who will be there. Breakpoint books will be there as well providing a wide selection of books for you to browse and buy. Note that all attendees get a 10% discount on their book purchases.
For a laugh... you need to check this out: Kitchen Perfect.
I hope everyone has a great time while you are learning!
Here is another IBM commercial. This one is called "The Grail" and is about security. Have you seen this IBM Press book that published earlier this year? It's about security as well....
Mainframe Basics for Security Professionals: Getting Started with RACF
Leverage Your Security Expertise in IBM® System z™ Mainframe Environments
For over 40 years, the IBM mainframe has been the backbone of the world’s largest enterprises. If you’re coming to the IBM System z mainframe platform from UNIX®, Linux®, or Windows®, you need practical guidance on leveraging its unique security capabilities. Now, IBM experts have written the first authoritative book on mainframe security specifically designed to build on your experience in other environments.
Even if you’ve never logged onto a mainframe before, this book will teach you how to run today’s z/OS® operating system command line and ISPF toolset and use them to efficiently perform every significant security administration task. Don’t have a mainframe available for practice? The book contains step-by-step videos walking you through dozens of key techniques. Simply log in and register your book at www.ibmpressbooks.com/register to gain access to these videos.
The authors illuminate the mainframe’s security model and call special attention to z/OS security techniques that differ from UNIX, Linux, and Windows. They thoroughly introduce IBM’s powerful Resource Access Control Facility (RACF) security subsystem and demonstrate how mainframe security integrates into your enterprise-wide IT security infrastructure. If you’re an experienced system administrator or security professional, there’s no faster way to extend your expertise into “big iron” environments.
* Mainframe basics: logging on, allocating and editing data sets, running JCL jobs, using UNIX System Services, and accessing documentation* Creating, modifying, and deleting users and groups* Protecting data sets, UNIX file system files, databases, transactions, and other resources* Manipulating profiles and managing permissions* Configuring the mainframe to log security events, filter them appropriately, and create usable reports* Using auditing tools to capture static configuration data and dynamic events, identify weaknesses, and remedy them* Creating limited-authority administrators: how, when, and why
About the Authors:
Ori Pomerantz has been securing computer networks--and teaching other people to do so--since 1995. Since joining IBM in 2003, he has written classes on several Tivoli® security products, including IBM Tivoli zSecure.
Barbara Vander Weele, a software engineer at IBM, has developed and presented education material on provisioning, security, storage, and business technologies for IBM Worldwide Education.
Mark Nelson, Senior Software Engineer at IBM, is a twenty-year veteran of the RACF design team and a frequent speaker on RACF and z/OS security-related topics.
Tim Hahn, IBM Distinguished Engineer, has been with IBM for seventeen years. He is Chief Architect for Secure Systems and Networks within the IBM Software Group Tivoli organization.
Security doesn't exist in a vacuum; it’s a part of the business process and it permeates all aspects of information technology. The bad news is that as applications run on a combination of multiple platforms, each of the platforms needs to be examined, understood, and protected. The good news is that good security techniques transcend platforms; the key is understanding how to take the knowledge that you already know and apply it across these platforms.
That's the reason for this book. Experienced UNIX or Windows security professionals can extend their existing security knowledge to the world of z/OS![Read More]
Can you believe that it is already late in March! I've just returned from vacationing with my son for his March break from school... and am refreshed from the vacation... and pumped because SPRING is here!
There are several deadlines approaching quickly that you must take action on to avoid missing important opportunities.
If you were lucky enough to take a break... welcome back! I hope spring is inspiring you to change like it is for me.
The SOA Magazine
Someone just sent me the latest edition of this magazine, and I noticed that it includes articles from two authors who I know:
Thomas Erl is the editor of the magazine and he has an article in this edition. He's a published author who I've spoken with several times. If you know what SOA is... then you likely know of the books by Thomas!
Tinny Ng also has an article featured in the current edition: Identity Services for SOA.
Tinny was the lead author in the following book that published earlier this year:
Understanding IBM SOA Foundation Suite: Learning Visually with Examples
By: Tinny Ng; Laura Chan; Jane Fung; Vivian Mak
Last Updated on Safari: 2009/05/27
Publisher: IBM Press
Pub Date: August 18, 2009
This book and CD package brings together 26 quick tutorials designed to help implementers and developers get up-to-speed fast with IBM SOA Foundation products - and use them to deliver real solutions.
Note: DB2 is NOT one of the products covered in this book... so use this book to come up to speed with all the other SOA products that may work with DB2.
The authors help technical professionals quickly get up the learning curve, by showing exactly how each product works, how they fit together, and how to use them together. Each self-contained chapter offers a "big picture" product overview, as well as hands-on techniques. The companion CD doesn't just provide corresponding code: it also includes a full video version of each tutorial.
Thanks to both Thomas and Tinny for continuing to educate the world on the benefits of SOA!
Mashup thought leaders Mike Ogrinz, author of the book Mashup Patterns,and John Gerken, a Senior Architect for the IBM jStart Emerging Technologies team, will discuss:
Thursday April 30, 2009
11:00 AM Eastern, 10:00 AM Central, 9:00 AM Mountain, 8:00 AM Pacific
Conference telephone numbers: United States: 800 369-3162
Verbal Confirmation Code: Greenhouse
Click here for information on International numbers.
About the book:
Mashup Patterns by Mike Ogrinz
Indispensable Patterns and Insights for Putting Mashups to Work in Enterprise Environments
Using new mashup tools and technologies, enterprise developers can impose their own APIs on everything from Web sites and RSS feeds to Excel and PDF files–transforming a world of content into their own customized informationsource. In Mashup Patterns, Michael Ogrinz applies the concept of software development patterns to mashups, systematically revealing the right ways to build enterprise mashups and providing useful insights to help organizations avoid the mistakes that cause mashups to fail.
Drawing on extensive experience building business-critical mashups, Ogrinz offers patterns and realistic guidance for every stage of the mashup development lifecycle and addresses the key issues developers, architects, and managers will face. Each pattern is documented with a practical description, specific use cases, and crucial insights into the stability of mashups built with it. Ogrinz concludes by presenting twelve start-to-finish case studies demonstrating mashup patterns at work in actual enterprise settings.
Also of interest: The companion book, Mashups: Strategies for the Modern Enterprise by J. Jeffrey Hanson (Addison-Wesley), is an indispensable guide to designing, implementing, and debugging an enterprise mashup, offering sample code to illustrate key concepts.About the Author
Michael Ogrinz is a principal architect at one of the world’s largest financial institutions. His business focus is to identify and integrate emerging technologies into the enterprise and to create innovative and competitive solutions. A frequent industry speaker on various facets of Enterprise 2.0, Michael has been instrumental in enhancing the computing environment at his firm through his work on user interfaces and usability, wikis and blogs, and, most recently, mashups.
Michael cofounded localendar.com, a classic “garage start-up” that demonstrates how the “Long Tail” applies to online calendars as much as anything else. The niche site has provided more than 400,000 schools, churches, and clubs with simple online scheduling services since its inception more than eight years ago.
Michael lives with his wife, two daughters, a collection of classic pinball and vector arcade machines, and a partially completed B9 Robot in wonderfully rural Easton, Connecticut.
Canada Day is tomorrow and it seems that everyone is already on vacation! The office is incredibly quiet and I'm not getting much mail.
This weekend is Independance Day in the US... and I'm looking forward to being in NYC for this celebration.
All the teachers and kids are finished school and many families are on vacation.
I hope you have a wonderfully fun summer... stay safe!
A new ILO course has just been added. This one is an SQL workshop that is spread over 4 half-days in two weeks. ILO courses are the IBM courses that you take without traveling by joining a remote instructor via your computer.
Here are some details:
SQL Workshop - Multi Week Instructor Led Online
On completion of this course, you should be able to:
* Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses* Code inner joins and non-correlated subqueries* Use SQL arithmetic operations* Use scalar and column functions* Use UNION and UNION ALL* INSERT, UPDATE and DELETE rows* Code simple CREATE TABLE and CREATE VIEW statements
The DB2 books that you may wish to have to complement this course are:
* Understanding DB2(R): Learning Visually with Examples (2nd Edition)* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
If you are interested in passing the DB2 9 Family Fundamentals certification exam (Test 730), you should notice that about 23% of the exam covers SQL knowledge. The book DB2 9 Fundamentals Certification Study Guide by Roger Sanders corresponds to the exam objectives and therefore covers the SQL that you need to pass the exam.
An interesting way to get a start on learning SQL is through the DB2 Games. Here are some details that I found on Kate Dawson's blog:
If you are a beginner, choose the IBM DB2 Detective GameIf you like watching crime investigation shows, this might just be the perfect game for you. Using a crime investigation theme, you will enforce your DB2 9 and SQL skills while learning relational database concepts and how they can be applied to real-life problems. I’ve played this game and highly recommend it.
If you have some existing DB2 skills, choose the IBM DB2 Business GameTry a “run your own business” scenario and put your DB2 and SQL skills to the test with the Business Game. Your company’s future depends on a key report needed to secure funds for a critical upgrade… can you put your DB2 skills into action and beat the game? Play now and find out.
Whenever I ask people who are SQL experts, they tell me that they rely heavily on these books:
* Graeme Birchall's DB2 SQL Cookbook* The SQL Reference for Cross-Platform Development* Product Docs for DB2 LUW* Product Docs for DB2 z/OS
When at conferences, I've noticed that the following books are popular:* Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition* SQL Demystified* SQL: The Complete Reference, Second Edition* SQL In A Nutshell, 2nd Edition* SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition)* SQL Pocket Guide
In writing this blog I realize how many resources are available for SQL. Clearly that means that it is a very important topic.... and one that you can continue to improve in.
Have you seen this yet?
Watch DB2 on YouTube
Rav Ahuja has been posting video interviews with DB2 Viper 2 architects on YouTube. This is part of his Voice of the DB2 Community podcast series.
You can find all the videos on YouTube’s Channel DB2. The videos are also available at the Channel DB2 social network.
Thanks to John P. Kennedy for this information!!