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...

Cast to string, check if it's 1 character, and if so, add a "0".

It returns a number. "01" is not a number, according to western math.

Do you mean database backup only and not server backup?

Pretty much everything is stored inside SQL Server. If you restore master and msdb, you have covered all the issues with...

I say B. always better to keep your process and add to it, IMHO

It's mostly a visual language where you connect tasks on a designer and make property adjustments. Many of the scripting items have helpers that let you "build" an expression. however...

We'd like to see you make an attempt. Basically you are attempting a cross tab, so if you search for help there, that might work for you. Or look at...