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 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.

CloudBees Extends Java Cloud Integration to Eclipse
Java cloud vendor CloudBees debuts new Eclipse toolkit for streamlining build and deployment.

Implement Data Indexing and Search with Lucene and Solr
Indexing and searching data stored across multiple file formats? Try the powerful combination of the Lucene search library and the Solr search application.

Microsoft Debuts Upgraded Eclipse Tool for Azure Cloud
New Eclipse tool plug-in for Microsoft Azure aims to simplify Java development on Microsoft's cloud platform.

DTS and C#
Data Transformation Services (DTS) is a built-in component of SQL Server that provides programmers and database administrators with a way to move data from any source to any destination. Thiru Thangarathinam shows how to invoke DTS packages from a .NET application and explains how the unmanaged DTS SQL Server COM component is used in a .NET application.

Debugging an HTTP Handler (*.ashx) in ASP.NET 2.0
An ASP.NET HTTP Handler is a simple class that allows you to process a request and return a response to the browser. Unfortunately, when things go wrong, debugging an HTTP handler can be a little tricky. This article examines the process of debugging an HTTP handler in order to get everything working again.

Paging in SQL Server 2005
Developers and database administrators have long debated methods for paging recordset results from Microsoft SQL Server, trying to balance ease of use with performance. The simplest methods were less efficient because they retrieved entire datasets from SQL Server before eliminating records which were not to be included, while the best-performing methods handled all paging on the server with more complex scripting. The ROW_NUMBER() function introduced in SQL Server 2005 provides an efficient way to limit results relatively easily.

Using Collections in .NET
Collections are a vital element of any object-oriented architecture. This article, by Luther Stanton of Intellinet Corporation, introduces collections, looks at some of the benefits and potential drawbacks of using custom collections versus built-in collection-like elements, and then provides a discussion of interfaces and implementations.

Creating a .NET Web Service
This is the first of two articles on Web Services by Chris Peiris. Learn to create a .NET Web Service using C# and examine the Discovery protocol, UDDI, and the future of Web Services.

Creating a Popup Date Picker
Conrad Jalali shows how to extend the functionality of the ASP.NET Calendar control to remove some of the annoying postback delays that occur when populating a text box with a date from a popup calendar.

Sharing Cookies Across Domains
This article shows you how to share the same cookie across multiple sub-domains and multiple domains. Learn about sharing state information across web farms using SQL Server. The examples in this issue highlight the power of redirection within Active Server page and enforce the concepts that relate to cookie manipulation.

A Primer on Using DB2 with .NET
Several companies are tackling the issue of leveraging their investment in DB2 and embracing .NET for some new application development. This is a practical guide to getting started using DB2 from a .NET application developer's perspective. This article will discuss the basics of how to access DB2, what techniques work best, what functionality you can expect, and how to avoid problems.

An Introduction to LINQ - Part 1
The LINQ (Language INtegrated Query) family of technologies is designed to provide a unified approach to accessing data from disparate data sources. This article series will take you from the very basics all the way to performing data access using LINQ. The first installment of the series will focus on the basics of LINQ, introducing the new features of C# 3.0, and how they can be used in conjunction with LINQ.

Consuming Asynchronous Web Services
Thiru Thangarathinam shows how to use asynchronous Web services, Windows Service applications, server-based timer components and .NET XML API classes to create high-performance, scalable, and flexible applications.

Handling Concurrency Issues in .NET
Wayne Plourde focuses on different approaches to concurrency locking and discusses how to handle the situations when they occur.

Serialization in the .NET Framework
This article on serialization in the .NET Framework covers topics such as binary vs. XML and Basic vs. Custom serialization. It concludes with an example of how to add serialization to applications for sending custom objects over the wire with Web services.

Configuring .NET Code Access Security
Code Access Security (CAS) is the .NET Framework security model that grants code permission to resources based on "evidence" pertaining to the encapsulating assembly. In this article, David Myers examines CAS and explains different configuration methods.

Deploying ASP.NET Applications - Part 1
This article details the support provided by the .NET Framework for packaging and deploying ASP.NET Web applications onto target machines. It also shows how to use Windows Installer technology for creating sophisticated ASP.NET Web application installers.

Running IIS on Windows XP Home Edition?
Members of the 15Seconds discussion list may have found a way to run IIS on Windows XP Home Edition, so developers can run ASP pages. Attempt at your own risk!

Integrating Flash with an Access Database
In this article, Matt Duckhouse describes how to connect a Macromedia Flash movie to an Access database using an ASP page as the data-transfer mechanism.

Introducing ADO.NET and the Typed DataSet
Thom Robbins explains how DataSet object features can be combined with XML to create a new type of object called the typed DataSet, which simplifies the task of data navigation.

Web Application Error Handling in ASP.NET
One of many improvements ASP.NET brings to the development table is in error handling. Adam Tuliper whips up a simple ASP.NET solution for handling those pesky and unexpected post-production errors.

ClickOnce Deployment in .NET Framework 2.0
In this article, Thiru Thangarathinam examines .NET 2.0's new ClickOnce deployment technology that is designed to ease deployment of Windows forms applications. This new technology not only provides an easy application installation mechanism, it also eases deployment of upgrades to existing applications.

SQL Server 2005 XQuery and XML-DML - Part 1
Microsoft SQL Server 2005 now offers great support for and close integration with XML as a data persistence format. In the first article of his series examining this new support, Alex Homer offers an overview of how SQL Server 2005 stores XML documents and schemas, examines how it supports querying and manipulating XML documents, and provides a simple test application that allows you to experiment with XQuery.

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.

IBM to Pilot SaaS Offerings for Smarter Commerce
IBM will test market a program to broaden its Smarter Commerce initiative for business partners, adding in Software-as-a-Service (SaaS) applications.

Cloud Computing Data Storage: Buying Guide
Using cloud computing for data storage offers a number of advantages -- if you ask potential vendors the right questions.

5 Best Online Backup Services for Small Businesses
We've got the lowdown on the best online data backup services for small business. Take a look and start your offsite backup today. You'll sleep a lot better tonight.

Symform Targets Low-Cost Cloud Storage With 'Peer-to-Peer' Model
Seattle firm takes novel approach to cloud storage with distributed architecture aggregating unused local resources.

HP's OpenStack Cloud Goes Into Private Beta
OpenStack ecosystem continues to grow, but how do you move data across different OpenStack vendors?

VMware vCloud Enables New Global Cloud
VMware vCloud program lets enterprises acquire, provision, manage and move between multiple service providers.

Cloud Computing SSO and IDM Tools: Buying Guide
Cloud computing single sign-on and identity management tools are gaining importance.

Cloud Computing Security Tools: Buying Guide
Five questions and concerns to consider as your business selects cloud computing security solutions.

A Look at IBM's Small Business Cloud
IBM, like just about every other vendor, is promoting cloud computing solutions. Here two of its customers demonstrate that those services work.

10 Cloud Deployments Worth a Look
Considering a cloud deployment? Here are 10 examples to check out and possibly emulate.