In this video we continue our work in SQL Server 2008 Express Edition. We start with a brief conversation about the internals of query execution and query plans and how you can use SQL Server Stored Procedures to view and tweak query performance. Stored Procedures are also a mechanism used by DBA’s to control access to the underlying table data for certain groups of users. We talk about how some organizations choose to use Stored Procedures to encapsulate business rules that must be implemented across the entire organization (as opposed to using shared C# assemblies for this purpose) since stored procedures sit closest to the data. The fourth benefit is that it will relegate the job of data selection and other CRUD opertaions to the tool originally created for that purposes (SQL). We discuss how Microsoft provides many technologies to architect applications around an organizations preferences as well as their business and technical needs and how there is no “one right way” to architect an application (although there are many wrong ways!) This will set the stage for the rest of the day where we focus on writing T-SQL to create, update, remove and execute stored procedures in the SSMS.

« Previous Lesson — Visual C# 2010 Express Edition for Absolute Beginners — Next Lesson »

Watch a 1 Minute Preview of this Video

This is a short preview that demonstrates the quality of the screencasts we offer at LearnVisualStudio.NET.

Scroll down and click the play button in the lower-left hand corner of the video player to start watching.

The full length video is 13 Minutes, 27 Seconds and is available to LearnVisualStudio.NET members. Join today!