On Wed, May 27, 2015 at 12:03 PM, Kurt Wendt <[email protected]> wrote:
> Stephen - if your Database is Talking to you - maybe its truly time for > You to talk to a Shrink!!! > > :-) > > All kidding aside. I know there is this whole argument about keep business > rules away from the Database - even though, in many cases - people > implement them within Stored Procedures. Which means the rules get tied to > the data. But, I know this is a Very Intense argument that a lot of folks > argue over. So - sorry if I am just adding to the flame war about Data vs. > Program code... > ------ I have a shrink right here! :) DBCC SHRINKFILE (N'TheInvoices_log' , 0, TRUNCATEONLY) GO Running all CRUD operations through stored procedures protects you compared to having unsanitized input put into a dynamic script that is executed. But then it is your data and you can do what you want. < http://www.esecurityplanet.com/hackers/how-to-prevent-sql-injection-attacks.html > Having someone sneak this line into a mySQL sytem really sucks. -BNe "show tables" | awk '{print "set foreign_key_checks=0; drop table `" $1 "`;"}' -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmykbdqtyqxf9p07vmpbhvu-jdqk-tybgl+j5vc54gbu...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
