(Melonfire) Unlike database backup procedures, which can be automated, securing your data from the prying eyes of unauthorized users requires a certain amount of interaction from the system administrator. If you’re using MySQL, there are some easy things you can do to secure your systems and signifi

(MiMi Yeh) For those accustomed to Microsoft’s SQL Server GUI , there are free, open source options available for keeping the Microsoft look while maintaining the MySQL functionality. SearchOpenSource.com’s new MySQL expert, Scott Noyes, describes several examples and where to download them. In this

(Alessandro Lacava) Write once, run anywhere. This Java motto seems to hold true even for mobile devices. Indeed, since it was born J2ME has had an ever-increasing impact on mobile development. Some may argue that J2ME is not as portable as other Java technologies, but even so, the result obtained o

(Dave Rosenberg and Matt Asay) I remember a few years ago speculating that open source applications would never happen: not a wide enough development community with interest and aptitude in writing that kind of software. (I mention it here.) In short, I had bought into the open source myth that open

(Ian Semmel) This program reads the MySql informational_schema database and, after the user has selected the target database, creates a C# source file containing typed dataset and TableAdapter classes for the contained tables.

(Kevin Ferguson) So, you’re a Microsoft SQL Server administrator flirting with open source, but you’re not sure how far you should go on the first migration? Don’t worry, there won’t be much peer pressure to go “all the way.” Look around and you’ll find that most businesses making the switch are goi

(Paul Dubois) In our third and final article covering MySQL security, you will learn about client access control. There are exercises included (with answers) so you can test yourself on what you learned.

(Mike Hillyer) Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a

After you have mastered the basics of MySQL, it’s time to take the next step and take on Aggregate Functions. Before we talk about what they are, let’s review the definition of aggregate, as it relates to MySQL.

(Barry L. Kline) Collaboration isn’t a new idea, and (almost) everyone will agree that the greatest accomplishments come through its employment. We have only to look at NASA’s quest for the moon to see the perfect example. While the early space pioneers had a struggle with the manual exchange of pap