postal

Nothung

Hugo Kornelis (4/13/2012)

---

L' Eomot Inversé (4/13/2012)

---

If Steve is right about login checking for a login in master first even when the contained database is specified in the connection parameters we...

Hugo Kornelis (4/12/2012)

---

You...

Steve Jones - SSC Editor (4/12/2012)

---

The AD Credential thing is interesting. If there are matching AD credentials at the instance level, the authentication takes place there first, which makes sense....

Nice interesting question.

Some of the discussion makes me want to comment, because it seems ill-advised - but I'll do a bit more reading first, as my knowledge of...

Lynn Pettis (4/11/2012)

---

Please, someone tell me why, just why do I keep helping someone who...

A good question, thanks.

I can't agree with the comment in the explanation about protection for filestream data when the rest of the data is protected by TDE mandated by regulation....

It looks quite reasonable; presumably the data table is intended to have have (dateId,siteid) as primary key?

I would be inclined to use SQL date datatype, not any string like "28/10/2011",...

Lynn Pettis (4/10/2012)

---

Brandie Tarvin (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

Brandie Tarvin (4/10/2012)

---

Stefan Krzywicki (4/10/2012)

---

I just registered for the SQL Server Saturday in Waltham in May. At the end is the ubiquitous "captcha" to...

opc.three (4/9/2012)

---

L' Eomot Inversé (4/9/2012)

---

Jeff Moden (4/8/2012)

---

I prefer they both be NOT NULL and, like Gail identified, will make both the same on INSERT. I also use a trigger...

Someone has got a "stuck in recovery" problem here. I could try to answer but I am not nearly as competent as several other threadizens in this area, so...

The edits suggested by Mark are fine where there's no obvious way of getting the correct value, but I imagine that before doing what he suggests it might be a...

bitbucket-25253 (4/10/2012)

---

Not as easy as I thought it would be:

Since one of the major objectives of the QOD is...

Jeff Moden (4/8/2012)

---

I prefer they both be NOT NULL and, like Gail identified, will make both the same on INSERT. I also use a trigger to enforce updates to...