Hope you enjoy Oslo, Norway. I was able to relocate there for the company I worked for 4 years ago. It was also my longest business trip before I decided...

MMartin1 (8/25/2016)

---

I think overweighting the size portion is not taking into consideration the many benefits of the denormalised model when it comes to reporting, and can gravitate ones thinking away...

RonKyle (8/25/2016)

---

No, it's not. Chances are independent dimensions when the items would be an attribute...

RonKyle (8/25/2016)

---

We can provide general guidelines, but you're the one with the data, so you have to make some judgements. ...

I feel the operational roles are going to be harder to keep due to outsorcing and automation. Being the guy who just monitors and restores backups are becoming the minimal...

chrisn-585491 (8/23/2016)

---

I'm not really seeing the benefit to this outside of sharing existing code across platforms. Outside of that, there is no point to use this on Linux if you're...

I'm not really seeing the benefit to this outside of sharing existing code across platforms. Outside of that, there is no point to use this on Linux if you're starting...

RonKyle (8/22/2016)

---

If the same product has multiple colors and sizes, then obviously you will have redundant data for ProductName. You may want to address that by splitting out color and...

ps_vbdev (8/22/2016)

---

Great reply thanks.

I was thinking exactly the two options you mentioned. I was even thinking my table structure would be the cases when you go to a snowflak structure.,...

thomashohner (8/18/2016)

---

It's mainly a performance reason. I thought filtered index works best with columns with columns with a lot of NULLS and would a filtered index get used by the...

At the top level, you may want to absorb the primary keys from the source system for validation purposes only and generate your own primary keys based on the source...

Indeed, I use SQL Prompt on a daily basis. Very handy tool.

Junior should really only apply to experience, not just a subset of tasks from a Senior.

Juniors should be able to do everything a Senior can do over time. If...

I personally use Python over bash in Linux environments. I still find it simple yet more powerful because there are modules available that enhance the ETL pipeline in many ways,...

Dang no one has some experience to share? 😀