Abi Chapagai (2/11/2011)

---

Good question though I got it wrong. I thought i would be able to move the resource database in SQL Server 2008. After i got it wrong, i...

That URI indicates to me that you have help set up to use local help first. One of the major pitfalls of doing that is...

SanDroid (2/7/2011)

---

Are you talking about the fact that they have to be stored in plain text in connection strings that are at...

James Stephens (1/31/2011)

---

Hi,

Great article. On the same general topic but stepping back to the part about getting the AD data into tables:

It's 2011. Why the heck doesn't Microsoft...

kenambrose (1/25/2011)

---

People are smart enough to realize, once you explian it to them properly, that some intellectual effort and rigour is needed to do the job well. They don't...

kenambrose (1/24/2011)

---

<< If you hit the average business user with your training, they're not coming to the second session.>>

Not been my experience, and I just finished a contract at SLAC...

mike_walsh (1/18/2011)

---

This is quite possibly one of the best technical articles for a wide audience that I have read in a long time, Paul. To anyone who is already well...

Carlo Romagnano (12/31/2010)

---

Here a real situation for using local variable in the update statement.

Carlo,

I'm curious as to the context of your code (not included here for brevity and because...

Gianluca Sartori (12/30/2010)

---

When first name is null and middle name is not null, the second part of the or expression...

SQLkiwi (12/30/2010)

---

Yes, but Gianluca wasn't to know that. You might have been asking a sensible question, rather than just making...

magarity kerns (12/30/2010)

---

Excellent article - For more fun, check other DBMSes. I checked on Oracle and "select 'A' from dual where 1=0 or 1/0 = 1;" gives a division by...

Daniel Ruehle (12/30/2010)

---

... case

when Age > 90 then 1

when Age < 5 then 0

when Gender =...

Gianluca Sartori (12/30/2010)

---

sknox (12/30/2010)

---

So under what circumstances can you short-circuit an XOR? (i.e, if either A or B but...

This is how it should happen in any version of SQL server or any SQL database system. This is because SQL is declarative, not procedural. The difference is in the...

So under what circumstances can you short-circuit an XOR? (i.e, if either A or B but not both then...