Zend Framework – Moving your database connection outside of the application.ini file
Why would someone want to place their database connection settings within the unsecured application.ini configuration file? Why this is the default setting is beyond my own logic as it gives your users an open door to easily access and destroy your back office storage. Moving your database configuration settings to an external PHP file is [...]
Installing MySQL Server on CentOS
MySQL is the commonly used relational database system when developing websites using PHP although it can be used with just about any other language including ASP, VB.NET, C#, C++, Python, and even ROR. By default on install MySQL provides its own command line tool for accessing and manipulating its databases and tables. There are also [...]
Microsoft SQL Server DTS Packages
DTS packages were discontinued with the release of MS SQL Server 2005 and replaced with “SQL Server Integration Services” but some organizations still make use of SQL Server versions previous to 2005. DTS packages allow for the transformation and transfer of data from one database server to another or from one database to another database [...]
Using SQL Select Statements – A Primer
Structured Query Language (SQL) select statements allows the user to select a collection of data from a database table while interacting with a DBMS or RDBMS. Typically when a user would want to retrieve data from the database they would run a SQL query statement against the request data-set. A database is used for just [...]

