For developers familiar with MySQL, you've probably heard that MariaDB is the next generation of the database engine. MySQL has long been the traditional database in Linux, Apache, MySQL, and PHP ...
Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But this month's column will ...
Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...
Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or SSIS, allows you to extract data ...