Skip to content

Arnaud Guignant

Web and technique(s)

  • Folders
  • Dev and databases
  • Cryptocurrencies
  • Do it yourself !
  • News and technology
  • Vintage
  • Français
  • Español

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.

Recherche
Databases, MySQL, SQL Server, NoSQL Development and databases 

Jaro winkler and levenshtein: the right to make mistake

4 October 202128 March 2022 Arnaud Guignant 0 Comments

When you do a search on a search engine, you have probably already made a typo, or reversed two letters.

Read more
Logo SQL Server
Databases, MySQL, SQL Server, NoSQL 

SQL Server: Know the progress of a Shrink

4 January 201730 March 2022 Arnaud Guignant 0 Comments

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

Read more
Logo PHP PHP7
Databases, MySQL, SQL Server, NoSQL Development and databases 

PHP7 migration: The SQL Server case

9 October 201630 March 2022 Arnaud Guignant 0 Comments

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

Read more
Version fichiers SQL avec Git et SourceTree
Databases, MySQL, SQL Server, NoSQL Development and databases 

Use MySQL functions, triggers and stored procedures

13 September 201630 March 2022 Arnaud Guignant 0 Comments

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

Read more
Explain MySQL résultat
Databases, MySQL, SQL Server, NoSQL 

Explain: MySQL query optimization

12 September 201631 March 2022 Arnaud Guignant 0 Comments

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

Read more
Logo MySQL
Databases, MySQL, SQL Server, NoSQL 

MySQL cursor: Loop over a recordset

23 June 201630 March 2022 Arnaud Guignant 1 Comment

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

Read more
Logo SQL Server
Databases, MySQL, SQL Server, NoSQL Development and databases 

SSIS: call a package from a PHP page

20 June 201630 March 2022 Arnaud Guignant 0 Comments

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

Read more
Logo MySQL
Databases, MySQL, SQL Server, NoSQL 

MySQL, find records containing an escape character

16 February 201630 March 2022 Arnaud Guignant 0 Comments

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

Read more
Logo MySQL
Databases, MySQL, SQL Server, NoSQL 

MySQL replication: implementation and points to check

12 November 201530 March 2022 Arnaud Guignant 0 Comments

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

Read more
Logo MySQL
Databases, MySQL, SQL Server, NoSQL 

Null Values ​​on the Fetch of a MySQL Cursor

8 May 201530 March 2022 Arnaud Guignant 1 Comment

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

Read more
Logo MySQL
Databases, MySQL, SQL Server, NoSQL 

MySQL definer and Sql Security Invoker – Security of stored procedures

3 July 201330 March 2022 Arnaud Guignant 0 Comments

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

Read more
Logo MySQL
Databases, MySQL, SQL Server, NoSQL 

MySQL CONCAT, encoding and null values

10 April 201329 March 2022 Arnaud Guignant 0 Comments

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

Read more

Search

Populars posts

  • Building your arcade cabinet: from project to completion
  • List and create symbolic links in Linux
  • List files in a Linux folder by ascending date
  • Jeedom: your first steps in home automation
  • SonarQube: study of code quality

Abonnez-vous à ce blog par e-mail.

Saisissez votre adresse e-mail pour vous abonner à ce blog et recevoir une notification de chaque nouvel article par e-mail.

Random post

  • Null Values ​​on the Fetch of a MySQL Cursor
  • MySQL CONCAT, encoding and null values
  • List and create symbolic links in Linux
  • Automatic changelog with Git
  • MySQL definer and Sql Security Invoker – Security of stored procedures

Site categories

  • Folders
  • Dev and databases
  • Cryptocurrencies
  • Do it yourself !
  • News and technology
  • Vintage
  • Français
  • Español

Search

Categories

  • Cryptocurrencies
  • Development and databases
    • Databases, MySQL, SQL Server, NoSQL
    • Linux, Apache, System, Shell
  • Do it yourself !
  • Folders
  • Front articles
  • News and technology
  • Vintage

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Random post

  • MySQL CONCAT, encoding and null values
  • Jira: Project management and bugtracker
  • MySQL, find records containing an escape character
  • Sorare: start well and progress, the tutorial
  • 3D printer: from assembly to the first successful print
Copyright © 2023 Arnaud Guignant. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.