MySQL is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. It is downloadable from mySQL website (http://www.mysql.com) and tailor it to their needs in accordance with the general public license. MySQL is noted mainly for its speed, reliability, and flexibility.

Rick F. van der Lans explains how SQL's GROUP BY clause groups rows on the basis of similarities between them. He goes on to explain the use of adding aggregation functions to display summations, averages, frequencies, and subtotals....   Read Article.

Kurt Hudson did a bit of experimenting with the Universal Group Membership Caching feature of Windows Server 2003 Active Directory. He found some surprises (including results that seem to contradict statements he found in Microsoft TechNet documentation), and shares them in this article....   Read Article.

The LAMP configuration (Linux, Apache, MySQL, and PHP) is familiar to the open source universe. But just because this combination of products is comfortable, that doesn't mean that it provides the best solution for your systems. David Chisnall suggests some alternatives that might make a better match for your needs....   Read Article.

Take a look at the evolution of backup applications for Windows. You will see where the applications have been, and what sort of features and requirements they have now....   Read Article.

PremiumSoft announced the release of its latest MySQL GUI Management Tool - Navicat for MySQL version 7.2.2 today. Navicat website: http://www.navicat.com What's new in this version: Navicat MySQL GUI ver. 7.2.2 supports HTTP Tunnel and Foreign Key Data Selection. This new version lets user connect to remote MySQL database as easy and convenient... Read Article

Repetitive administrative tasks getting you down? Want to save time and keep your stress level low? Read Jesse Smith's tips for some thrifty ways to do co-location backups of general and service related files using batch scripts....   Read Article.

Modern software processes, also called methodologies, are all evolutionary in nature, requiring you to work both iteratively and incrementally. Working iteratively, you do a little bit of an activity such as modeling, testing, coding, or deployment at a time, and then do another little bit, then another, and so on. With an incremental approach, you...   Read Article.

In Part Two of his series, database administration expert Baya Pavliashvili explores the challenges involved in building and maintaining a warehousing solution using a simple database warehouse....   Read Article.

Still cursed with Access-phobia? If you're an experienced Word and Excel user who has not yet experienced Access, you really can overcome your fear. Herb Tyson continues where his Access Fear Factor II article left off. This third installment deals with a few loose ends from the previous article and shows you how to integrate pictures while simultaneously...   Read Article.

Webyog has released SQLyog 5 to manage MySQL 5. SQLyog is an easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. SQLyog is FREE for personal and commercial use. Apart from the usual db client-tool features like export, import, creating dropping of objects, diagnostics flush tools, multiple... Read Article

In the first of a two-part series, Baya Pavliashvili, database administration expert, offers solutions to your business problem using a data warehouse....   Read Article.

Baya Pavliashvili points out a few common situations that can cause tension between developers and DBAs and provides some advice for working your way out of an argument before it leads to a war....   Read Article.

Is your IT team conducting an internal feud, with team members struggling against each other instead of fighting the real problems of limited time, money, and manpower to support your organization's technology needs? Buck Woody argues that you can't afford to become the Hatfields and McCoys....   Read Article.

Here are some tips and tricks for avoiding common pitfalls and writing good T-SQL code, as well as some advanced options that you might find useful....   Read Article.

Learn the concept of data warehousing and how SAP BW (Business Information Warehouse) can help you by examining its architecture....   Read Article.

The position of Database Administrator is at the center of most business processes today. It's also one of the most difficult positions to fill. Get the skinny on DBA tasks and challenges right here....   Read Article.

Get up to speed quickly on how to create MDX expressions based on single and multiple values. This tutorial helps beginners jump right into creating expressions for use with multidimensional data sources....   Read Article.

Explore the analysis capabilities of the Excel PivotTable report to present data from an OLAP (OnLine Analytical Processing) cube. In this tutorial, learn how to build a PivotTable report from scratch, and explore the details of its cube-focused functionality....   Read Article.

Master SQL syntax-based optimizing and simple search conditions. Learn which search conditions are best, and armed with this information, you can decide whether to change the order of expressions, or to substitute one expression for another that does the same work more efficiently....   Read Article.

Using dates in database-management systems (DBMSs) brings up some portability problems and uncovers some undocumented and underexplained features. Peter Gulutzan and Trudy Pelzer explore the DATE data type and its impact on eight SQL DBMSs....   Read Article.