That's the point Phil is trying to make. Static data can be maintained by SSDT tooling, but as you said, a bit clunky.

I am in the process of transitioning our eCommerce database to the declarative model of SSDT to move the database development process into our CI pipeline. Using idempotent MERGE statements...

Here's a link talking about Spark.

http://aptuz.com/blog/is-apache-spark-going-to-replace-hadoop/

I'm no expert on this, but from the article, Spark is an alternative to Hadoop Map Reduce. Not really a replacement for the whole Hadoop...

I second that. Fantastic read. Great insight from someone who has obviously spent a lot of time working with the technology. Thank you for sharing.

Heh. See, I'm just the other way around. I sit and think all day long and do nothing. Perhaps I will do tasks for an hour this week just to...

Brian J. Parker (6/3/2015)

---

To add to what qbrt is (I think rightly) pointing out, you can check ERROR_NUMBER() in your CATCH block and if it is 50000, you'll know that...

Rob Reid-246754 (6/3/2015)

---

Ok, I totally get that as I do use TRY CATCH and all the ERROR_MESSAGE() ERROR_LINE() ERROR_NUMBER() ERROR_PROCEDURE() functions to get detailed errors in TRY CATCH statements...

IMO, cursors are there to be used for admin scripts to be executed manually. They can be a time saver.

The philosophy I attempt to maintain in my SQL Server environment...

RonKyle (6/1/2015)

---

Sometimes we use CURSORS in our order processing environment to move data between systems and changing statuses on each record processed. The main reason for using a cursor is...

Sometimes we use CURSORS in our order processing environment to move data between systems and changing statuses on each record processed. The main reason for using a cursor is that...

Alvin Ramard (9/9/2014)

---

Correct. ...

Chris Harshman (9/9/2014)

---

qbrt (9/9/2014)

---

So, isn't the star formation created for the data actually...

Good quick read. And I have a question on the specific statement made at the end of the article.

First, you can run reports directly against the schema since the data...

Hi David,

Thanks for your contribution. I am sure there is someone who may find this sproc very helpful. On the other hand, I shiver whenever I see a sproc with...

Very nice, Geoff.

Here's a script that generates a deadlock to force the alert. Good to test the job.

Shamelessly lifted from some other forum, and since it worked for me, I...