Steve,

Yes I agree it's a hole (rather than a 'feature'), and as you suggest, not too dangerous on its home turf of the database server, if security is up to...

Macbook Pro. Parallels and Boot Camp to run windows. Never going back.

My experiences with all PCs, not just laptops, is given that models are obsolete in 18 months,...

Yeah, thanks Gail.

I was impressed by your two-people-and-bios-password story. What occurred to me when i read it was that although on first glance it sounds over the top, it's...

{edit: I only read the first page of replies before I wrote this, TravisDBA and others have already commented on the salient points so take it as the silly comment...

Sad thing is, I have come to expect this kind of thing. It's a case of searching for the rare company that doesn't do it rather than avoiding ones...

I've got a solution to the 'undocumented' aspect:

(1) write two SQL solutions to solve the problem, one using 'quirky update' and the other using <insert documented method preference here>. ...

Superlative. As usual, you make a highly complex and conditional task look simple and straightforward by precisely covering key points. I am now not afraid to try using this...

I apologise if I misrepresent the more sophisticated ORMs, Daniel, I haven't used NHibernate.

I do use several ORMs regularly (I like Subsonic, partly because it doesn't even attempt to solve...

Re the pipe, have you read Rocky Lhotka's C# Business Objects 'Chapter 1 - Distributed Architecture'.

(sorry about this:)

http://books.google.com.au/books?id=6OkTWMLg71IC&pg=PA1&lpg=PA1&dq=%22logical+and+physical+architecture%22&source=bl&ots=9U2PFQz0gq&sig=iNcwGbgXKw55F9O2npFvKLD1bSI&hl=en&ei=nQXnStucJNaCkAXZ5oTBBg&sa=X&oi=book_result&ct=result&resnum=2&ved=0CA4Q6AEwAQ#v=onepage&q=%22logical%20and%20physical%20architecture%22&f=false

I thought I knew about Distributed Architecture, but read this (just...

Great example, Jeff. You've put your finger on the point I think is the essential element of the great 'programmer vs DBA contention' (aka 'the database-object impedance mismatch').

Programmers LOVE...

Having had a quick read over this, I'd like to mention two great (and free!) ORMs for .NET. A bit OT perhaps, but there is a lot of discussion...

Matt Whitfield (9/14/2009)

---

I'm not going to shove it down your throat because I get a bit over-whelmed by it all really - especially with coding - you post a simple...

Matt - no I hadn't waded through all the pages, but I just did and have to say your little script is a keeper ! It makes my solution...

Just one note for the naysayers. This relates to the OP.

I LIKE using SELECT *, since it allows full table data to be funnelled seamlessly up (along ?) through...

Jeff

Example of dynamic SQL forcing global cursor (this one is from a metafunction library, but it demonstrates the idea).

exec sp_lib_KillCursor 'fetch_cursor'

SELECT @s-2 = 'DECLARE...