It’s been a while since I wanted to do a sequel to my first article on…
SQL Server: Know the progress of a Shrink
When throwing a shrink database to a SQL Server database, there is no evidence of progression,…
PHP7 migration: The SQL Server case
Currently testing a migration to PHP7 (from PHP5.5), I noticed that the management of connections to…
List files in a Linux folder by ascending date
Want to display the files in a Linux folder sorted by date, with the oldest first…
Use MySQL functions, triggers and stored procedures
Using MySQL functions, triggers, and stored procedures has many advantages, but also some challenges. We will…
Explain: MySQL query optimization
There is a tool integrated into MySQL which makes it possible to obtain very interesting information,…
MySQL cursor: Loop over a recordset
If you use MySQL stored procedures a lot, you probably needed to loop over a recordset…
SSIS: call a package from a PHP page
We work a lot with SQL Server and the related software suite (SSIS, SSRS in particular,…
Jira: Project management and bugtracker
Several months ago, we decided to change tools for managing our projects and managing incidents and…