When you do a search on a search engine, you have probably already made a typo,…
Category: Databases, MySQL, SQL Server, NoSQL
Everything that revolves around the database, queries, stored procedures or triggers. Or even more recent issues such as big data, NoSQL and open data.
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…
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,…
MySQL, find records containing an escape character
A quick article for a question I had to ask myself recently. How to make in…
MySQL replication: implementation and points to check
MySQL replication is relatively simple to set up, there are still a few points not to…