Having worked in DIACAP environments, the answer is definitely "it depends".

Part of the government SQL Server lockdowns requires revoking CONNECT to guest for all databases, including system databases.

Any...

Luis Cazares (9/19/2013)

---

There's not an "official" version. However, the expected version is the current version (2012 at the moment) and 2 previous major versions (2005 and 2008).

The question might...

SQL 2008 is the "official" version assumed for QOTD.

However, I still run into SQL 2005 regularly. The licensing structure changed significantly from 2005 --> 2008, making the change prohibitive...

mtassin (9/16/2013)

---

Good... so rather than googling myself to death trying to come up with the correct term.

I believe it's because of the IF/THEN that we see this.

SQL Processes both branches...

You guys certainly have an interesting definition of what defines "basics".

I don't think an undocumented feature of the ALTER TRIGGER functionality qualifies as "basics".

L' Eomot Inversé (8/30/2013)

---

An nice amusing question that demonstrates an unfortunate feature of SQL - using contractions is not a habit I would like to get into. so a...

Thomas Abraham (8/26/2013)

---

Thanks for the Monday question. I was happy to begin the week with a question that didn't start with "When can normalising ...". 🙂

As for "Jeff.MSSqlSage", well, then...

... what ?...

That's a long sentence.

The first rule about 70-448

is you do not talk about 70-448

Sean Lange (8/13/2013)

---

You do know that this violates the agreement for the exam right? Your page discusses exam content with things like the percentages of questions...

Part 1

Part 2

Part 3

Sean Lange (7/24/2013)

---

Hugo Kornelis (7/24/2013)

---

Since I was unaware of the effect of ALTER VIEW on an indexed view, I decided to check if it's documented. Turns out it is, in...