THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » stored procedures   (RSS)
  • Trick Question – Part Två

    This post is part two of an effort to examine, in brief, the decisions entailed in designing the interface between database and application. We’re in a strange place at this moment, where both the possibilities and the liabilities of techniques like ORM have come to a head, and it seems vital to go into data tier design at least equipped with all ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on October 24, 2009
  • Parameters, Perms and Procs: Are You Really Protected from Injection?

    In my last post, Top 10 T-SQL Code Smells, I caught some flack got some feedback for including one (#3) about the use of Stored Procedures for Select statements. Several people expressed objections over the risk of SQL Injection, and how Stored Procs would prevent it, but some of the correspondence I've gotten made me worry that, perhaps, some of ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on August 24, 2009
  • Yet Another Stored Procedure vs. Ad-hoc Query Discussion?

    Earlier today, Will Sullivan posted a blog entry, My Statement on Stored Procedures, in which he emphatically states his official opinion of stored procedures as: ''I prefer not to use them.'' He then goes about dismissing most of the misinformation about why stored procedures are better than ad-hoc (parameterized) queries. The first bit of ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on April 3, 2008
Privacy Statement