TomThomson (1/1/2016)

---

Nice question. The longest hash had to be correct, so it was rather easy (counting the characters to check there were actually 64 was the only hard part).

But...

Apologies, everyone. I was reusing a table for the question and must have altered the structure for another question, and was thinking I had an OrderStatus here.

I've awarded back points,...

Nope, Hilton only, but I just expect to get hit at some point.

Short answer, look at the backup sizes and determine which one is adding data the quickest.

The first thing is probably to fail over to the secondary somehow. Then determine what caused the suspect state. Have you checked the error log?

Fail back will require moving backups...

I'm not sure that's capable. More just "able".

Or just it's doing some math,...

TomThomson (12/24/2015)

---

I thought "nice easy question for Christmas Eve" and then I saw the number of wrong answers and was surprised. Default login mapping is something I thought...

Date math is hard

http://www.seattletimes.com/seattle-news/politics/inslee-error-releases-inmates-early-since-2002/

phonetictalk (12/24/2015)

---

Was it due to pressure, or was it due to a lack of experience/knowledge? I've seen entire IT departments that have lacked skills in certain areas, simply because no-one...

Lempster (12/24/2015)

---

It's what is known as Technical Debt isn't it? Rightly or wrongly (and I would suggest wrongly) it usually comes down to a question of money, i.e. how much...

loyd.gravitt (12/23/2015)

---

Here is the way the problem usually develops

1) Developers begin developing an application and use sa on their personal copy of mssql.

2) DBA warns the developers that once they...

Well, I didn't shoot anything lately, but I spent 3 days with my kid on the Space coast.

As a bonus, we were standing on the causeway in Port Canaveral Mon...

It would be good to see some test data and what you're thinking is the issue.

A few things for testing. First, I'd mock up a test to look for specific...

Most likely misunderstanding. Someone might have taken a new transaction log backup at the same time, or had a job that did both and didn't realize it's the log backup...

Eric M Russell (12/21/2015)

---

I think the whole concept of a 'SA' account is a bad idea, because essentially it's an account which has full access and which can be sharable...