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.
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!
Bob, we love the videos – good presentation & pace. They’re a great way to help beginners get up to speed quickly.Mark Jewett , Senior Manager
SQL Server, Microsoft Corporation
1 Year Membership
(it’s about $6 a month)
- Watch hundreds of screencasts
- New training each week
- Stream instantly via Vimeo … even works on iOS (and *some* Android devices)!
- Download source code
$200pay just once
keep learning new .NET stuff
- 1 Year benefits, plus …
- Download video files to keep. Powered by Amazon S3 (blazing fast).
- Q & A Get answers to your questions about the videos