There are many ways to access and modify your SQL Server data including ADO, ORMs and ad hoc SQL embedded in application code. Successful, robust applications have been created using all of these methods. In this session I lay out 10 points for the argument that the overall best way to access your data is with the stored procedure.
Dale Burnett is a database administrator at Dude Solutions specializing in SQL Server. He has been working with databases since 1998 and exclusively with SQL Server since 2008. His previous experiences provided exposure to many industries including financial services, retail, insurance, and customer service. His primary SQL Server interests are architecture and optimization.