FYI: I just got accepted to speak at the 2017 Grace Hopper Conference about Careers in Database Administration. I'm doing the Student Opportunity Labs section of the conference. It's in...

Sorry, John. I live in the 50 States but did not win a $10 gift card, so I'm the wrong person to ask on both counts.

On the other...

To add on to what the others are saying, all variable columns NVARCHAR and VARCHAR have an additional overhead added to the length you've give them. I believe (Lynn, correct...

The reason Gail is asking for the table definition (as in the CREATE TABLE & CREATE INDEX statements) is because we can add up the data types and lengths to...

My boss broke SQL Server Database Mirroring.

Well, actually, he's just getting errors when creating a database mirror and asked me to assist, but I really really wanted to...

Yeah. It was nice that not only was IT able to come to the same place, but we were able to convince the BU management teams that this was for...

Is this a production database or non-production? If non-production, do you have another backup with which you can test to see if the same thing happens?

This is a hard one. All the possibilities I can think of that would cause a DB restore to fail would throw different messages.

How about putting a...

GAH. Not awake this morning.

Made a recent change to code and am now unit testing. The change should have been invisible. Instead, I'm suddenly coming up with 552...

Regarding testing, we used to have some business users (back in 2005 thru about 2008) who would just click the APPROVE button on the testing emails we would send out...

Where have you been checking for errors?

Verify both the SQL Server logs and the Event Viewer Application / System logs for the times in question.

Are...

Hey, now. Who decided RedGate people could get praised on a RedGate board?

@=)