Databases, MySQL, SQL Server, NoSQL Archives

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.

When throwing a shrink database to a SQL Server database, there is no evidence of progression, and some important foundations

Currently testing a migration to PHP7 (from PHP5.5), I noticed that the management of connections to SQL Server via the

Using MySQL functions, triggers, and stored procedures has many advantages, but also some challenges. We will detail these different points,

There is a tool integrated into MySQL which makes it possible to obtain very interesting information, and which will give

If you use MySQL stored procedures a lot, you probably needed to loop over a recordset to process a dataset.

We work a lot with SQL Server and the related software suite (SSIS, SSRS in particular, in version 2008 R2).

A quick article for a question I had to ask myself recently. How to make in MySQL to return all

MySQL replication is relatively simple to set up, there are still a few points not to be overlooked and to

Here’s a little topo on having, from time to time, null values in the Fetch of a MySQL cursor. While

One of your DBAs, or one of your developers creating stored procedures is gone. You want to delete his MySQL

I recently came across two behaviors of the MySQL CONCAT function which caused me problems with encoding and null values.