Eric M Russell (7/6/2016)

---

Although you can technically store unstructured data in SQL Server, the question is: Why would you?

If you're ultimately trying to import facts and dimentions (as properly defined...

tindog (6/29/2016)

---

Hey,

I'm completely new to SSAS and doing some research whilst working through tutorials to build my first analysis database.

One thing I'm unclear on is how different multidimensional and tabular...

leehbi (7/4/2016)

---

I'm starting to see more data sources from JSON based API's (mostly 3rd party). JSON must make the app developers life easier but it makes my life...

I really feel we go off the deep end in understanding these articles. For example, data scientist can already automate what they are doing in Python. It's very easy to...

Lynn Pettis (6/21/2016)

---

Good database design is needed in data warehouse and data mart systems just as it is needed OLTP systems.

Data Warehouses pulling data from multiple sources should cleanse and...

The problem will always be the amount of data to analyze I feel. I would love to see how it handles with rather large datasets in production.

Regardless, I think it's...

Thanks for depressing me Steve. I work in the digital advertising industry. 😛

Outside of that, it's insanely hard to jump ship and risk new endeavors with the latest tech startup...

I'm only going on 4 years now in my data role and have built a data warehouse (more than one database) and a number of data marts from scratch. I...

I use Python for this personally. Python handles this very well and is easier to maintain than .NET apps that sometimes just overcomplicates things. It works well in all environments...

Woops, I selected no before reading the third option. I want a do over 😛

Augment ETL to other systems when possible, audit/logging/benchmark all systems into one location for accessibility and viewability, meta is king, watch out for common SQL (or SSIS) antipatterns, use flowcharts,...

Brandie Tarvin (6/16/2016)

---

Eric M Russell (6/15/2016)

---

Brandie Tarvin (6/10/2016)

---

Steve Thompson-454462 (6/10/2016)

---

Brandie Tarvin (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL?...

I actually think it the opposite. I believe our so-called data engineers (who are ideally our existing BI developers, SQL developers, etc) will step into this role more than our...

Question is, why should I use this over the other options with Python and SQL Server?

David.Poole (6/9/2016)

---

There's also the bit where advertising execs claim every...