haha..good story about NES mini.

At the stage of my life, I would never do this for a consumer product that will become available after several weeks anyway. But...

My initial reaction and thought on SQL Server on *nix was along the same lines of Azure.

SQL Server engine on *nix opens up an easier transition for customers to begin...

Agree that having idempotent scripts are very important. The T-SQL implementation of having to use EXISTS() function to craft idempotent scripts is what the developers on our team dislike the...

xsevensinzx (9/13/2016)

---

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...

hmmmm, read a long time ago...can't recall who to attribute it to....

"The only measure of progress is working code in source control."

I've been managing all my coding projects with this...

David.Poole (9/9/2016)

---

There's not that can be added here.

The times I use a cursor are when I can't find a set based way of doing something. In which case I...

Gary Varga (2/22/2013)

---

TravisDBA (2/22/2013)

---

Gary Varga (2/22/2013)

---

Surely some of the responsibility is on the author's own integrity. After all suggesting that someone focusses on the positives and leaves out the...

Great read and thanks for taking the time to write it up and sharing.

Getting Jeff Moden's blessing observation and support is fantastic, as I value his opinions tremendously.

(modified: see Jeff's...

In my experience on bigger systems, until people within the organization that are in the decision making seats with enforcement authority feel the pain of the systems inadequacies, other things...

Phil Parkin (1/19/2016)

---

qbrt (1/19/2016)

---

Phil Parkin (1/18/2016)

---

Merge can be idempotent. I would recommend doing the UPDATE part of the MERGE only if an update is required. I do this via the

WHERE...

David.Poole (1/19/2016)

---

I can understand doing this for a very limited number of datasets. I think it would create problems for Kimball data warehouse systems where we need slow changing...

Phil Parkin (1/18/2016)

---

Merge can be idempotent. I would recommend doing the UPDATE part of the MERGE only if an update is required. I do this via the

WHERE NOT EXISTS (SELECT...

Phil Parkin (1/18/2016)

---

qbrt (1/18/2016)

---

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...