Newsletter signup (with exclusive discounts): https://signup.iamtimcorey.com/ (your email will be kept safe and you will not be spammed).
Facebook Page:   / iamtimcorey  

Want to see a full C# application built from scratch?
Check out this course: https://iamtimcorey.com/courses/cshar...

Microsoft SQL can be confusing. There are a TON of features, options, and settings to consider when attempting to use it. One of my favorite features is stored procedures. These precompiled queries allow you to safely and securely access and modify data. In this video, you will learn the basics of how to build a stored procedure, as well as what the benefits and drawbacks of stored procedures are. You will also learn some best practices, including how to secure your entire database in just a few simple commands.

Thanks to Ralfs HBK for timestamping the video:
0:00 Intro
1:12 Demo Data Base overview
2:00 Creating new stored procedure
7:35 Calling the stored procedure
10:11 Changing existing stored procedure
11:12 Stored procedure with variables
16:51 Stored procedures: Recap
19:54 Benefits of stored procedures: Security
22:57 DB security: Users and Roles
32:49 Other benefits of stored procedures
34:18 Drawbacks: No source control
37:36 Drawbacks: Business logic in DB
41:48 Drawbacks: Using Entity Framework
43:26 Summary and concluding remarks