Tuesday, December 7, 2010

Treat yourself to DB2 this holiday

Nice post from my colleague Leons:

Happy Holidays! Raul.

Wednesday, December 1, 2010

Experience the next version of DB2 today!

Check out the DB2 Early Experience Program if you would like to experience the next version of DB2 to be released some time in the future.

You can "test drive" this new version without having to install or setup any software as we are running this from the Amazon Cloud. Send a note to db2beta at ca.ibm.com if you'd like to participate! Discount/vouchers may be available to cover any Amazon Cloud expenses.

Enjoy!, Raul

Moving a PHP app from MySQL to DB2

Moving a PHP application to DB2 from MySQL is the title of a series of articles in IBM developerWorks.
"This series describes why it makes sense to move a PHP application to DB2, how to prepare for the migration, how to execute it, how to support it, and how to handle potential risks based on the authors' experience with a recent migration. Many code and configuration samples are provided, as well as pointers to resources to help the project run smoothly".
The first part in the series was published two weeks ago.

Another added benefit, budget-wise, is that DB2 Express (Fixed Term License) is 2.5x cheaper than the equivalent MySQL version!. IBM reduced DB2 Express license cost to US$1,990 a few months ago. At around the same time, Oracle raised MySQL's price to about US$5,000.

Cheers, Raul

Monday, November 15, 2010

Leverage Cloud Computing to Accelerate Development and Test

Chat with the lab webinar:

Date: Thu, November 18, 2010 (11.18.2010)
Time: 11:30 AM - 1:00 PM Eastern Standard Time (EST)
10:30 AM Central / 8:30 AM Pacific / 16:30hrs London / 17:30hrs Frankfurt, Paris / India 10 PM
Speakers: Sal Vella (IBM), Uri Budnik (RightScale), Leon Katsnelson (IBM)

Are your application development and prototyping projects being put on hold due to budgetary constraints? Do you continually have to wait for new hardware and software to be procured and provisioned before your developers can start new projects? Are your current development and test systems sitting idle most of the time? Do you spend long cycles creating copies of your development or production environments for testing new changes and updates?

If you answered yes to any of these questions, join Sal, Uri and Leon to learn more about how you can leverage cloud computing to simplify development and testing for database projects. This webinar will feature live demos and will have about 20min dedicated for your questions.

This webcast is brought to you in collaboration between IBM and RightScale.


If clicking the above link does not work copy and paste the following URL to your web browser and follow the Registration link: ibm.com/db2/labchats

Sunday, November 7, 2010

DB2 course trial run results: 43 free certification vouchers given away

After 2 weeks running the "DB2 Essential Training I" e-course, I'm happy to announce the results here:

- 336 people enrolled
- 71 people were eligible to take the final exam (completed all assignments)
- 43 people passed the course and received free IBM Certification exam vouchers

We received excellent feedback about this course, and we will soon be announcing other courses to start in December. More details will be provided through the DB2 on Campus Facebook Group. Make sure you join this group!


Friday, October 15, 2010

Learn DB2 with a free online course and get a free DB2 Certification voucher!

Hi everyone!

After a successful trial-run last September, I'm happy to announce that we are having another "Learn DB2 with a free online course and get a free DB2 Certification voucher!" event.

This will be the same course we held in September with some different assignments and other few changes made based on the feedback received.

I will be giving away free IBM DB2 certification vouchers to the top 25% of the students who take the course to a maximum of 50 vouchers. The vouchers are valid to take any DB2 certification exam at any time before March 31st, 2011. They can be used anywhere in the world where there is a testing center such as Prometric. Typically taking a DB2 certification exam can cost between $30 to $120 dollars depending on the location, so this is a great offer!

I will be emailing the details about how to enroll to the course this Monday October 18th, 2010. Please make sure you join the DB2 on Campus Facebook group since I will be messaging all the members with the instructions.

I hope you can participate!

Cheers, Raul.

Monday, October 11, 2010

CC4D - Cloud computing for developers - FREE webinars

This Oct 12 and 13, 2010 attend free Cloud Computing Webinars organized by IBM developerWorks.

I will be presenting on Oct 13th. My session is #3 and is titled "Database design for multi-tenancy and resiliency" ( 2:30PM-3:30PM EST = Toronto time). I will be talking about Amazon's and DB2's offerings/features for Software as a Service (SaaS) vendors who use multi-tenancy to reduce costs. I will also discuss about DB2's HADR feature as part of the resiliency section, and provide a demo to set it up using Rightscale.

It's not late to participate!. Register to the Cloud Computing for developers (CC4D) event!

Hope to "see" you there,


Friday, October 8, 2010

CRN news on DB2 Express-C

Interesting article about DB2 Express-C:

Wednesday, October 6, 2010

New eBook: Getting started with DB2 Application Development

Hi All,

As part of the DB2 on Campus book series (ibm.com/db2/books) we have just published a new FREE ebook:

Getting started with DB2 Application Development



Tuesday, October 5, 2010

More features for DB2 Express

Today, IBM announced that DB2 Express (Fixed Term License or FTL) will also allow you to use Optim Development Studio and Optim Database Administrator free of charge. These tools increase development efficiency by 50% for Java data access, help pin-point query bottlenecks, automate data migration with object dependencies, and provide a full range of functionality for database administration and development. In addition the cost of the FTL subscription has been cut in half. Read more about the DB2 Express new features and new pricing!

Cheers, Raul.

Tuesday, September 21, 2010

Course over, vouchers distributed

Last Saturday, 25 students won vouchers to take any Information Management certification exam after enrolling in a free online course about DB2. The feedback received about the event was excellent, so it is very likely I will be repeating a similar event in the near in future (probably end of October 2010). I will be announcing new events like this on this blog, the DB2 on Campus Facebook group, and my twitter (raulchong)

Stay tuned!


Wednesday, August 25, 2010

Learn DB2 with a free online course and get a free DB2 Certification voucher!

This September I will be giving away 25 free IBM certification vouchers to take any DB2 certification exam at any time, anywhere in the world where there is a testing center such as Prometric.

If you already passed Exam 730, this could be an opportunity for you to take Exam 731 for free (for example), or you can choose any other exam.

In order to get the voucher, you will be asked to take a free online DB2 basic course titled "DB2 Essential Training I" that will be available to take at any time starting on September 13th, 2010.

If you have already passed Exam 730, the course may not be hard for you. It is based on the free e-book "Getting started with DB2 Express-C". It has 5 lessons which you can finish in one day or weekend. There will be one short assignment, one live review session with me for feedback (Web-based), and then a test.

If you are interested, please reply before Sep 1st, 2010 to db2univ at ca.ibm.com email with this information:

- Email
- Firstname
- Lastname
- Country

Use "Free certification voucher" as the title of your email for easy identification.

Once you send me this information, I will be providing you with a userID/password, and more instructions.

Cheers, Raul.

Tuesday, August 24, 2010

Job internship opportunities at the IBM Toronto Lab.

Early this year we started the search for students around the world to fill up two 16-month internship positions at the IBM Toronto Lab. We were looking for the best Web developers to help with cool and interesting projects that would use Web services, mobile technologies (iPhone, Android), and Cloud technologies; all in conjunction with DB2.

Today I'm happy to announce that after a long selection and recruitment process, Marius-Gabriel Butuc from Romania (left on the picture) and Henrique Copelli Zambon from Brazil (right on the picture), have been selected.

These are their stories in their own words:

Henrique Copelli Zambon
I'm a Computer Engineering student from the University of Sao Paulo. I learned about this opportunity from my colleague Phillip Viana, who now works as a Software Engineer at IBM Brazil. I'm very excited about this opportunity because of the chance to work with cool technologies involving mobile platforms (iPhone and Android), Web services and cloud computing using DB2. After several phone interviews, and completing an assignment, I was delighted to be chosen. I'm looking forward to the work ahead!

Marius-Gabriel Butuc
Hi, I'm Marius, a 2nd year MSc Software Engineering student at the "Alexandru Ioan Cuza" University of Iasi, Romania. As soon as I learned about this opportunity from my professor, Dr. Sabin-Corneliu Buraga, I was happy to embark in an application process that made me discover great people who have now become both my colleagues and inspiration. Discovering an unsuspected match between my interests and most of the buzzwords surrounding the project - like Django, RESTful Web Services, interface development for mobile devices, Ruby on Rails and DB2 - I soon decided to take this opportunity. After my longest flight to date, and with a smile on my face, I'm eager to fulfill this great learning opportunity, in the middle of this great team!

More information about internships
Through the DB2 on Campus program we recommend students we've met in person at DB2 on Campus events, or referred from a teacher or IBMer. Internships are only offered to students who are still in school. They must go back to continue their studies after the internship period is completed. Undergraduate, graduate (Master's, PhD) students are welcome to apply.

Internship applications at the Toronto Lab start in mid-December for positions that start in May. Though 16-month internship work periods are preferred, there are also 4, 8 and 12 month internships. Preference is given to Canadian students, but everyone is invited. Most positions are for development and testing, where C/C++/Java skills are a must. DB2 skills are a plus.

To apply, please contact your teacher or local IBMer who can get in touch with me. Please don't apply directly from this blog post.

Learn DB2 quickly from channeldb2.com/oncampus videos, and the free eBook "Getting started with DB2 Express-C".

Cheers, Raul.

Tuesday, July 27, 2010

Data Studio webinar replay

If you missed the Data Studio Webinar held on July 27th, the replay is available here:

Cheers, Raul.

Tuesday, July 20, 2010

Free Data Studio webinar - Receive book for attending!

This Tuesday, July 27th, I will be delivering a free webinar about the free IBM Data Studio software. Receive a hard copy of the book "Getting started with IBM Data Studio for DB2" just for attending!

The presentation will show you all the possibilities available for database administration and development using Data Studio.

Date: Tuesday, July 27th
Time: 11:30am - 1:00pm EST
Link: https://de202.centra.com:443/GA/main/0000017cff6600000128b56cd8a024e2
(replay available from the same link)

Hope to "see you" there!


Wednesday, June 2, 2010

DB2 Express-C 9.7.2 is now available for download!

DB2 Express-C 9.7.2 is now available for download!. It is a full refresh of the free edition of DB2 with lots of new features and fixes including:

- Default parameter values in user defined functions (UDFs)
- Named arguments when calling user defined functions
- Ability to copy table spaces and SQL schemas between active databases using RESTORE with TRANSPORT option
- Auditing improvements with full replay of past database activities
- Improved performance and ease of development for .NET applications

Download landing page:

Cheers, Raul.

Wednesday, February 17, 2010

Webcast: DB2 for LUW Security Primer

Date: 02/25/2010
Time: 11:30 - 13:00 EST / 10:30 AM Central / 8:30 AM Pacific / 16:30hrs London / 17:30hrs Frankfurt, Paris / India 10 PM
Presented By: Sal Vella (IBM), Walid Rjaibi (IBM)
Hosted By: Rav Ahuja (IBM)


This presentation will quickly refresh your understanding of the DB2 9.5 security capabilities and then bring you up to speed on the latest additions made in DB2 9.7 to help you better meet your regulatory compliance needs such as separation of duties and data-in-transit encryption.

You will learn how to:
1. vest security administration and database administration into two non overlapping roles;
2. prevent database administrators from accessing table data;
3. avoid granting users more privileges than what they need to perform their job tasks;
4. configure DB2 SSL to ensure the confidentiality and integrity of your data communications; and
5. make a successful transition to the DB2 9.7 authorization model.

Join experts from the IBM Toronto Lab: Sal Vella - Vice President of Development, and Walid Rjaibi - Chief Security Architect for DB2 LUW, for this one hour session on DB2 security followed by live questions and answers.

Presentation charts and recording for this Chat will be available for download from ibm.com/db2/labchats

Registering for this event

The following Web address points to the page where participants can register for this event: