Historically, database auditing and database performance have been like oil and water; they don’t mix. So auditing is often eliminated, because performance drag on critical systems is unacceptable. In ...

With its January 2010 acquisition of Sun Microsystems, Oracle gained the MySQL open source database management software (DBMS) platform for enterprise IT environments. MySQL, which uses SQL ...

Title: Web Database Applications with PHP and MySQLAuthor: Hugh E. Williams and David LanePublisher: O'Reilly & AssociatesISBN: 0596000413Price: $44.95 This book is subtitled Building Effective ...

We’ve all done it. We needed to pull data out of an SQL database, and the query we needed to pull out data was a complex query with multiple table joins, complex filter criteria, and sophisticated ...

Some of the most important ways to reduce risk boil down to the fundamentals of security. Keep systems well-patched, prevent data from spreading around, make sure systems are properly segmented, and ...

In a non-Web environment, an application server performs the business logic (the data processing), although some amount of business logic may be handled by the user's machine. In a private or public ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

Too often, the success of a web site brings its doom. After a good publicity blitz, or a healthy growth of its popularity, the number of users visiting a site becomes very large. Then, at certain ...

From performance to programmability, the right database makes all the difference. Here are 13 key questions to guide your selection. Picking the “right” database can often be critical to the success ...

I've always been a big proponent of using NAS (Network Attached Storage) devices for dedicated file and media storage and backup. They are a low-power, low-cost alternative to a dedicated PC server, ...

There's been a shift in the enterprise Java community when it comes to what has commonly been referred to as an "application server." What was an application server? Historically, when an enterprise ...