Grant Fritchey (9/26/2016)

---

Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a valid...

This is a pretty large and broad topics, but here is just my high-level take.

There is nothing wrong with having a staging area that allows your transform and validate your...

I agree the business (not just the boss) has to know.

I proved this once when I accidentally screwed something up on a production server. I fixed it almost within minutes,...

I learned best from hiring a senior DBA with 10+ years on a project. How I got my boss to agree to this is by explaining that I was still...

Testing does no good if you can't dedicate time to fixing the issues before you release. In most cases I've experienced, releasing is still happening because of the agreed upon...

According to my co-workers, I'm the -1x Programmer, but in my mind, I'm the 100x Programmer. :hehe:

I feel the company I work for is becoming a technology based company, but at the heart we are in the digital marketing space as an agency that offers both...

ZZartin (9/15/2016)

---

I don't see data science as something you get a degree or certification in, it's a practical skill acquired through practice not through studying theory. And to actual...

Udemy is also a good resource. You get professionals who work in related fields trying to make extra cash who teach real-world examples there in various degrees of levels.

I work...

Everyone knows me to have a big mouth. I think some of you can tell that by the way I post here. Unfortunately, text does me no justice unless you...

Unless there are no other variables here with the destination table (i.e.: indexes, blocking, partitioning, etc), this shouldn't take that long either all at once or in batch under simple...

Steve Jones - SSC Editor (9/13/2016)

---

You could do this in a header, but there's no enforcement. People make changes to procs, test them, make more changes, test, fix things, test,...

dave.farmer (9/13/2016)

---

xsevensinzx (9/12/2016)Can't you just do that in code documentation? I think that's the biggest hurdle for me on justification. In all my stored procs for example, you have a...

Koen Verbeeck (9/13/2016)

---

The type of fact table that you want is called an "accumulating snapshot".

It contains one row for each lifecycle (e.g. a customer that creates a specific order in...

RonKyle (9/12/2016)

---

Regarding the dates, it's not uncommon for developers to advocate using an integer with the date in human friendly format, e.g. 20160912 for September 12, 2016. I would...