APPLY – all the time. I use a lot of table value functions in my code, and use CROSS APPLY with them. I’ve even used it in some...

This year I tracked Halloween, with the number of kids, and “random sampling” of the times that they showed up.

I use PARSENAME all the time: it’s in my quick “design patterns” toolkit that I dip into once in a while. In addition to an IPv4 address, I’ve used...

dmbaker (3/6/2014)

---

At the moment I would think the best approach would be is to design the database “correctly” and implement the GUI through something like MVC. Leave as much...

I think the fundamental issue that drives people to using EF and similar tools is a lack of understanding for relational data concepts. SQL is not OO, or anything...

below86 (2/28/2014)

---

paul.knibbs (2/28/2014)

---

Since video games are fair game for adaptation (they're even planning a Minecraft movie...words fail me :crazy:) I wouldn't mind seeing an adaptation of Planescape: Torment. It's one...

Steve Jones - SSC Editor (2/28/2014)

---

call.copse (2/28/2014)

---

I don't think it could be a movie - maybe a HBO show or something - but I'd love to see the Foundation series...

IMHO, it’s all about the roots of where relational database designs come from: set theory and relational algebra.

In the case of CREATE TABLE or ALTER TABLE, you are...

Nice job on explaining MDX; I look forward to the later installments.

Just out of curiosity, will you be addressing (via comparison) sets and tuples?

I agree with you there: I work for one of those large companies. ...

I would also suggest that telecom is a growing market for big data.

This should have been an April Fool's editorial; well with a little tweaking of content.

I find the approach taken to a book does more to learn the subject than volumes of content.

For example, years ago I was trying to learn C, and...

I use hash functions to generate a synthetic key; some people might call it a surrogate key, but I believe the proper phrase is synthetic. I currently use

keyField...

I agree, especially when you have diverse data sources.