SQL Stored Procedures - What They Are, Best Practices, Security, and More...

Newsletter signup (with exclusive discounts): (your email will be kept safe and you will not be spammed). Facebook Page: Want to see a full C# application built from scratch? Check out this course: 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 pre-compiled 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