Writing Stored Procedures for Microsoft SQL Server focuses on teaching you not only how to build effective stored procedures, but also how to optimize and streamline them for long term use. Get an understanding of how SQL Server interprets stored procedures verses direct access via SQL queries. This is followed by detailed instructions on creating and maintaining a repository of stored procedures. Once you know how stored procedures are created and built, you are taught how to determine which logic within an application makes sense to be put into this scheme. Additionally, you're provided with guidance on making stored procedures that are portable across applications.
Matthew Shepker is an MCSE as well as a Microsoft Certified Trainer (MCT). He is a Microsoft SQL Server consultant and network integrator in Overland Park, Kansas. Matthew has been working with SQL Server for over 4 years in a variety of business applications including online.