Yes, that certainly could be done. But we thought it would be an overkill. The log tables keep track of all scripts that were executed. That was enough for us.

Yes, I believe this is in the article...

ebooklub (10/28/2015)

---

From Hadoop theory/testing/improving you skills and working on own projects to landing position/contract in Hadoop

Mistakes/Methodology/Suggestions

Small history

1.Sybase

I was working for 2 years as production SQL DBA at...

GAURAV UPADHYAY (10/5/2015)

---

Hi Daniel,

A very informative and well written article indeed. Just wanted to know if lack of JAVA knowledge proved to be an impediment in exploring and learning hadoop....

Agree with Ian, sadly, a typical SQL Server DBA will have to learn much more to stay relevant in Hadoop / Spark business.

Daniel

ebooklub (10/3/2015)

---

Hi Daniel, thank a lot about DBA carrier path article.

Our company (investment bank ) few months ago came out with plan to use Hadoop.

One part...

All your visits to the website pages are logged into the weblog files that reside on the web servers.

These...

Pradeep Mohanta (10/1/2015)

---

Hi Daniel I am Pradeep Mohanta working as SQL Server Database Architechture. About Hadoop your feeling and learning steps/procedure are same as my feeling and learning steps....

ianstirk (10/1/2015)

---

Hi, thanks for this very useful overview.

You might want to know that Impala is a popular tool for querying data in Hive quickly (it uses in-memory processing instead...

ianstirk (10/1/2015)

---

Hi, thanks for this very useful overview.

You might want to know that Impala is a popular tool for querying data in Hive quickly (it uses in-memory processing instead...

Pradeep Mohanta (10/1/2015)

---

Hi Daniel I am Pradeep Mohanta working as SQL Server Database Architechture. About Hadoop your feeling and learning steps/procedure are same as my feeling and learning steps....

Yes, you are right.

There is a variety of the SQL frameworks on a top of Hadoop (besides Hive).

That is the subject of my next article I'm currently working on.

I finally found out how to do it!

I used the following call in Execute SQL Task

EXEC master..xp_cmdshell "BCP mydb..DETAIL out detail.dat -fD:\DETAIL.FMT -T"

Hey, took me sometime...

All is well that...

Would you suggest where or how to specify the NATIVE format for the output file?

I found a problem.

my_function was written by me incorrectly.