I agree with Jeff. You want to be careful with KILL. I've had it work 99% of the time, but that 1% can be really, really annoying and a killer.

Instead,...

djackson 22568 (11/11/2013)

---

I think I am the one who is having difficulty describing my point. Let me do it another way. If we take an example...

Gary Varga (11/11/2013)

---

Steve, sorry but I disagree. Yes, examples should be complete including best security practices where appropriate, however, it does have an impact on effort. Security needs planning, design...

I'd still argue this is more an internal developer professionalism issue more than a business case.

We, as people that teach and help others, need to present good examples and...

Jeff Moden (11/8/2013)

---

But "good enough" frequently means that something simply works for 5 or 10 rows and they ship it and that ain't "right". 😉 "Good enough" frequently means...

Ed Wagner (11/8/2013)

---

You know, thinking about this some more, it really is a shame we aren't more honest and transparent as a whole. I wonder what this says about...

both Ed and Gail have given good resources.

the other thing I'd suggest is that you create a test copy of your db, run some queries, add indexes, and re-run them....

What's "right"?

Jeff, overall I agree that we should...

roger.plowman (11/8/2013)

---

And that's why "good enough" leads to HealthCare.gov type solutions. Sure, you can have bad developers who don't understand all the parts of the system and why certain approaches...

It's not working for me either. No idea why. I've submitted a bug.

Interesting. Wonder what some you think?

https://www.schneier.com/blog/archives/2013/11/why_the_governm.html

Thanks. It was crazy, fun, and exhausting.

If it's a PK, you can't have a violation. However, not sure if values are reused.

There are no grants for encrypting/decrypting data. This is controlled when a user can open a key that performs the function. This could be in a stored proc or with...

GilaMonster (11/7/2013)

---

No, I really do mean backup.

If you try a RESTORE LOG on a database that's online, all you'll get is an error (no files are ready to roll forward),...