I love Edit Plus, using it on a daily basis for HTML and SQL stuff. I'll have to check out Portable Apps.

One other thing I've been doing is collapse things...

I have contacted the author to ask them to comment here (after reading all comments).

As far as the editorial policy, feel free to debate it here: http://www.sqlservercentral.com/Forums/Topic768655-83-1.aspx

I have added a note to the article to read the discussion that follows.

I, too, was amazed by the response to this. My initial thoughts were that the 10 people that enjoy math and SQL would jump in and most would ignore it,...

I haven't heard of changes in this code, but I know almost no one that backs up to tape directly. It's error prone, and asking for trouble as you reuse...

Yes, there is no issue with both versions.

check sys.database_principals in those databases. Is QC a user in there that is perhaps orphaned from a SID? Or sp_change_users_login with the report option.

There isn't any real best way to do this. You point at the new drives in the WITH MOVE statement and let it run. It should run a little quicker...

As far as experienced DBAs, we have had Brad look to tune things. The problem is the ORM layer isn't "tuneable" in that we can't specify the queries in some...

Excellent explanation, Paul. Perhaps we should have you writing XML articles 😉

I will sneak a picture of Jeff at some point and post it up here. Don't worry, we'll track him down at some point.

For quite a few businesses where I don't care about them tracking me, as in it's a one time purchase or I don't trust them, especially online, I give out...

I tend to like those businesses that just have cards that are punched. The QDoba one does take an email, and they periodically send me coupons (like for my Apr...

You'll need a subquery here, but you want to write this as a select. Find the rows with a null and then join that back and find the previous row.

We...