I can see now this thread is going to get a lot of comment. This is one niche application where I'd suggest Hadoop and HiveSQL.

As far as doing this...

Comparing the IT department to a utility company may not be accurate for most organizations, but at least it's not as demeaning as comparing IT to a sausage factory. ...

Yes,...

Brian J. Parker (1/21/2015)

---

Eric M Russell (1/21/2015)

---

For those of us in IT, I'm not sure if we need Big Brother standing up for us on the playground; we can vote...

Steve Jones - SSC Editor (1/21/2015)

---

Eric M Russell (1/21/2015)

---

I don't take offense if I'm called after work, so long as it's regarding something that's broke in production. The way I...

I don't take offense if I'm called after work, so long as it's regarding something that's broke in production. The way I see it, if I done by due dilligence,...

ProductID, ProductId, and product_id are all respectable options, so long as it's done consistently.

However, I would take issue with ID by itself, on every table. Anytime I see that,...

The data model of a database is like the foundation of skyscraper. It defines the scope, constraints, and scalability of the database. Get it wrong, and your SQL and data...

alanspeckman (1/20/2015)

---

Is there a DMV that will give me a rate-of-change on a database, amount of log data generated over a period of time?

I need a quick way of showing...

Sean Lange (1/20/2015)

---

Eric M Russell (1/20/2015)

---

I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used for...

Steve Jones - SSC Editor (1/20/2015)

---

david.gugg (1/20/2015)

---

We're on 2008 R2 Enterprise at my shop and we've cancelled plans to upgrade to 2012 because of the costs. Once Microsoft stops...

I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used for clarity. Also, I don't have...

An Enterprise license for SQL Server can cost 100k to upgrade, but each full time DBA or developer on staff costs 100k per year, even if they're working with a...

Indianrock (1/20/2015)

---

We have a number of Sql 2008 and Sql 2012 Enterprise installations, but I recently saw our company take some serious steps towards Linux/Python/Java/DB2.

We have huge mix of platforms...

I'm sure the folks in Microsofts accounting department took Econ 101 while in university. If enterprise level customers keep switching to other database platforms primarily on the basis of SQL...