Interesting.

When I deny connect permission to a login and then refresh the view in ssms I get no little red arrows. Maybe it only happens for users...

Interesting question.

It's fairly straightforward provided one eliminates the obviously wrong options rather than looking for an obviously right one - I've never used this transform (SSIS is not...

Nice question.

A very odd statement in the explanation though: "Tinyint is only 2 bytes". No it isn't, it's only 1 byte. Perhaps it meant to say "only 2...

Good question. I like all those "Param ($databaseName)" red herrings. As my powerscript knowledge is pretty close to nil, they made me struggle to understand what was going...

That seems...

Koen Verbeeck (7/10/2014)

---

Jack Corbett (7/10/2014)

---

Koen Verbeeck (7/10/2014)

---

So I tried to endorse Jeff on LinkedIn for BCP, but somehow it doesn't work.

I saw Jeff was endorsed 9 times for...

Ed Wagner (7/9/2014)

---

The part I don't get about people asking for help and then using solutions they don't understand is about support. What if something goes wrong? What...

Armstrong

Good question, and teh correct answer is right (unlike quite a few QotDs). But I have a niggle about the explanation.

Clearly the conversion of @intB to bigint in line 4...

ring

excess

Nice question.

I hadn't seen Itzik Ben-Gan's "take control of joins" before. It's an interesting note. But it's rather flawed, and it's going to confuse people and...

I looked at that and wondered what the catch was. But all the values are the same, so all the queries have to deliver the same result, and there's...

Singer

Good question. Managed to get it wrong by not noticing that decimal wasn't decimal(7,2). Probably wouldn't have got it right even if I'd noticed.

There seems to...