Could it be that once you've restored it someone runs something that does an ALTER DATABASE to turn mirroring on the dev db?

Otherwise, I'm not sure. This shouldn't be an...

Probably

Rod at work (12/3/2015)

---

Argh!! Steve, please stop writing articles that interest me so much. Ones that I want to respond to. Believe me, I want to respond to this, but...

On the list

Can you not join to dm_exec_sessions here?

INNER JOIN sys.dm_exec_sessions AS des

ON des.session_id = r.session_id

Yes and no. We've almost always required a login, which helps us support the site, and I've been hearing this complaint for 15 years.

We are looking at some work to...

Last tie breaker is who beat Steve the most

My vote is you write this:

with mycte (col)

as

(select ...

);

If you get a syntax error because:

select mycol from mytable

with mycte (col)

as

(select ...

);

then you do this:

select mycol from mytable;

with mycte (col)

as

(select ...

);

I...

ditto.

I CTRL+B,...

Rod at work (12/2/2015)

---

Oh Steve, man have you said a lot here that I'd like to respond to. But I think prudence forebears me from saying everything I'd like to....

JustMarie (12/2/2015)

---

There's far too many companies that want a senior level person with a lot of experience only to make an offer that is more in line with a junior...

lnardozi 61862 (12/2/2015)

---

Here is the problem in a nutshell - salary opacity and salary equality.

Demigod of SQL = x$

Seat Filler = x$

Unfortunately, just as much money is allocated by management...

Sean Redmond (12/2/2015)

---

The qualities that I look for in interviewees are willingness to learn, ease with logical thought and thoroughness. Being able to the job quickly is good, too, but,...

Dalkeith (12/2/2015)

---

The older I get the more I realise the shear inefficiency of people's ability to communicate both what they want and what they can provide.

Certificates have in the past...

This...