Mistake of programmers in using SQL Server

Maybe you are someone who is still working with ADO.NET and directly sends your queries from Application to the Database.

Maybe you are someone who is still working with ADO.NET and directly sends your queries from Application to the Database.

If you do not do this correctly and send the Ad-Hoc Query to your database without any inconvenience, your programs will encounter two major problems.

1- SQL injection

2. Reduced database performance due to the execution of the Execution Plan for each of the queries

There are many ways to fix this. In this tutorial, we will examine the problems presented more precisely and describe the solutions to them.

The lessons you will learn in the educational film about this lesson include:

1- Review the concept of SQL Injection

2- Review the concept of Reuse (Reuse) of the Execution Plan

3. Familiar with the Execution Plan

4. Familiarity with the concept of compile queries

5. Familiar with DMV: sys.dm_exec_cached_plans

6. Familiarity with DMF: sys.dm_exec_sql_text

7. Familiarity with DMF: sys.dm_exec_query_plan

8. Meet the Cross Apply Operator

9. Understanding how to use SQL Parameter in applications