Archives de
Mois : février 2022

SQL Index and co.

SQL Index and co.

In research progress in development, we need to have a good structure of our DataBase. Today I will show you the importance of a great organisation in your Data! His name is “index”. First of all, what are the basics of this idea? Based on: … What that: Structured Query Language (SQL). What for? Permit a communication with the database. How? Allow to write scripts. Ok, now we can begin : First of all: How to use index? To fully understand…

Lire la suite Lire la suite

Data Protections.

Data Protections.

In research progress in development, you must keep in mind the protection for your data. Today i will show you dependency of protetcions. It has a lot of name, because it has a lot of breaches. First of all, what are the basics of this idea ? Based on : Here I use SQL langage What that : It’s a langage uses to manipulate database. What for ? It’s to create and manipulate information. How ? With scripts and that’s why it’s dangerous. Ok, now…

Lire la suite Lire la suite

PHP Prepared Statement – a practical approach

PHP Prepared Statement – a practical approach

In this article, I will show you about the PHP prepared statements in PDO, their avantages and how to use them effectively. What is PHP prepared statements in PHP? Prepared statements for executing a plurality of the same SQL statement, when a database server executes a query, it goes through two main phases: preparation and execution. Preparation – the database server checks the syntax of the SQL statement and initializes internal server resources for the execution stage. Execution – the…

Lire la suite Lire la suite

Microsoft SQL Server

Microsoft SQL Server

What is Microsoft SQL Server used for? Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. Is SQL Server from Microsoft? Microsoft SQL Server is a relational database management system developed by Microsoft. Today SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation in performance, security, and availability. The rise of data represents a tremendous opportunity and also poses challenges. Companies…

Lire la suite Lire la suite