xsevensinzx (6/24/2016)

---

I think by far the biggest hurdle for me in designing a new data warehouse or even a new database is clearly outlining the ERD and all the ETL...

I've lost track of the number of database applications that I've built from scratch over the last 30 years. One thing is true though, I never got them completely...

Way back when I was in school (still in the days of green bar line printers) subjects like database theory, set theory, and...

Yes, you are correct that column references are repeated. I feel that those...

The use of APPLY is interesting and I did learn a couple of things, but in my opinion the CTE approach exemplified earlier is cleaner and easier to read especially...

It's not teaching the crutch, but teaching that the crutch is NOT NECESSARY.

Yes, it's a lazy approach that some...

That's what I do...

Terje Hermanseter (6/3/2016)

---

Too much old...

We've been told for some time (since 2005 I think) that semicolons were going...

Recce70 (3/15/2016)

---

As much as I look forwards to SQL Server being on Linix, I expect in 2017 forums covering aspects of the LAMP stack will be clogged up with posts...

😛

I also wonder how the technical hurdles would be accomplished as over the years SQL Server as been so tightly integrated with Windows that many of the services for SQL...

David Grover (2/25/2016)

---

There's an assumption that "dumping it into Hadoop" is the equivalent of "throwing junk mail on the pile for later" or "copying the contents of my desktop to...

I know that most of the "big data" pundits point to this as an example of just how great Hadoop is at being able quickly to store tons of data...