After four months of beta availability and testing, SugarCRM today officially announced the general availability of its Sugar 6 CRM customer relationship management platform. Sugar 6 includes an open source community edition as well as commercially licensed professional and enterprise editions.

With Sugar 6, SugarCRM is expanding its partnership base with enhanced extensibility that enables partner solutions. There is a new user interface that aims to make CRM users more productive with fewer keystrokes. While the Sugar 6 solution has open source technology at its core, users that download the open source community edition will get a different interface than users of the commercial professional and enterprise editions. For SugarCRM, the issue of being an open source company is all about being open to users.

"As an open source project, we've given people a lot, and Community edition has helped us to get where we are today," Martin Schneider, senior director of communications at SugarCRM, told InternetNews.com.

Schneider added that in his experience, he would go to conferences and users of SugarCRM's professional solution were not aware of the community edition and vice versa. As such, the new version takes pains to show the Sugar user base that there is a difference between the freely available community edition and the paid versions of Sugar.

With Sugar 6, professional and enterprise customers get a new global search option for CRM records as well as the ability to more rapidly create contact records. When Sugar 6 was first announced as a beta in April, SugarCRM co-founder Clint Oram told InternetNews.com that the goal was to reduce the number of click users needed to accomplish tasks.

Schneider explained that with Sugar 6, the company is delivering a 'Go Pro' message to community users. The new user interface for the professional and enterprise versions is the front-end for other commercial enhancements, including better security, mobile and reporting features in the paid versions. He emphasized that overall, Sugar 6 is an open source product from an open source company.

Open source doesn't mean free

"Open source doesn't mean free and was never really meant to mean free," Schneider said. "Open source runs through everything we do, it enables us to be transparent and gives customers more power. We are an open source company and it's why we're better than proprietary companies."

Though the community edition is not getting the same new user interface as the commercial versions, all three versions of Sugar 6 will benefit from an improved Sugar module builder. The module builder has been improved for all users of Sugar 6 to provide users with more integrated data views into the system. For example, a user can choose to integrate a contact's Twitter feed into a CRM record or an adjacent record tab. Schneider explained that any website can be exposed inside of a contact record to provide additional visibility.

From an extensibility perspective, Sugar 6 supports both SOAP and REST Web services, providing data integration points for partners. Sugar 6 is also being enabled to run on Microsoft's Azure cloud operating system.

Schneider said that to date, 70 percent of SugarCRM's customers run Sugar in either a cloud or hosted environment, while only 30 percent run Sugar onsite. SugarCRM offers its own on-demand hosted offering, though Schneider stressed that hosting isn't SugarCRM's core business.

"We want to empower other people to have cloud deployments and help customers get up and running," Schneider said. "We don't want to be in the hosting business, we want to be everywhere and run everywhere.

Comment (0)

SugarCRM, the open source CRM company founded in 2004, has announced the release of their latest version, Sugar 6. With this release, SugarCRM is trying to focus on making it easier and flexible for users to use CRM systems. In fact, many users are completely lost when it comes to using CRM. The complexity and lack of good user experience are considered to be the main reasons for this. This release focusses on substantially improving the user experience by offering a clean, bold look with new buttons and icons that allow users to perform tasks more easily while increasing the information density of each screen. In short, the idea is to make the CRM be flexible and convenient to users needs than users spending time to understand the UI and the complexities associated with it. They have achieved this by focusing on the user friendliness of their menu bars.

This new release also brings more social aspects to SugarCRM. Now Sugar users can leverage information from social networks like Twitter, LinkedIn and other data sources from inside the CRM. This makes SugarCRM more social than before, positioning themselves to compete with other sCRM offerings. This release also has support for more cloud providers making it easy to deploy SugarCRM on the cloud.

 SugarCRM also announced partnerships with two cloud service providers, a topic that may be of some interest to Cloud Ave audience. At the Microsoft Worldwide Partners Conference at Washington DC, SugarCRM announced that Sugar 6 is now certified for deployment on Microsoft’s Windows Azure platform. What it essentially means is that one can install SugarCRM on Windows Azure and it will work as promised without any issues. This increases the number of cloud partners for SugarCRM. Interestingly, SugarCRM has embraced the cloud era with a different approach from companies like Salesforce.com, Zoho CRM (disclaimer: Zoho is the exclusive sponsor of this blog but it is my independent opinion), etc.. While the latter companies take a multi-tenant SaaS approach, SugarCRM is trying to push for cloud apps instead. They certify SugarCRM with different cloud vendors and when it is installed on these clouds, it will work flawlessly. I asked Martin Schneider, Senior Director, Communications at SugarCRM, if SugarCRM will scale out in the Azure environment like the underlying cloud platform, he said it will scale seamlessly without any efforts on the user's side. He also pointed out that the users of SugarCRM on Azure can use either MySQL or SQL Azure.

Comment (0)

Highlights

- Tutorial: Getting Started with MySQL Workbench
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: Guide to MySQL for Microsoft Windows
- Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup
- Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials (Thursday, July 22)

New Product Releases

- New Release of MySQL Workbench 5.2.25 (GA)
- New Release of MySQL Community Server 5.1.48 (GA)
- New Release of MySQL Connector/J 5.1.13 (GA)

Hints & Tips

- Documentation: InnoDB INFORMATION_SCHEMA Tables
- Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010
  - PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster
  - PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes
  - PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
  - PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions
  - PlanetMySQL Blog: Running MySQL Cluster as a service on Windows
  - PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits
  - PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening
  - PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance
  - PlanetMySQL Blog: How many IOPs can InnoDB do?
  - PlanetMySQL Blog: Lock wait timeout on slaves

Spotlight: MySQL Embedded Server in Network Management

- On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine
- Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL
- Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

Events

- Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine (Wednesday, July 14)
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals (Thursday, July 15)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA
- Live Webinar: What's New in MySQL - Japanese (Thursday, July 22)
- On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL
- On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

-------------------------------------------------------------------

Highlights

Tutorial: Getting Started with MySQL Workbench

This tutorial provides a quick hands-on introduction to using MySQL Workbench for beginners. In order to complete this tutorial you will need to have a locally installed MySQL Server. This tutorial requires MySQL Workbench version 5.2.16 or above.

View the Tutorial:
  http://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial.html


White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


White Paper: Guide to MySQL for Microsoft Windows

As we will discover over the course of this paper, MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, hosting providers and organizations developing custom web, departmental and enterprise applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_onwindows.php


Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup

The Pyro Group has selected the MySQL Cluster database to power their InRoam SDP (Service Delivery Platform). InRoam enables Cell C and their network partners to provide low cost, border-less mobile communications services to hundreds of thousands of football fans from around the world as they descend on South Africa for the 2010 FIFA World Cup tournament.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-pyro_telecoms.php


Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials Thursday, July 22, 2010 - 9am PT

Join us for Part 2 of the "MySQL Essentials" webinar series with Mike Frank from the MySQL Product Management group at Oracle. In this presentation, we'll demonstrate the fundamentals of SQL scripting with MySQL. We will cover SELECTs, JOINs, CREATE, DELETE, INSERTs and a host of other DML and DDL operations. Also covered will be essential management commands for administering and monitoring MySQL. We will be demonstrating how to accomplish these tasks both at the command line and in an automated fashion using MySQL's built-in scheduler, MySQL Workbench and MySQL Enterprise Monitor.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-553.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Workbench 5.2.25 (GA)

We're pleased to announce the release of MySQL Workbench 5.2.25. This release is GA (Generally Available). We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications. MySQL Workbench 5.2 GA provides:

- Database Design & Modeling
- SQL Development (replacing MySQL Query Browser)
- Database Administration (replacing MySQL Administrator)

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-25.html

Download now:
  http://dev.mysql.com/downloads/workbench/

Read the Documentation:
  http://dev.mysql.com/doc/workbench/en/index.html


New Release of MySQL Community Server 5.1.48 (GA)

MySQL Community Server 5.1.48, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.48 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-48.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Connector/J 5.1.13 (GA)

MySQL Connector/J 5.1.13, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.13 is suitable for use with any MySQL version including MySQL-5.0, MySQL-5.1 or MySQL-5.5.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-13.html

Download Now:
  http://dev.mysql.com/downloads/connector/j/5.1.html

-------------------------------------------------------------------

Hints & Tips

Documentation: InnoDB INFORMATION_SCHEMA Tables

There are seven INFORMATION_SCHEMA tables that contain live information about compressed InnoDB tables, the compressed InnoDB buffer pool, all transactions currently executing inside InnoDB, the locks that transactions hold and those that are blocking transactions waiting for access to a resource.

Read the Documentation:
  http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-information-schema-overview.html


Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry

Sahlgrenska University Hospital (SU) is one of the major hospitals in Europe and was founded in 1997 when three hospitals in Sweden merged. Every year, Sahlgrenska University Hospital records two million referrals and comments through the Central Registry system which is powered by MySQL.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-enterprise-sahlgrenska_hospital.php


PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL:
  http://planet.mysql.com/

Submit Your Blog Feed:
  http://planet.mysql.com/new


PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010 Giuseppe Maxia

Oracle OpenWorld is the conference of everything related to Oracle. This year's edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.

Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle OpenWorld show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.

Read the PlanetMySQL BlogPost:
  http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle


PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster Andrew Morgan

The new version of MySQL Workbench (5.2.25) has just gone GA - see the Workbench Blog for details. So what's the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes.

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql/mysql-workbench-5-2-goes-ga-partial-support-for-mysql-cluster/


PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes Andrew Morgan

A series of quick-start guides are now available to get you up and running with MySQL Cluster in as little time as possible; they are available for LINUX/Mac OS X, Windows and Solaris. The configuration is intentionally a simple 1 - 2 data nodes, 1 management node and 1 MySQL Server. Once you have this up and running, your next experiment may be to extend this over multiple hosts.

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql/download-install-configure-run-and-test-mysql-cluster-in-under-15-minutes/


PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
Ulf Wendel

The mysqlnd plugin API is a well hidden gem of mysqlnd. Mysqlnd plugins operate on a layer between PHP applications and the MySQL server. This is comparable to MySQL Proxy. MySQL Proxy operates on a layer between any MySQL client application, for example, a PHP application, and the MySQL server.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=284


PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions Ulf Wendel

The first public mysqlnd plugin adds client side query result caching to all MySQL extensions of PHP. The cache is written in C. It does not change any of the PHP MySQL APIs and works with any PHP application using MySQL. Query results are stored on the client.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=286


PlanetMySQL Blog: Running MySQL Cluster as a service on Windows Anders Karlsson

The MySQL Cluster daemon for MySQL Cluster (ndbd and ndb_mgmd) doesn't by themselves yet let them run as a service. But there are ways to fix this, using some simple Windows tools and some registry hacking.

Read the PlanetMySQL BlogPost:
  http://karlssonondatabases.blogspot.com/2010/06/running-mysql-cluster-as-service-on.html


PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits Chris Calender

There are many advantages to using the plugin as opposed to the built-in version (aside from just the new I_S tables, and more importantly, numerous performance enhancements), and it's breeze to set up, so I wanted to provide a quick start guide to using the new InnoDB plugin.

Read the PlanetMySQL BlogPost:
  http://www.chriscalender.com/?p=99


PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening Bob Zurek

Over a month ago, Infobright was invited to join the Oracle MySQL Storage Engine Advisory Board and last week was the first in a series of meetings that Oracle will be hosting for the Advisor Board members. Oracle did a terrific job stepping up to the task of assembling a well known group of companies as part of the board. The meeting last week was clearly a sign of commitment by Oracle to work closely with the storage engine vendors in the market. This resonated very well with the advisory board members.

Read the PlanetMySQL BlogPost:
  http://www.infobright.org/Blog/Entry/oracle_mysql_storage_engine_advisory_board_-_its_happening/


PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance Venu Anuganti

Even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and writes.

Read the PlanetMySQL BlogPost:
  http://venublog.com/2010/06/23/how-read_buffer_size-impacts-write-buffering-and-write-performance/


PlanetMySQL Blog: How many IOPs can InnoDB do?
Mark Callaghan

I previously tested InnoDB on an 8-core server to determine how many IOPs it can do for a simple IO-bound workload. The limits were ~12k disk reads/second for MySQL 5.0 and ~18k reads/second for MySQL 5.1. I just repeated the tests using a 16-core server and the results are much better. I can get 20,000 to 30,000 disk reads/second using InnoDB 5.1.

Read the PlanetMySQL BlogPost:
  http://www.facebook.com/note.php?note_id=403975340932


PlanetMySQL Blog: Lock wait timeout on slaves Alex Lurthu

We had one of our slave servers frequently stops replicating with the "Innodb Lock Wait Timeout" error. The slave IO thread would continue to fetch the binlogs while the slave SQL thread kept stopping with the above mentioned error.

Read the PlanetMySQL BlogPost:
  http://alexlurthu.wordpress.com/2010/06/07/lock-wait-timeout-on-slaves/

-------------------------------------------------------------------

Spotlight: MySQL Embedded Server in Network Management

Many new technologies and applications are creating a significant increase in network traffic volume and complexity, making it more difficult to maintain a high performance network that doesn't disrupt application availability. MySQL enables ISVs and OEMs to overcome these limitations and build modern network management products by providing high performance, cost-effectiveness, ease of installation, zero administration, and much more.


On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine

MySQL offers a variety of storage engines that can be matched to application requirements. Data can be integrated seamlessly between storage engines. When none of the existing engines look like a perfect match to your requirements, you can add your own. MySQL provides a SQL stack for your data. By leveraging the integration between storage engines, you are free to concentrate on just the design of key tables.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-424.html


Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL

NetQoS delivers products and services that enable some of the world's most demanding enterprises, including American Express, Boeing, and Chevron, to improve network performance. NetQoS ReporterAnalyzer relies on MySQL and tells IT organizations which applications and users are consuming bandwidth, and when, so they can optimize the wide area network and improve IT service delivery.

NetQoS found that MySQL provided the ideal combination of performance, reliability, and ease of administration for ReporterAnalyzer. In addition, MySQL's affordable licensing model enabled NetQoS to reduce its database costs by several thousand dollars per network appliance.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_netqos.php


Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server

CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL Embedded Server, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php


Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

To give the entire IT organization better visibility and control over the performance and availability of their networks, systems and applications, ScienceLogic relies on the performance and scalability of MySQL to process real-time information from thousands of networked devices.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php

-------------------------------------------------------------------

Events

Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine Wednesday, July 14, 2010 - 9am PT

The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management. The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address these evolving web service demands.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-551.html?p=newsletter


Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals Thursday, July 15, 2010 - 9am PT

In Part I of a three-part performance series, MySQL performance expert Brian Miezejewski will take you through the fundamentals of architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.

In this session, Brian will go through the first steps to take when designing your database for high performances. He will also show you how to spot and quickly resolve the most common performance bottlenecks.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-552.html?p=newsletter


Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA

Join this technical webinar for an overview of MySQL's internal architecture including storage engines, security and datatypes. Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access.

Register for the German Webinar on July 16:
  http://dev.mysql.com/news-and-events/web-seminars/display-554.html

Register for the Italian Webinar on July 22:
  http://dev.mysql.com/news-and-events/web-seminars/display-555.html


Live Webinar: What's New in MySQL - Japanese Thursday, July 22, 2010 - 2pm JST

As a result of the acquisition of Sun Microsystems and Oracle, MySQL is now part of Oracle's product portfolio. Oracle invests in MySQL, the world's most popular open source database, and further drives its innovation.

The latest release of MySQL Enterprise includes many new features and improvements, which are designed to save DBAs and Developers time and effort in keeping MySQL systems running at the highest levels of security, performance and availability. In this webinar, we will share the latest updates from MySQL, including exciting new product development.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-556.html


On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL

In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-538.html?p=newsletter


On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. There are classes of web services, however, that are update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-545.html?p=newsletter

Read the White Paper "Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached":
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php


More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars:
  http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
  http://twitter.com/mysql

Follow MySQL Community on Twitter:
  http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@gmail.com

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Comment (0)

Articles in this newsletter:

Highlights

- Oracle Outlines Strategy for MySQL
- MySQL track at Oracle Development Tools User Group Conference
- White Paper: How MySQL Powers Web 2.0
- White Paper: MySQL 5.1 for ISV/OEM Solutions
- Evaluation Guide: Evaluating MySQL Cluster 7.1
- Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of 1.5 Million Patients
- Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise
- Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL (Tuesday, May 18)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA (Thursday, May 20)
- Live Webinar: MySQL Essentials Series - Part 1:  Building, Installing and Configuring MySQL (Thursday, May 27)
- Upcoming MySQL University Sessions

New Product Releases

- New Release of MySQL Community Server 5.1.46 (GA)
- New Release of MySQL Workbench 5.2.21 (RC)
- New Release of MySQL Connector/Net 6.1.4 (GA)

Hints & Tips

- White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL
- White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- Tutorial: Developing Database Applications Using MySQL Connector/C++
- Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer
- Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL 5.5.4 is Very Exciting
  - PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions
  - PlanetMySQL Blog: MySQL: The maximum value of an integer
  - PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome
  - PlanetMySQL Blog: Trying out MySQL Push-Down-Join (SPJ) preview
  - PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python
  - PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group
  - PlanetMySQL Blog: Reducing locks by narrowing primary key
  - PlanetMySQL Blog: MySQL Performance: Improving Stability
  - PlanetMySQL Blog: MySQL Random Data Selection
  - PlanetMySQL Blog: A backup today saves you tomorrow
  - PlanetMySQL Blog: Choosing the right data type makes a big difference

Events

- Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features (Tuesday, May 25)
- Live Webinar: Getting started with MySQL Replication - Italian (Tuesday, May 25)
- Live Webinar: MySQL Performance Tuning Best Practices - French (Wednesday, May 26)
- Live Webinar: MySQL Replication - Part 2 - German (Thursday, May 27)
- On-Demand Webinar: Introducing MySQL Cluster 7.1
- On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

-------------------------------------------------------------------

Highlights

Oracle Outlines Strategy for MySQL

Edward Screven, Oracle's Chief Corporate Architect, discussed the current and future state of MySQL in his keynote at the MySQL Conference & Expo.

Watch the Video:
 
http://www.youtube.com/watch?v=C0OkjtlbqVs&feature=PlayList&p=57E661D0569B26
EE&playnext_from=PL&index=0


MySQL track at Oracle Development Tools User Group Conference

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. By popular demand, there will be a MySQL track organized by the MySQL community. The event includes free sessions. Join us and meet with the MySQL experts!

Learn more:
  http://blogs.sun.com/MySQL/entry/mysql_track_with_free_event


White Paper: How MySQL Powers Web 2.0

MySQL enables up-and-coming Web 2.0 sites like Wikipedia, Facebook and Twitter, as well as established web properties like Craigslist, Google and Yahoo!, to scale out and meet the ever-increasing volume of users, transactions and data.

You will gain an understanding of how MySQL can be used in conjunction with other open source components to deliver low-cost, reliable, scalable, high performance Web 2.0 applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_web20.php


White Paper: MySQL 5.1 for ISV/OEM Solutions

The MySQL 5.1 server continues to move MySQL ahead in its mission to make sophisticated database management available and affordable to all. With the release of MySQL 5.1, the MySQL database server provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for:

- Managing larger volumes of data
- Applications that have high-availability requirements
- Systems needing a powerful but autonomous-running database

that requires little attention and continually services anywhere from one to thousands of user requests per second.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_51_OEM.php


Evaluation Guide: Evaluating MySQL Cluster 7.1

In this white paper learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We explore hardware, networking and software requirements, and work through basic functional testing and evaluation best practices.

Read the Evaluation Guide:
  http://dev.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php


Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of
1.5 Million Patients

Uppsala Clinical Research Center, UCR, is a national center of competence for healthcare quality registries in Sweden, and is an independent unit under Uppsala University Hospital and the Disciplinary Domain of Medicine and Pharmacy at the University of Uppsala. UCR's National Quality Registries include treatment and outcome data based on all hospital patients in Sweden, and is used by thousands of doctors, nurses, medical secretaries and representatives within county councils.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_ucr.php


Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise

ContactLab is a leading Italian provider of digital direct marketing services, with offices in Milan, Madrid, Paris, London and Munich.
ContactLab chose to subscribe to MySQL Enterprise to help support the security, availability and scalability of its market-leading platform. Today ContactLab manages more than 3 Terabytes of data with MySQL for sending, tracking and analyzing hundreds of millions of messages every month.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_contactlab.php


Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL Tuesday, May 18, 2010 - 9:00am PT

Among the top 500 most visited sites on the Internet, myLifetime.com, which is built on Drupal, receives 6.5 million visitors (3.6 million unique) and 50 million page views per month. Because of online campaigns, and the popularity of associated television shows, the Lifetime family of sites must be prepared to accommodate significant volume spikes.

Nathan Potter, VP of Digital Media Technology at myLifetime.com, cites show-related volume spikes of 150,000 page views per hour as within the normal range of traffic. In this webinar, Nathan will cover the architecture they've developed for scalability as well as the techniques they've used for optimizing their site, including MySQL, for scalability and performance.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-535.html


Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA Thursday, May 20, 2010 - 9:00am PT

Join Jimmy Guerrero and Mike Frank of Oracle for an overview of MySQL's internal architecture including storage engines, security and datatypes.
Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access. If you are a SQL Server DBA interested in learning how to leverage your current knowledge against MySQL, this webinar is for you.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-536.html


Live Webinar: MySQL Essentials Series - Part 1:  Building, Installing and Configuring MySQL Thursday, May 27, 2010 - 9:00am PT

Join us for Part 1 of the "MySQL Essentials" webinar series with Jimmy Guerrero and Mike Frank from the MySQL Product Management group at Oracle.
In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-538.html


Upcoming MySQL University Sessions

MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Oracle employees.
Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.

View Upcoming and Previous Sessions:
  http://forge.mysql.com/wiki/MySQL_University

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.46 (GA)

MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-46.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Workbench 5.2.21 (RC)

We're announcing the first Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:

1. Data Modeling
2. Query (upgrade from MySQL Query Browser) 3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench.

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-21.html

Download now:
  http://dev.mysql.com/downloads/workbench/5.2.html


New Release of MySQL Connector/Net 6.1.4 (GA)

MySQL Connector/Net 6.1.4, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against MySQL servers ranging from version 4.1 to 5.5!

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/connector-net-news-6-1-4.html

Download Now:
  http://dev.mysql.com/downloads/connector/net/6.1.html#downloads

-------------------------------------------------------------------

Hints & Tips

White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL

Memached is an open-source, distributed memory caching system designed to tackle today's web-scale performance and scalability challenges. Many of the largest and most heavily trafficked web properties on the Internet like Facebook, Fotolog, YouTube, Mixi.jp, Yahoo, and Wikipedia deploy Memcached and MySQL to satisfy the demands of millions of users and billions of page views every month. By integrating a caching tier into their web-scale architectures, these organizations have improved their application performance while minimizing database load.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_memcached.php


White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server

Many ISVs and OEMs have seen that MySQL Embedded Server's superior scalability -- in both concurrent userload and overall data volume, cost-savings, platform freedom, and feature set combine to provide a compelling business case to move some or all of their Access applications to MySQL Embedded Server. This paper provides insight into what is needed when considering a move from Microsoft Access to MySQL Embedded Server and presents a number of options that ease the transition.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_msaccess_to_oem.php


White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


Tutorial: Developing Database Applications Using MySQL Connector/C++

This tutorial will show you the essential steps to build and install the new, elegant MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and the MySQL database, are the target audience of this tutorial. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Read this Tutorial:
 
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_dbapps_connector-c.php


Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer

Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.

The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the new MySQL Query Analyzer.

Read the Case Study:
 
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.php


Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information

Aito Technologies has chosen to employ the MySQL Embedded Database Server in order to successfully analyze up to billions of daily phone calls, text messages and mobile data sessions.

With reference clients such as Nokia, TDC, Blyk, Elisa and Muxlim, Aito's daily traffic load entails several terabytes of data. Consequently, the vendor's application has strict requirements for high database performance and scalability on a multiprocessor architecture.

Read the Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_Aito.php


PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL:
  http://planet.mysql.com/

Submit Your Blog Feed:
  http://planet.mysql.com/new


PlanetMySQL Blog: MySQL 5.5.4 is Very Exciting Jeremy Zawodny

Yesterday at the MySQL Conference, I spent time in a few sessions discussing the performance enhancements in the MySQL 5.5.3 and 5.5.4 milestone releases. What I saw made me very, very happy. In fact, the timing couldn't be better.

Read the PlanetMySQL BlogPost:
  http://blog.zawodny.com/2010/04/14/mysql-5-5-4-is-very-exicting/


PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions Giuseppe Maxia

While I was researching for my partitions tutorial, I came across two hidden problems, which may happen often, but are somehow difficult to detect and even more difficult to fix, unless you know what's going on, and why. I presented both cases during my tutorial, but there were no pictures to convey the mechanics of the problem. Here is the full story.

Read the PlanetMySQL BlogPost:
 
http://datacharmer.blogspot.com/2010/05/two-quick-performance-tips-with-mysq
l.html


PlanetMySQL Blog: MySQL: The maximum value of an integer Roland Bouman

Did you ever have the need to find the maximum value of an integer in MySQL?
Yeah, me neither. Anyway, some people seem to need this, and this is what I came up with.

Read the PlanetMySQL BlogPost:
  http://rpbouman.blogspot.com/2010/05/mysql-maximum-value-of-integer.html


PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome Johan Andersson

SPJ (preview, not production ready) is a new feature allowing some types of JOINs to be pushed down and executed inside the data nodes! This allows for, in many cases, much faster JOIN execution.

Read the PlanetMySQL BlogPost:
 
http://johanandersson.blogspot.com/2010/04/mysql-cluster-spj-preview-feedbac
k_27.html


PlanetMySQL Blog: Trying out MySQL Cluster Push-Down-Join (SPJ) preview Andrew Morgan

At the 2010 MySQL User Conference, Jonas Oreland presented on the work he's been doing on improving the performance of joins when using MySQL Cluster - the slides are available for download. While not ready for production systems, a preview version is available for you to try out. The purpose of this blog is to step through testing an example query as well as presenting the results.

Read the PlanetMySQL BlogPost:
 
http://www.clusterdb.com/mysql-cluster/trying-out-mysql-push-down-join-spj-p
review/


PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python Geert JM Vanderkelen

Last week, my colleague Massimo and I discussed how to handle big result sets coming from MySQL in Python. The problem is that MySQL doesn't support server-side cursors, so you need to select everything and then read it. You can do it either buffered or not. MySQL Connector/Python defaults to non-buffered, meaning that you need to fetch all rows after issuing a SELECT statement. You can also turn on the buffering, mimicking what MySQL for Python (MySQLdb) does.

Read the PlanetMySQL BlogPost:
 
http://geert.vanderkelen.org/2010/04/simulating-server-side-cursors-with.htm
l


PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group Giuseppe Maxia

Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting, for me, a new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured along the immense corridors of the Mandalay Bay convention center.

Read the PlanetMySQL BlogPost:
 
http://blogs.sun.com/datacharmer/entry/mysql_community_meets_the_independent


PlanetMySQL Blog: Reducing locks by narrowing primary key Shlomi Noach

In a period of two weeks, I had two cases with the exact same symptoms.
Database users were experiencing low responsiveness. DBAs were seeing locks occurring on seemingly normal tables. In particular, looking at Innotop, it seemed that INSERTs were causing the locks.

Read the PlanetMySQL BlogPost:
  http://code.openark.org/blog/mysql/reducing-locks-by-narrowing-primary-key


PlanetMySQL Blog: MySQL Performance: Improving Stability Dimitri Kravtchuk

Huge performance improvement has come with MySQL 5.5.4, and looking at the following picture it's very easy to see why.

Read the PlanetMySQL BlogPost:
 
http://dimitrik.free.fr/blog/archives/2010/05/mysql-performance-improving-st
ability.html


PlanetMySQL Blog: MySQL Random Data Selection Mahmud Ahsan

Some days ago I was working in a vocabulary game and dictionary. The dictionary contains 1,10,000 words and meanings. I developed a vocabulary game where I had to randomly choose 10 words out of 1,10,000 dataset. Here I'm describing the possible solutions for this problem and which solution I used.

Read the PlanetMySQL BlogPost:
  http://thinkdiff.net/mysql/mysql-random-data-selection/


PlanetMySQL Blog: A backup today saves you tomorrow Ben Mildren

Whether you're working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should always have a backup.
As a Production DBA you're the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way to recover should the worst happen and the database becomes irreparable.

Read the PlanetMySQL BlogPost:
  http://www.productiondba.com/2010/04/a-backup-today-saves-you-tomorrow/


PlanetMySQL Blog: Choosing the right data type makes a big difference Venu Anuganti

Today evening one of my friend asked me in the IM to look into one of his production server where a query was taking about 11 seconds to run on 20 million row table, even though the query is using the right index and the plan as shown below.

Read the PlanetMySQL BlogPost:
 
http://venublog.com/2010/04/19/choosing-the-right-data-type-makes-a-big-diff
erence/

-------------------------------------------------------------------

Events

Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features Tuesday, May 25, 2010 - 9:00am PT

Join MySQL and Java experts, Mark Matthews and Todd Farmer, for an encore performance of their MySQL 2010 User Conference Session. In this technical presentation they will explain how to use the scalability and reliability features that are built into MySQL Connector/J to do

- Fault tolerant load balancing
- Replication-aware load balancing with slave fail-over
- Custom exception handling
- Sharding through some creative use of statement interceptors mixed with the built-in load balancer

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-537.html


Live Webinar: Getting started with MySQL Replication - Italian Tuesday, May 25, 2010 - 10:00 CET/8:00 UTC

MySQL Replication is widely used to deploy scalable and highly available database architecture. In this presentation we will demonstrate how to get started with configuring MySQL Replication. We will also cover how replication works, supported replication topologies and how to perform management and administration tasks.

Register for this Italian Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-540.html


Live Webinar: MySQL Performance Tuning Best Practices - French Wednesday, May 26, 2010 - 10:00 CET/8:00 UTC

You will get expert insight and learn best practices from the experts at MySQL to help you improve performance! We will discuss the main performance optimization opportunities, including schema optimization, server options tuning, storage engine selection, and more.

Register for this French Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-543.html


Live Webinar: MySQL Replication - Part 2 - German Thursday, May 27, 2010 - 15:00 CET/13:00 UTC

In this presentation we will look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization.

Register for this German Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-539.html


On-Demand Webinar: Introducing MySQL Cluster 7.1

In blazing speed we will cover the most important features of MySQL Cluster
7.1: NDB$INFO; MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Watch the On-Demand Webinar:
 
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-527.html


On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

The Java Persistence API is the Java API for the management of persistence for Java EE and Java SE applications. It provides an object/relational mapping facility for the Java application developer using a Java domain model to manage a relational database. The release 2.0 has been expanded to include several key new features.

This session will provide an introduction to the Java Persistence API and then a presentation of some of the new features available in Java Persistence 2.0. The talk will provide an overview of the object-relational mapping and modeling additions, the query language facilities, the new criteria API, pessimistic locking, and support for validation.

Watch this On-Demand Webinar:
 
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-504.html


More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars:
  http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
  http://twitter.com/mysql

Follow MySQL Community on Twitter:
  http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Comment (0)

Cost savings are still the primary driver for organizations choosing open-source software, according to Jay Lyman, an analyst at The 451 Group. However, that impression seems to change after adoption, when more users report that flexibility is the primary benefit they enjoy rather than cost savings, he says.

"With the downspin of the economy, how you spend your money is critically important," says Bassim Hamadeh, founder of University Readers, which uses SugarCRM software. "But beyond saving money, what we look for is better software." SugarCRM offers enough flexibility that when the IT team wants to add a feature to the Web site, it first considers creating it in SugarCRM.

Comment (0)

Several months ago, during a period of unemployment, my old laptop died necessitating that I buy a new computer.  The computer I selected came with a 60 day trial version of Microsoft Office.  Since I have used Office for over 20 years and needed a word processor and spreadsheet package, I almost bought the real version.  Because I am an IT professional who likes to develop applications in Access, I wanted the professional version of Office and that cost around $400.

Remember, I was unemployed.  That $400 was almost my entire gross take home from my unemployment payments!  I simply could not afford Office at that price and the Student Home Edition didn't give me what I wanted.  My son is a college student in another state and he loves Open Office so much that even when offered an inexpensive version of Office through his college bookstore, he shunned it in favor of Open Office.  Taking a cue my my son, I downloaded Open Office and got hooked!  No more was I chained to Microsoft!

 But I didn't have a good tool to manage my email.  That's when discovered Mozilla Thunderbird and its many extensions.  Why would I need Outlook? 

The greatest weakness in OO is Base.  Base isn't Access; it's not even close.  I have an extensive programming background and can get by some of the Base weaknesses by writing code but not everyone can do that.  I figure that if I should ever truly need Access, I can buy that product alone.

Ironically, I'm now working but I don't intend to return to Microsoft Office at its very expensive price.  I'm hooked on Open Office!

Comment (0)

 

Zend framework is the latest buzz in the open source universe. There is a huge demand for Zend Framework developers.

Zend Framework is the framework of choice across the world today.This is for many reasons

• It is industry backed. IBM, Zend etc. are involved in the development of this framework
• It is flexible and powerful
• Fully written in PHP5 and is completely object oriented.
• It provides API support to Google, Yahoo, Flickr, Amazon etc.
•  Modular and extensible
• Minimum Configuration required,

Clearly Zend Framework is here to stay. It makes more sense to equip yourself with an emerging technology than learn a technology that has millions of people already.

To learn zend framework from people who use this technology in their day to day life, feel free to mail enquiry@zendframework-training.com .

You may visit http://www.zendframework-training.com

Comment (1)

Search Engine Optimization is a great way to kick-off your Web marketing, increase your web presence, increase your visibility, double up your revenues and kill the competitors.
Today’s business has become reliant on the Internet as the easiest and most reliable way to access information quickly.
Information search on the web is becoming way of life, everything can be found online—including your services, it is a great way of marketing your product and services. The only tricky part is making your Web site visible to potential customers when they are looking for you. That’s where our SEO services come into picture.
We provide complete Web Promotion Expert Services including Search Engine Marketing (SEM) and SEO consulting Services. In synchronization with the latest trends, our unique methodology integrates following factors to render a complex matrix of SEO practices thereby helping you to promote your business globally.

What our SEO Experts Do for You?

Competitors’ analysis

Market research and analysis

Key phrase research and analysis

Meta tags and other HTML tags creation

Website architecture and navigation creation

Content Optimization

Quality Link Building with relevant sites

Search Engine Submissions

Manual Submission in Web Directories

Listing of your website in Business Yellow Pages

Creation of classified ads

Ezine / Articles and online PR publications

RSS feeds generation and optimization

Blog promotion

Social Media Optimization

for more

 http://www.php2ranjan.com

Comment (0)

What Kind of services we provide   

 Search Engine Optimization is a starting point for your Web marketing campaign that will increase your web presence, your visibility, double up your revenues and kill your competitors.

In recent years internet become one of the most preferred and most reliable way to access information. Information search on the

web is becoming way of life, everything can be found online—including your services, it is a great way of marketing your product and services.

The only tricky part is to make your website available to your potential customers when they are looking for the services that you are offering. That’s where our SEO services come into picture.

We provide complete Web Promotion Expert Services including Search Engine Marketing (SEM) and SEO consulting Services. In synchronization with the latest trends, our unique methodology integrates following factors to render a complex matrix of SEO practices thereby helping you to promote your business globally.

SEO techniques are most simple and best way that helps you with all the work that is performed by a traditional media company. Search engine optimization strategy includes adjustment of keywords and keywords phrases visible on the website to visitors. SEO is also useful to analyze the web traffic details to know what factors contribute to ranking, because SEO drives organic traffics and push site position and ranking. SEO bringing more traffics to your website and increasing organic traffics rates regular, especially those types of traffics only who are interested in your services or products.

Our Services
	On page and off pageoptimization		Email Broadcasting
	Manual Search Engine Submission		Manual Directory Submission Service
	SERP management Services		Social Media Optimization
	Social Bookmarking Services		Website Promotion Services
	SEO Training online and onsite		SEO Link building
	Blog , Forum and Article submission		Google,yahoo & bing Ranking management
	Pay Per Click (PPC) Management PPC		Management Services India
Our other Services
	SEO Training online and onsite		PHP Website in Low cost
	Static website of 5 pages at $70		Web Hosting with free one domain at $25
	SEO Training online and onsite		PHP Training, PHP ready made site for Sale

 

Comment (0)

The Best Free SEO Tools

Google Webmaster Tools

• Submit Your Website to Google
• Google Webmaster Checklist
• Official SEO Starter Guide (By Google)
• Google Keyword Tool and Google Search Based Keyword Tool

Yahoo! Site Explorer

• Submit Your Website to Yahoo!
• Follow the Official Yahoo! Search Blog

Bing Webmaster Toolbox

• Submit Your Website to Bing
• Bing Webmaster Tools
• Bing SEO Basics Guide
• Bing Developer Tools
• Follow the Bing SEO Blog

Free SEO Software Tools

• Google Website Optimizer
• Link Sleuth, Broken Link & Image Validation
• HTTPWatch Redirect Validation
• Free XML Sitemap Generator
• Website Grader – Site Audit Tool
• Darxx SEO Audit Tool
• Qualidator (Bad Ass Tool)
• Test Page Load Time
• Measure Your Inbound Links

 

Comment (0)