I think this editorial seems a bit confused, data loss is just one sort of data breach, revealing secret or confidential data is another very different kind of data...

BWFC (6/13/2016)

---

I've got my name down so I should be there. The pre-holiday shopping trip...

A nice easy JSON question to start the week - very different from last weeks start with a difficult JSON question where there appears to be no MS documentation covering...

Nice question and nice clear explanation. The third easy question in a row.

I was surprised to see how many got it wrong so far (more than 200...

Pinchpenny

It's handled...

Hugo Kornelis (6/7/2016)

---

GilaMonster (6/7/2016)

---

What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send...

I read the latest version of the "correct" answer again, and it's rather amusing.

if we start with two statements and the first is not terminated by a semicolon,...

Sean Lange (6/7/2016)

---

tom.w.brannon (6/7/2016)

---

The answer should be No. Open a new window and paste in the following and it works just fine:

with myCTE(n)

as

(select 1

)

select * from myCTE

No semicolons anywhere...

Good question.

After a hard one yesterday to start the week and an ambiguous (to say the least) one to end last week it was a nice change to get ...

In particular, it's not documented in the "good discussion...

Steve Jones - SSC Editor (6/3/2016)

---

We can be pedantic if we want. However, a batch consists of 1 or more statements. The option notes that the previous statement is not...

Steve Jones - SSC Editor (6/3/2016)

---

That's fine.

I'll still disagree as well. Given history and the way many samples are given, there is often this code:

...

; with mycTE()

...

I hope to bring...

I have to agree with Toreador and with Lynn. The option claimed to be correct is in fact incorrect. The only thing that can begin with a...

Quite an amusing question.

At first I thought there was no correct answer, and re-reading it didn't shed any light. But the second time I re-read...