Sorry, I don't have a cool better way of solving this issue.

LOL.   Not sure there's a cool way to solve it!

Regarding the developer AD group: Do you grant it those...

Great article!  I've implemented similar mechanisms and also solved the backup security problem (how to avoid granting backup/restore rights to developers) by polling a status table from a Server Agent...

I wrote a similar script and I used a wait loop to display encryption progress every 2 seconds.  I found it helpful when encrypting large databases so I can tell...

patrickmcginnis59 10839 (7/6/2015)

---

Again I am not sure why Oracle can make their PL/SQL using cursors as fast as set based operations and MS cannot. Cursors are not evil, and not...

You are correct. If you scroll up to Jeff's reply to Hugo you'll see he mentions that usage of cursors.

An alternative to granting select on the dbo schema could...

Hmm...

DECLARE

@sql NVARCHAR(4000),

@RoleName VARCHAR(25) ='valuation_exec';

set @sql = 'GRANT EXECUTE on Schema::dbo to ' + @RoleName

execute sp_executesql @sql

set @sql = 'GRANT SELECT on...

fundpc (6/2/2015)

---

...and yes I am old enough to have been there when our IBM RD281 disk pack, read heads driven with hydraulic rams, blew a packing and saturated the...

@james Stephens

Got it! I agree with you. My apologies for the snide remarks, earlier. If an sp is run once a year and it loops through...

James Stephens (6/1/2015)

I think you grossly misunderstood my point. I was not saying that all set based operations should be replaced by cursor-loops. My point could be distilled...

Jeff Moden (6/1/2015)

---

While I appreciate the hair the author had to say that not all cursors are bad, I find this article woefully short of any meat on the subject....

Nakul Vachhrajani (9/16/2012)

---

It may be appealing to most developers to directly update the system tables because of the adrenalin rush associated with working directly at the root level, but it...

@ Ron:

I go pretty far back with SQL server too, and would never have even considered using "while not exists" over a "left join" to retrieve orphans until I skeptically...