Schooner Releases Active Cluster for MySQL
New clustering system promises fully synchronous replication for MySQL databases.

Xeround Brings MySQL to Heroku
The MySQL in the cloud vendor extends its platform for Ruby developers.

MySQL Data Fragmentation - What, When and How
Fragmentation can leave large holes in your table, blocks which must be read when scanning the table. Optimizing your table can make full table scans and range scans more efficient.

Converting between MySQL Date and Time Formats
MySQL's thorough and flexible date handling allows you to switch between internal and external date/time formats with relative ease.

MySQL InnoDB File Formats
Versions of MySQL now come equipped with the powerful and stable InnoDB plugin. We will cover file formats in this article, a very important part of the InnoDB plugin feature set.

Using MySQL's Analysis Tools to Improve Query Performance
One nice feature added to the EXPLAIN statement in MySQL 4.1 is the EXTENDED keyword which provides you with some helpful additional information on query optimization.

Five Considerations for MySQL Security and Compliance in the Cloud
Security and compliance are big worries in the cloud. We give you some strategies for coping.

Comparing MySQL Statement-Based and Row-Based Replication
There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.

Identify Slow Queries using MySQL’s Analysis Tools
Using MySQL analysis tools, you can identify and optimize slow queries in order to eliminate the bottlenecks that they cause. Rob Gravelle examines the Slow Query Log and Explain command, which can both help identify slow queries.

Top 5 Considerations for MySQL Administration in the Cloud
Cloud deployments of internet sites are becoming much more prevalent every day. Let's take a look at what type of special considerations we'll need to make for hosting MySQL successfully in the cloud.

Top 10 MySQL Best Practices
Rob Gravelle lists his top 10 MySQL best practices for database administrators, architects, developers, and security personnel.

MySQL Workbench - Top 13 things you should know
MySQL Workbench has come a long way and keeps getting better! I honestly don't think that millage may vary on this one as it is one of the best no-cost GUI tools created for MySQL.

Writing Reusable Queries in MySQL
While stored procedures are an integral part of writing reusable code, they are only one ingredient in a bigger pie. Other key players include views and native as well as user-defined functions. This article explains how all of these elements fit together so that your SELECT statements can be applied to a greater variety of queries.

Limiting the Number of Rows in MySQL Result Sets
In the Web 2.0 world where smart phone and Web applications are competing to access terabytes of data, there is a new imperative for speeding up retrieval times as much as the technology permits. Rob Gravelle lists a few coding techniques that we as database administrators and developers can use to whittle down unwieldy results sets into manageable chunks.

Troubleshooting MySQL Slow Queries with Tcpdumps
MySQL has a wonderful facility for capturing slow queries called the slow query log. However if yours is not enabled when trouble occurs, and restarting the database is not an option, you'll need another solution. This is where a tcpdump can come in handy.

Optimizing MySQL Query Retrieval Speed Through Table Joins
A poorly optimized query can become the bottleneck in an otherwise highly optimized process. In many cases, the source of the slow performance is improper table joining in the WHERE clause. With that in mind, this article looks at ways to optimize table joins for speedy data retrieval.

MySQL Point in Time Backups
Point in time backup and recovery is a crucial component of any part of any MySQL environment. This article describes how to implement the basic point in time recovery and describes a few mechanisms to accomplish this goal.

Use Derived Tables in Your MySQL Queries to Improve Database Performance
There has been much debate as to whether derived tables, views, or temporary tables are actually faster in terms of database performance. The fact is that there is no simple answer, as different queries require different optimizations. Rob Gravelle presents and evaluates some uses for derived tables that highlight their value in many applications.

MySQL Hotbackups with XtraBackup
Hotbackups are a staple of many different database platforms, but they remain sadly absent from the core MySQL distribution. Not to worry, the open-source utility has just arrived to rescue you.

Eliminating Duplicate Rows from MySQL Result Sets
The go to solution for removing duplicate rows from your result sets is to include the distinct keyword in your select statement. It tells the query engine to remove duplicates to produce a result set in which every row is unique. The group by clause can also be used to remove duplicates.

IBM Launches Java PaaS, SmartCloud Services
Big Blue takes on Oracle with its new enterprise public cloud offerings.

Oracle Touts Cloud Capabilities for Solaris 11
An "early adopter" release of the OS is now available.

New Ubuntu Release Offers DevOps Features
The latest version of the operating system, codenamed Oneiric Ocelot, is now available for download.

The Rise of Functional Programming
Functional programming approaches are becoming more popular because of pervasive unit testing and concurrency needs.

What Are Philosophy-Based Design Patterns?
Software engineering is largely about analyzing a portion of the real world and translating it into a software system. What could be a richer source for ideas about reality analysis than philosophy?

Google Strengthens its Cloud Development Offerings
New tools could help Google compete with Amazon for enterprise cloud computing business.

Microsoft to Improve Support for Hadoop
The company will work on Hadoop distributions for Azure and Windows Server.

Reasons Not to Build Enterprise Apps on Top of Open Source Code
Application developers should be aware of the potential drawbacks of open source projects.

Facebook's Plan for Mobile App Discovery
The social network launches a host of new tools to make it easier to find mobile apps.

Moving from Accidental Architecture to Enterprise Architecture
Unstructured, "accidental" application architecture creates long-term inefficiency and design barriers. Enterprise architecture with shared services can alleviate the problem.

Report: PaaS to Top $707.4 Million This Year
Gartner says cloud development services are poised to take off.

Motorola Unveils New Mobile App Development Framework for Enterprises
RhoElements uses HTML5 technology to create cross-platform apps.

Google Adds a Relational Database to App Engine
Google Cloud SQL will make it easier to deploy SQL-based applications in the cloud.

Report: 98 Billion Mobile App Downloads by 2015
App revenues could hit $11.8 billion in four years.

Oracle Launches Public Cloud
CEO Larry Ellison takes a swipe at Salesforce.com.

One Out of Five Software Development Projects Fails
However, Agile development is leading to an increase in successful projects.

PEAF Simplifies the Rocket Surgery of Enterprise Architecture
Call it pragmatic, call it streamlined, but don't call the Pragmatic Enterprise Architecture Framework (PEAF) TOGAF lite.

Roslyn "Compiler as a Service" Still Far Off
A preview will likely be available this month, but the project will most likely not be included in Visual Studio 2012.

Get Your iOS 5 Apps Ready
Apple has released the iOS 5 Gold Master and will accept apps based on the firmware update.

Oracle Unveils New Technologies, Plans at JavaOne
The company released JavaFX 2.0 and discussed plans for Java 8 and 9.

Guide to Browser Security and Safe Web Browsing
Ensuring a safe web browsing experience is a key part of any effective Internet security strategy. Are you up-to-date on the latest browser vulnerabilities, security add-ons, and best practices? Download this Internet.com eBook to learn which browser offers the best security, how to extend your browser's security capabilities, and how to stay clear of the top web malware threats.

Windows Phone 7 Quick Start Developer Guide
If you have already developed for other mobile platforms you probably don't want to ignore Windows Phone 7. Or maybe you haven't developed for mobile devices yet but would like to start with the Windows Phone. Either way, this eBook is for you.

40 Ways to Make Your Data Center More Efficient
Managing a collection of computer systems is no easy task. But, through better management and proper planning even the most inefficient data center can change its ways. Download this eBook for 40 steps you can take to the most out of your data center and its employees.

Solving Storage for Your SMB
Many Storage solutions are aimed at large enterprises and are designed to address their concerns surrounding infomation lifecycle management and corporate compliance. But small and medium-sized businesses have storage concerns of their own. Download this Internet.com eBook for a guide to choosing a storage server and building a storage strategy for your SMB.

Exploring the Private Cloud for Your Organization
One of the ways around the issues of security and control that make some businesses wary of cloud computing is to build a private cloud -- one that remains within the corporate firewall and is wholly controlled internally. Private clouds also increase the agility of IT an organization's IT infrastructure and make it easier to roll out new technology projects. Download this eBook to get the facts behind the private cloud and learn how your organization can get started.

Java Design Patterns: Proven Solutions to Common Problems
Design patterns not only provide proven solutions to common development issues, they also make communication between developers and designers more efficient.

Java PaaS Profile: CumuLogic
The CumuLogic Java PaaS solution -- a new player in the Java PaaS space -- enables developers to build and manage Java applications in a variety of cloud environments using familiar components.

Send Large Data Sets from WCF to Silverlight
Web.config alterations allow a WCF service to feed data to Silverlight applications, but may they may fail for large production data. Find out how to work with large data sets.

Java Stays on Top of Tiobe Chart
Despite predictions to the contrary, Java is still the world's most popular programming language.

IBM Brings Message Queuing Telemetry Transport to Eclipse
Open source client for MQTT protocol could open up the Internet of Things.

Java PaaS Snapshots: Java Cloud Platforms at a Glance
The Java Platform-as-a-Service (PaaS) market gets more crowded every day. How do these Java cloud platforms differ? What are their relative pros and cons?

IBM Launches Java PaaS, SmartCloud Services
Big Blue takes on Oracle with its new enterprise public cloud offerings.

Coverity 5.5 Finds Bugs and Continuous Integration Kinship
New release of Coverity 5.5 static analysis tool integrates FindBugs and Jenkins to expand continuous build and test workflow.

Java 8 Delayed Until 2013 As Java EE and ME Push Forward
Oracle lays out roadmap for Java releases

Oracle Unveils New Technologies, Plans at JavaOne
The company released JavaFX 2.0 and discussed plans for Java 8 and 9.

What's In Store for Java 8 and 9?
Java Chief Architect Mark Reinhold gives a glimpse of the future of Java at JavaOne, going beyond Java 7 to give a sneak peek of Java 8 and Java 9.

Implement Java Object Management Using a Protocol Buffer
Find out how to bring a protocol buffer -- the simplest and most efficient way to manage structured data -- into your Java object management.

Adobe Unveils Flash 11 and Air 3
Will the new tools help the company defend against HTML5?

Why Your Silverlight and VB6 Applications Are Ticking Time Bombs
Your new Silverlight applications are as liable to "blow up" as your old legacy VB6 applications, argues this founder of a .NET tools company.

Java Code to Filter File Names in a Directory
Using this Java code snippet, you can filter file names for array of extensions, split the file names, and test the resulting array.

Managed Classes and Object Injection in Java EE 5
Get a quick reference for what types of managed class can inject what object in Java EE 5.

Heroku Adds Java Support
The Heroku cloud development service now supports four programming languages.

Managing Concurrent Requests with EJB Containers
A limitation of EJB containers is that they can't serialize complex objects. Find out how the PrePassivate and PostActivate methods overcome this shortcoming.

Getting Started with JUnit on Android
JUnit is a great unit testing platform for Java applications and now it offers special APIs for Android developers. Learn how to get started with JUnit on Android.

Oracle Releases Java 7
What's in the Java 7 update for developers.

Implementing Active Directory Services in ASP.NET 2.0
With the introduction of ASP.NET 2.0 and Visual Studio 2005, many of the security tasks required to connect an application's authentication and authorization mechanisms to Active Directory have been dramatically simplified. This article shows how to perform both Active Directory (LDAP:\\) and local member server (WinNT:\\) tasks.

ASP and the Error Handler
ASP pages are so easy to put together that sometimes developers have not thought through the problems associated with errors. Error handling can help your application to be more robust. This article by Richard Bundock dives into the basics of error handling.

Building a .NET Console Application for Scheduled Tasks
This article walks you through the process of building a simple .NET command-line application that is designed to be scheduled to execute. The sample application will send an HTTP request to a web server and send the returned HTML as the body of an email message. Once the application is complete, the article will examine how to schedule it to run using Windows Scheduled Tasks.

Customizing SharePoint Web Parts with Custom Properties
In addition to creating custom Web Parts for SharePoint Portal Server, developers can actually create their own custom properties to further enhance Web Part appearance and behavior. Gayan Peiris explains the process and provides all the necessary code.

A Step-by-Step Guide To Using MySQL with ASP.NET - Part 1
Back in the days of classic ASP, if you were building a database-driven web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server (or some other enterprise-ready database) or invest a lot of time finding a way to deal with the performance and scalability limitations of Microsoft Access. Luckily these days there's another viable alternative: MySQL.

A Step-by-Step Guide To Using MySQL with ASP.NET - Part 2
In the second part of of his article on using MySQL with ASP.NET, Ziran Sun covers how to add a new MySQL user to the database server, assign the user the appropriate permissions, connect to the database, and build a simple ASP.NET page to perform a query.

A Step-by-Step Guide To Using MySQL with ASP.NET - Part 3
In the third part of his series on using MySQL with ASP.NET, Ziran Sun provides a C# version of his ASP.NET 1.x sample query page, explains how to connect to MySQL using ASP.NET 2.0's new fully declarative data binding model, and provides a solution to those pesky namespace not found errors.

Tracing in .NET and Implementing Your Own Trace Listeners
Mansoor Ahmed Siddiqui explains debugging and tracing and shows how to create custom trace listeners to help ensure hassle-free development.

Tuning Up ADO.NET Connection Pooling in ASP.NET Applications
Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. This article shows how to monitor the connection pool, diagnose a potential problem, and apply the appropriate fix.

N-Tier Web Applications using ASP.NET 2.0 and SQL Server 2005
While the .NET Framework made building ASP.NET applications easier then it had ever been in the past, .NET 2.0 builds on that foundation in order to take things to the next level. This article shows you to how to construct an N-Tier ASP.NET 2.0 Web application by leveraging the new features of ASP.NET 2.0 and SQL Server 2005.

Monitoring SharePoint Usage through an ASP.NET Web Application
In this article, Gayan Peiris looks at creating an ASP.NET web application that will display the usage details of a selected SharePoint site. Building such an application enables SharePoint administrators to gather all SharePoint usage data from a central location.

Create a Slide Show Using the AJAX SlideShow and TreeView Controls
Most web-based slide show applications depend on a database for some or all of the storage. This application allows you to show pictures from a directory structure without any underlying database. The application uses an ASP.NET 2.0 TreeView control for file system navigation and the AJAX 1.0 SlideShow Extender to display the images found in the directory.

Retrieving SharePoint Site Information in an ASP.NET Web Application
In this article, Gayan Peiris examines using the SharePoint Object Model to access SharePoint site information from an ASP.NET web application. It should be of particular interest to SharePoint administrators who can use the included code as a starting point for development of their own web-based SharePoint administration application.

Introduction to Relational Databases - Part 1: Theoretical Foundation
The first article in this two-part series provides a basic understanding of the theoretical principles of database design and describes some key elements and rules of creating relational databases.

Writing a Custom Membership Provider for the Login Control in ASP.NET 2.0
In ASP.NET 2.0 and Visual Studio 2005, you can quickly program custom authentication pages with the provided Membership Login controls. In this article, Dina Fleet Berry examines the steps involved in using the Login control with a custom SQL Server membership database.

Business Intelligence with Microsoft SQL Server Reporting Services - Part 1
Adnan Masood discusses Microsoft's comprehensive integrated business intelligence, data mining, analysis and reporting solution: Microsoft SQL Server Analysis services and Microsoft SQL Server Reporting services.

Business Intelligence with Microsoft SQL Server Reporting Services - Part 2
Adnan Masood continues his discussion of Microsoft SQL Server Analysis services and Microsoft SQL Server Reporting services. In this part, he discusses the steps that go into building more advanced reports.

Business Intelligence with Microsoft SQL Server Reporting Services - Part 3
Adnan Masood concludes his discussion of Microsoft SQL Server Analysis services and Microsoft SQL Server Reporting services. In the final part, he discusses Reporting Server web services and using custom code in reports.

Debugging a SQL Stored Procedure from inside SQL Server 2000 Query Analyzer
There are many times when using SQL Server 2000 Query Analyzer to debug SQL statements is a better choice than debugging in Visual Studio .NET. In this article, Dina Fleet Berry explains why and walks you through the debugging process step-by step.

Using the Enterprise Library Validation Application Block in ASP.NET - Part I
This article shows how you can take advantage of the validation features within the Validation Application Block, part of version 3.0 of Enterprise Library, in your ASP.NET applications. Part one examines the Validation Application Block's built-in validators, configuring validation rule sets, and using validation rule sets in ASP.NET.

Guide to Browser Security and Safe Web Browsing
Ensuring a safe web browsing experience is a key part of any effective Internet security strategy. Are you up-to-date on the latest browser vulnerabilities, security add-ons, and best practices? Download this Internet.com eBook to learn which browser offers the best security, how to extend your browser's security capabilities, and how to stay clear of the top web malware threats.

Windows Phone 7 Quick Start Developer Guide
If you have already developed for other mobile platforms you probably don't want to ignore Windows Phone 7. Or maybe you haven't developed for mobile devices yet but would like to start with the Windows Phone. Either way, this eBook is for you.

40 Ways to Make Your Data Center More Efficient
Managing a collection of computer systems is no easy task. But, through better management and proper planning even the most inefficient data center can change its ways. Download this eBook for 40 steps you can take to the most out of your data center and its employees.

Solving Storage for Your SMB
Many Storage solutions are aimed at large enterprises and are designed to address their concerns surrounding infomation lifecycle management and corporate compliance. But small and medium-sized businesses have storage concerns of their own. Download this Internet.com eBook for a guide to choosing a storage server and building a storage strategy for your SMB.

Exploring the Private Cloud for Your Organization
One of the ways around the issues of security and control that make some businesses wary of cloud computing is to build a private cloud -- one that remains within the corporate firewall and is wholly controlled internally. Private clouds also increase the agility of IT an organization's IT infrastructure and make it easier to roll out new technology projects. Download this eBook to get the facts behind the private cloud and learn how your organization can get started.

Top HTML5 Tutorials from HTMLGoodies
HTML5 is an emerging technology that is slowly changing the face of the web. The latest browsers support it, and developers are eager to begin using it on their websites. HTMLGoodies features many tutorials on the topic, and we've brought them all together here for your perusal.

Getting Started with Joomla!
If you've never heard of Joomla!, it's known as a CMS (content management system), which allows you to build complex web sites and run various applications. In this article we'll look at the many options for setting up Joomla! and how to configure the software.

The Joomla! Demo Site with Cloudaccess.net
In this article, we're going to walk you through the process of installing Joomla! using Cloudaccess.net, a virtual Joomla! application host.

How Can I Select the Best Images for My Website?
Why do you want an image? Is it for a web page as a dominant image, a background or a series of images that are part of a gallery? In this tutorial we will show you how to select the best images for your website.

12 Ways to Create Compeling Graphic Banner Ads for Your Website
As with any design process, the first thing to do is to know what you want to say. In this case, you have the choice of a static, or animated banner. In this tutorial we will tell you 12 tips to help you create compelling banner ads.

Do Web Safe Colors Make a Difference?
Web Safe colors, also known as browser safe colors, were introduced many years ago, when the web was in its infancy. A guestion that comes up every now and then is whether modern web designers should be using this type of palette - or not?

How Can I Create Images for Mobile Devices?
When you think about mobile devices, the idea of creating images would seem to be a straightforward process. Unfortunately, it's not, but in this tutorial we will cut to the chase and show you how it's done!

One Video URL to Rule Them All
HTML5 is changing the landscape on how video is presented on web pages. New formats, codecs, screen sizes, devices and browsers are being developed on a continuous basis. What's one to do? Enter Vid.ly, which provides a universal video URL.

Web Developer Basics: The HTML5 Video Element
This article begins a "mini-series" of our in-depth coverage of important new elements in HTML5 to help you create media-rich pages that will work in any compliant browser. In this session we introduce the Video element!

Web Developer Class: Creating Forms with CSS3
You only have to look as far as Twitter's relatively new interface to see that stylized text boxes are still a popular design choice for input fields and forms. In this tutorial we will teach you a few different techniques to create styled forms and input fields using CSS3.

Web Developer Basics: Using The HTML5 Canvas Element
This article continues our "mini-series" of important new elements in HTML5 to help you learn to create media-rich pages that will work in any compliant browser.

Using HTML5 Automatically For Placeholders in Email Forms--With No JavaScript
Previously, if a developer wanted to include some sample text in an email field in a form, and then make that text disappear when the user clicked within that field, they had to use some JavaScript to make it happen. Enter HTML5 and the placeholder attribute, which simplifies the whole process--using no JavaScript at all!

Web Developer Basics: Differences Between HTML4 And HTML5
Now that we've seen how to use some of the newer whiz-bang features of the draft HTML5 standard, it's time to take a few steps back and take a look at some of the other differences between HTML4 and HTML5.

HTML5 Primer: How To Use the Audio Tag
In our series on HTML5, we've discussed geolocation, link relations, form and keyboard events, media events, mouse events, global attributes and multimedia. This week we're going to expand upon our discussion on multimedia and delve further into HTML5's <audio> tag.

Add Read More Link When People Copy From Your Site Using JavaScript
You may have been to a website and went to copy some text from the page and noticed that when you pasted the text it also copied a "read more" note which included the URL of the page you copied from. In this tutorial we will show you how you can do the same thing using a tidbit of JavaScript.

Ten Awesome Things Most People Don't Know About PHP
We all know the magic tricks, we all know the cool little functions. We all know the way to make dates look cool and numbers look awesome. But there are things most people don't think about, and I'm one of them. When I started writing this article I did a little research and found a few things that will also make me change the way I use PHP, and why I use.

Web Developer Tutorial: HTML5 Microdata
The HTML 5 draft specification includes Microdata. The Microdata spec provides a standardized syntax for addition additional semantic markup to your web pages to enhance the machine readability of your web pages. This tutorial will discuss microdata and will show why you should be interested in it!

Web Developer Class: Building a Twitter Feed with PHP
In today's world of social networking there will come a time that someone asks you to do Twitter integration for their website. This tutorial will walk you through the process, and includes source code!

Web Developer Basics: Multimedia In HTML5
In the last installment of this series, we talked about link relations in HTML5. In this article, we'll see how support for various multimedia formats in HTML5 will make things much easier for you as a developer...eventually.

Firefox Extension for Web Development: Font Finder
Continuing with the series on Firefox extensions for web development, this article features the Font Finder add-on which allows developers to analyze font information on a Web page and modify it for demonstration purposes.

The Cloud CRM Market: Microsoft, Salesforce, SAP, Oracle and More
The cloud CRM market is a crowded one, so we offer an overview of the biggest names in our cloud CRM buying guide.

What Oracle Fusion CRM in the Cloud Means for Salesforce and Siebel Customers
Oracle made a bold move into cloud CRM this month, but what does it mean for competitors like Salesforce and Microsoft and Oracle's own Siebel customers?

NetSuite Updates OneWorld Cloud ERP
NetSuite OneWorld 2011 boasts new CRM and analytics features.

Oracle Buys RightNow for Cloud Customer Service
Oracle takes aim at Salesforce.com with its expanding cloud CRM service.

SAP, Salesforce Invest in Box Cloud Collaboration Service
Box closes on an $81 million funding round for what the company claims is 'one of the fastest-growing enterprise applications of all time.'

Cloud Database Buying Guide
Cloud databases can save you time and money, but use them carefully.

Oracle Launches Cloud Platform for CRM, HR
Larry Ellison blasts Salesforce.com as a 'roach motel' cloud as new database, Java and Fusion Apps cloud debuts.

SaaS a Reality with 95 Percent Participating
Gartner finds that 95 percent of respondents to a recent survey plan to grow or maintain use of software-as-a-service.

Cloud Security in Datacenter Terms
Security in the cloud isn't the same as security in your own data center.

EMC Improves Atmos Cloud Metering, Adds GeoDrive Linux Support
The storage giant has beefed up its platform for helping service providers and enterprises build storage-as-a-service offerings and has added support for Linux to its Atmos GeoDrive software.