Jaro winkler and levenshtein: the right to make mistake
When you do a search on a search engine, you have probably already made a typo, or reversed two letters.
Read more
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, and some important foundations
Read more
PHP7 migration: The SQL Server case
Currently testing a migration to PHP7 (from PHP5.5), I noticed that the management of connections to SQL Server via the
Read more
Use MySQL functions, triggers and stored procedures
Using MySQL functions, triggers, and stored procedures has many advantages, but also some challenges. We will detail these different points,
Read more
Explain: MySQL query optimization
There is a tool integrated into MySQL which makes it possible to obtain very interesting information, and which will give
Read more
MySQL cursor: Loop over a recordset
If you use MySQL stored procedures a lot, you probably needed to loop over a recordset to process a dataset.
Read more
SSIS: call a package from a PHP page
We work a lot with SQL Server and the related software suite (SSIS, SSRS in particular, in version 2008 R2).
Read more
MySQL, find records containing an escape character
A quick article for a question I had to ask myself recently. How to make in MySQL to return all
Read more
MySQL replication: implementation and points to check
MySQL replication is relatively simple to set up, there are still a few points not to be overlooked and to
Read more
Null Values on the Fetch of a MySQL Cursor
Here’s a little topo on having, from time to time, null values in the Fetch of a MySQL cursor. While
Read more
MySQL definer and Sql Security Invoker – Security of stored procedures
One of your DBAs, or one of your developers creating stored procedures is gone. You want to delete his MySQL
Read more
MySQL CONCAT, encoding and null values
I recently came across two behaviors of the MySQL CONCAT function which caused me problems with encoding and null values.
Read more