Nice article.

Since profiler traces are deprecated, did you attempt to do this with an extended event?

I believe that is the toy that Grant is playing with. Or was that a Surface?

Darn those picky details...

Orlando,

Thanks.

As much as I dislike using the length of the SID to differentiate orphaned users from loginless users, even MS in this blog post says that the only way to...

Umm, why yes, yes I did! :-D:-P:w00t:

Brandie Tarvin (5/13/2013)

---

So I'm thinking that this Workflow Logic for Kids is something I'd like to push to more than just our little community. Not only would it encourage children...

Brandie Tarvin (5/13/2013)

---

Threadzians, I could use some help with my own personal RBAR horror story here. It's not that we want to do RBAR, but that we really don't seem...

Brandie, Try this out:

-- Let's add a column to the staging table to make deletes easier. You could even index this if you want to.

-- However,...

I don't think that the QU is necessary here, though it would work.

Brandie - just to verify... you are using SQL 2008? (I know you posted it in this forum, but we both know that folks sometimes make mistakes...)

Wonderful writeup for an excellent exercise with the little ones! Great job (for both) Brandie!

Hi Orlando,

Nice article. However, I'm going to disagree with your method of looking at the length of the sid to determine whether this is a loginless user, or an orphaned...

True... but it would require timely feedback from those reviewing it before submission! :w00t::w00t:

Kenneth.Fisher (5/6/2013)

---

Nice job introducing SQLCMD. I spent several hours this weekend trying to write up an intro to SQLCMD myself. You did a much better job than I...

Steve Shurts (5/6/2013)

---

Very interesting... I just had to play and it was fun. However, I can't think of any clever usage for it, yet. But give me...